[RESOLVED] How to open *.mdb file(Access 2000 aplication) with VB6 code?

[Arnoutdv]

Do you want to automate MS-Access, or do you want to access a MDB?

[kutlesh]

Hmm, open the mdb and enable other users edit data in tables.

Also I might want run a macro.

Is there mixing the the approaches in the given code?

[DataMiser]

Hmm, open the mdb and enable other users edit data in tables.

Also I might want run a macro.

Is there mixing the the approaches in the given code?

Rather than opening an mdb which would be done via ADO with no need for any references to Access that you are trying to automate Access and have it open the mdb.

Your error message seems pretty clear either the mdb is already opened for exclusive access or it is not at the location the program is looking.
Make sure there are no copies of access running that may have the db locked, make sure that the db is where the program is looking for it.