MS Access to SQL server connection
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,