I have created a ODBC name under the System DSN called 'Ready'.
I am unable to connect to this database using the OpenDatabase method of DAO.
my database file name is readyData.mdb
The syntax which I have written is as below:
Set g_db = Workspaces(0).OpenDatabase("Ready",False,False,"ODBC;DSN=Ready;UID=;PWD;")
Can anybody please help me to connect to this database using ODBC;