I am trying to connect to a MS Access DB residing on the internet using a DSN-less connection from my local PC. I have set the connectstring to:
lsDataBase = "DRIVER={Microsoft Access Driver (*.mdb)};"
lsDBName = "lsDataBase = lsDataBase + "DBQ=" + lsDBName + ";"
sqlca.DbParm=lsDataBase
Connect using sqlca;
Every time it tries to connect it opens a DSN window asking me to select one. I believe the problem is in the path to the database but I don't know what to change it to. Any help would be appreciated.
lsDataBase = "DRIVER={Microsoft Access Driver (*.mdb)};"
lsDBName = "lsDataBase = lsDataBase + "DBQ=" + lsDBName + ";"
sqlca.DbParm=lsDataBase
Connect using sqlca;
Every time it tries to connect it opens a DSN window asking me to select one. I believe the problem is in the path to the database but I don't know what to change it to. Any help would be appreciated.