I have a problem when connecting to a Access database using a vba plug-in made in Autocad 2000. I supposed that my problem is related to my secured Access file (MDW) that is setting the group security. I have tried a lot of variant way to connect my database but I am still stuck with it. Maybe someone could help me finding out what I am doing wrong or what should I do to fixed it. I am using the Access XP(2002) version on an XP platform with the ADO object.
I have try your connection string. It has almost work but I am still having one more problem. First, I have to tell you that my principal Access database is located on a network drive. If I am writing the DBQ paramater in the connection path as follows : f:\PrincipalDatabase.mdb, I am getting a 'err: -2147418113 Catastrophic error'. This not a very talkative error description.
Anyway, I have tried to see if it could be fixed by putting the database on my local drive (c:\PrincipalDatabase.mdb), And it finally worked out. The only thing is that it has to write my info on my network DB. I have tried by creating a local database that links all tables from the database to my principal network database. This workaround does not work. Do you have another way to do this?
Thanks a lot...
P.S.: I have noticed that your are using the Vbscript way to write the string by using the Server argument in front of the createobject function. It is not working for me in VBA.