Access as front end to SQL Server

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

Guest

I have successfully managed to convert an existing Access project to use SQL
Server as back end db (thanks to some good advise from this forum). I'm going
to place the DB on a server. Question. What is needed to install on the
clients apart from Access? MDAC? ODBC? SQL Server client tools?
 
By DB, if you mean the SQL-Server or MSDE than nothing else is necessary.
With the latest update from the Microsoft Update Site, you should have the
proper version for MDAC installed with the required OLEDB providers.

For ODBC, you shouldn't need it at all if you have used the proper
connection string. If you need it or need a DSN, than change your
connection string to use the OLEDB Provider for SQL-Server instead.

As for the client tools, they are not necessary but it's not a bad idea to
have them readily available; just in case of.

S. L.
 
Back
Top