Did you set the odbc connection up?
Printable View
Did you set the odbc connection up?
2 pieces of advice:
Make sure the connection string uses the right driver. Also, I think you should use both ADODB.Recordset and ADODB.Connection to connect:
oConn.Open strConnect, "Admin", "YOUR_PWD"
oRec.Open "TableName", oConn, adOpenStatic, adLockOptimistic, adCmdTable
jdavison: Yes, I did..
sastraxi: I'm pretty sure I'm using the right driver, and I always connect to my SQL Server DB in the way I did and it works just fine, so unless there's some difference between SQL Server and Access (in connecting with it, I mean), this should work too..
Anyone else maybe?
Thanx!