hello! i'm trying to add a password to my database, which is access. but when password is already set and trying to test the connection, i got a message that "....database cant be access. because it is open exclusively". I use the wizard in connecting a db.
Is there an Access locking file (*.ldb)?
If so, and you're sure there is no-one in the database then delete this file.
Alternatively move a copy of the *.mdb to another location and try connect to that version.
are you discussing VBA (Visual Basic for Applications, run from within Access, Excel, or other applications) or standalone Visual Basic?
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert