InsaneProgrammer
Programmer
I need to write some ADO code in an Access 97 database and am having trouble with the connection. How do I set the connection object to the current database? Do I need to provide a connection string like you do in visual basic? I seem to remember that in DAO there was a CurrentDb() function that was used to set the database to the current database. Is there something similar with the ADO connection? Any help would be greatly appreciated.