Replacing a SQL Server DB with an Access DB

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!