Hi,

I have an Access app split between front and and backend - and I've just upsized my Access backend to SQL server - and I've linked the tabled to my Access front end.

I'm a bit confused now - in my Access front end I have my original connection as follows:

SET db = ws.opendatabase("XXXX.mdb", False, False, "MS Access:PWD=")

Now that my data is on SQL Server how do I set db to point to SQL server. I refernce db throughout my code.

Thanks for any help,

Ian

It sounds like you were using DAO. DAO does not work with SQL Server. You will have to convert your code to ADO.

Are these tables linked or remote?

mmcdonal

Yes, I'm using DAO - it's an app that's quite old - and the tables are linked.

You will need to use ADO. If the tables are linked, it sounds like you are using a DSN. So you will need to make sure that the DSN is installed on each workstation.

Do this to talk to your local data with code (otherwise just make everything bound to tables and queries):

Dim rs As ADODB.Recordset
Dim sSQL As String

sSQL = "SELECT * FROM tblCustomers"

Set rs = New ADODB.Recordset
rs.Open sSQL, CurrentProject.Connection, adOpenDynamic, adLockOptimistic

This will allow you to do most of the work with the SQL tables.

HTH

mmcdonal