Connecting to MS SQL Server 2000

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

Guest

How do I connect to SQL Server 2000 from Access 97?

I would like to keep using my existing forms/queries/reports created in Access but
storing data in SQL Server

Hopefully this will help overcome a lot of the multi-user access issues we currentl
have with Access 97

Thanks
 
you can use linked tables, connecting by an ODBC-DSN
(File->external data->link->filetype: odbc)

you can use pass-through queries
-----Original Message-----
How do I connect to SQL Server 2000 from Access 97?

I would like to keep using my existing
Click to expand...
forms/queries/reports created in Access but
 
gandalf said:
you can use linked tables, connecting by an ODBC-DSN
(File->external data->link->filetype: odbc)
Click to expand...

I much prefer DSN-Less connections as it is one less thing for someone
to have to configure and one less thing for the users to screw up.

Using DSN-Less Connections
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafast/GetFile.aspx?file=ODBCTutor01.htm&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top