Access application convert the backend access to SQL

[Guest]

Hi!
I have a large Access VBA application, I want to simply drop the access
database and point to SQL server, the database part is an easy (sort of), but
all my code that was pointing to Access I want to point it to SQL Server. Is
there a converter or an easy way to point now the recordset to SQL server??

Regards, Joel

 

[Arvin Meyer [MVP]]

You can simply link to the SQL-Server database in much the same way as
Access. I always use ODBC because it works with almost anything. Go to the
ODBC applet in the control panel (under Administrative Tools) and set up a
DSN to your SQL-Server database. Then in the Access file menu, choose Get
External Information and change the database type to ODBC. Then locate your
DSN and link the tables.

 

[Guest]

Thanks Arvin

You can simply link to the SQL-Server database in much the same way as
Access. I always use ODBC because it works with almost anything. Go to the
ODBC applet in the control panel (under Administrative Tools) and set up a
DSN to your SQL-Server database. Then in the Access file menu, choose Get
External Information and change the database type to ODBC. Then locate your
DSN and link the tables.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com