How to open MS-Access 2.0 database using VB
Posted on 2002-05-19
I have 1 access 2.0 database file which will used as main database of my simple program. I use VB 5.0.
I want to keep it's version, n dont want to convert the database to next versions.
When i try to open the xx.mdb file using office 97 and office2000, it shows error :
1. Record(s) cannot be read; no read permission on 'MSysObjects'.
2. Record(s) cannot be read; no read permission on 'MSysACEs'.
3. You can't make changes to the database objects in then database 'xxx.mdb'
The database is created in an earlier version of Microsoft Access. Etc ......
I had tried to open it with excuslive open, and it didn't work.
When i use VB and ADO 2.5, is shows error (debug) :
Record(s) cannot be read; no read permission on 'YYYY'.
Note : YYYY is a table in that db.
Any pro can help me ?