Access application convert the backend access to SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 :)
 
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.
 
Thanks Arvin

Arvin Meyer said:
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
Click to expand...
 
Back
Top