Re: Access as front end to SQL Server
From: Sylvain Lafontaine ("Sylvain)
Date: 10/16/04
- Next message: G. Vaught: "Re: Using Access 2003 to Link to Paradox Data"
- Previous message: Noah Kaufman: "Using Access 2003 to Link to Paradox Data"
- In reply to: folke: "Access as front end to SQL Server"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 16 Oct 2004 14:54:42 -0400
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.
"folke" <folke@discussions.microsoft.com> wrote in message
news:C5A962F7-BF50-4902-B19F-1B5A72C70342@microsoft.com...
>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?
> --
> Folke
- Next message: G. Vaught: "Re: Using Access 2003 to Link to Paradox Data"
- Previous message: Noah Kaufman: "Using Access 2003 to Link to Paradox Data"
- In reply to: folke: "Access as front end to SQL Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
