I have an application that used Access 2000 as backend and frontend. We moved backend to SQL 2000 and of course we are getting errors "record not updateable. etc..."
It seems that the whole CBF is DAO. If I leave the DAO code:
Dim db As Database
Dim rs AS Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("table name", dbOpenDynaset)
It does not work, it is looking for the db locally, and the tables are linked to SQL. Is there a way to keep DAO or am I going to have rewrite the frontend?
Thank You ahead of time.