Can you call an Access database on another server?
Is it possible to work with MSAccess database that resides on another server? If so, how do you call it with a DSNless connection? Also, how do you find out the column/field names in a table?<BR><BR>Thanks in advance<BR>
But, your connection string would just have a UNC path to the database instead of a drive letter:<BR>oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _<BR> "Data Source=\servernamesharefoldermyDb.mdb;"<BR><BR>But , you need to make sure that you that IUSR_MachineName has permissions to the other machine.<BR><BR>-Doug