Access 2000/Locking

[jacobl]

Is there support for Access 2000 databases in DAO anywhere? Opening them with the version I have gives me an invalid format exception . . .

Also, this concerns locking. I have some code that does quite a bit of database work, opening a recordset, iterating through items, searching other recordsets, etc. . . at the very end I am trying to open a recordset and delete any records found, the delete fails with an error of code 3260 (http://msdn.microsoft.com/library/sdkdoc/daosdk/daderr08_2z3o.htm) No other recordsets have been opened with this table, and the error occurs when the app is completely restarted. What could be causing this? Thanks,

JL

[aamirdogar]

Hi, this is Aamir Dogar.
I saw your q? at codeguru and realize that you are aN Office 2000 user. I want to know how can you interface the *.mdb files of Access 2000 with Visual Basic 6 form manager. It gives the error of unrecognize file format.

Please help me to sort out this problem. at aamirdogar@hotmail.com

[darth vader]

u would not be able to use any MDB file created in MS ACCESS 2000 because the mirosoft MDB jet dbase engine of the MFC would not be able to support that....It requires an engine version of 3.5 higher....

Furthermore Microsoft has introduced a new approach of Dbase programing using th ADO Recordset

Possible solutions

(i) use the ADO Recordsets,

(ii)if u insists on DAO Recordsets u have to convert u MDB file to an earlier version of MS ACCess 97 by using the TOOL menu,database utilities to convert it from Access 2000

(iii)ODBC REcordSet --no problem

This should be sufficient for u


Darth vader

[Sadhu]

Yes,

You need to install Ms Jet4.0 and DAO 3.6. If you have Office 2000 on the machine Jet Part is done for you, you still need to install DAO3.6

Look at the KB artical

http://support.microsoft.com/support/kb/articles/Q236/9/91.ASP?LNG=ENG&SA=MSDN&FR=0

Sadhu