Hi all,
I have very very old program in MS Access (originaly 2.0, somehow converted into 95). Data are stored together with business logic in .mdb file. It does not works more, so I was asked to convert into 2003 and deploy database in MS SQL server.
My first step was to register DAO dao2535.tlb, and link tables using ODBC connector. Well, it works, but some functions throw errors <Runtime error 3219> which seems to be SQL syntaxt conflict.
So, project is able to be used for some months, but finally I have to make some serious solution. What will you advice me? Instead of old and obsolete DAO methods, datasets use ADO or OLEDB or ODBC?
Thanks for any answer
I have very very old program in MS Access (originaly 2.0, somehow converted into 95). Data are stored together with business logic in .mdb file. It does not works more, so I was asked to convert into 2003 and deploy database in MS SQL server.
My first step was to register DAO dao2535.tlb, and link tables using ODBC connector. Well, it works, but some functions throw errors <Runtime error 3219> which seems to be SQL syntaxt conflict.
So, project is able to be used for some months, but finally I have to make some serious solution. What will you advice me? Instead of old and obsolete DAO methods, datasets use ADO or OLEDB or ODBC?
Thanks for any answer