Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Conecting to Access via DSN
December 5, 2003, 2:08 pm
rate this thread
I do not have any password on my Access mdb file
All I have done is select a USER DSN and MS Access Database, and browsed to
dsn = "DSN=SampleDE;PWD=;"
Set connection = Server.CreateObject("ADODB.Connection")
Set rsTables = Server.CreateObject("ADODB.Recordset")
Please any help on this
Re: Conecting to Access via DSN
Just post it once, someone will eventually get to it....
Make sure you set and test your DSN.
Make sure the file has read write access.
Make sure it can be shared.
Make sure the DSN has access.
Switch to a DSNless connection (search google for "DSNless connection
ASP Access" for sample code)
Error checking maybe?