I'm an Access novice.  A small Access 2000 database
stopped working when I installed Office XP.  I get a "You
can't assign a value to this object" error from Access
and a VB error "runtime error 1004".  It goes to debug

300 sConnect = "[Excel 8.0;HDR=YES;DATABASE=" & sFile & "]" & sTable
310 Codedb.Execute "INSERT INTO tblCB_Cashbook_Import SELECT * from " &
sConnect & ";", DAO.dbFailOnError
After conversion from A97 to A2K, the Import fails with message:

I run Win XP Pro and use both Access 97 and Access 2003.
To run any database I need to right click on the icon and then select "Open
with" and then select the correct version of Access.
I tried changing the icon properties (for the Start in field) to make sure

I am trying to take a customer list from excel and put it
into an access database.  Everything works fine up until
all the data is converted and one of the fields
the "state" field which is FL for florida is justified to

All,
Is there any way to write a program to retrieve a bitmap from a field and
save it as a separate .bmp file?  Any sample code (VB, C, etc.) anywhere?
Thanks,

I hope that this is not off-topic for this group.  How can
I export Access reports to PowerPoint?
Thanks,
Rich

After I converted an Access97 Database to Access2K, some
of the queries opened with no problems, some others gave
me an error message "ODBC-- Call Failed [Microsoft][ODBC
Visual FoxProDriver]Index does not accept Null (#886)"

How do I convert a database in Excel into Access?
Thanks

We are converting some of our databases over to
Access2000.  Others in the company are still using
Access97, so, we are using the old system.mdw file to join
to the workgroup.  However, when using 2000 I cannot see

I know this is a long shot, but my original mail
list/address book was built on MS Access. Any way to
convert it over to MS Outlook Express Version 6?  Or am I
gonna have to manually input it into Outlook?

Has anyone been able to locate the access 2.0 conversion
utility for Access 2003?

We are running Access 2000 against a database on a network
drive.
I have a query in this database that resets an autonumber
field (jrnl_line_nbr) back to 1 when a criteria is met.

I am trying to create an MDE file from my MDB file but I
am getting an error and access closes.  When I send the
error report to Microsoft they refer me to this article
http://support.microsoft.com/?kbid=814858

Does anyone come across this kind of problem? and how do
you solve the problem?
I have a database developed in Microsoft Office
Professional XP,but in Access 2000 format.

we have an access97 db which has 32405 rows, is there such
a limit of 32700 rows in access 97 and if there is, can
this be rosolved by upgrading to Access 2000 or higher.