question

hjmayer avatar image
hjmayer asked

how do i access an sql server database from ms access

i just installed sql server 2000 on a laptop for test purposes. On my client pc i want to link tables to an ms access database, but can't seem to locate the sql server database. i picked import/linked table and picked odbc as the type of database. I then selected new for the DSN Name. i then selected sql server as the driver. when i browse to to my laptop folder where the database is i don't see any files to select. i am looking in C:\Program Files\Microsoft SQL Server\MSSQL\Data folder. what am i missing
microsoft-accessnewbie
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image
KenJ answered
On the same screen where you entered the name and description of your DSN (I think it's the screen after choosing "SQL Server" for the driver), there should be another field for the name of the SQL Server. Type in or select the instance to which you want to connect. This is typically in the format of machine_name/instance_name or just machine_name for a default instance. You will then be taken to a screen where you enter your authentication information (NT Authentication or SQL Server Login) Once you are connected to the instance, you will be able to pick your database from a list of databases on the server.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

so now i finally got to the screen where it asks how should sql server verify authenticiy of the login id. I installed sql server on an xp box. do i pick sql server authentication using login id and password entered by user. where is the userid and password setup. screen defaults to administrator
0 Likes 0 ·
Leo avatar image
Leo answered
@hjmayer - have a look the link below.... hope it helps -
[sql-server-database-to-ms-access-using-link-tables-in-ms-acces][1] [1]: http://sqlserverpedia.com/blog/uncategorized/how-can-i-link-a-sql-server-database-to-ms-access-using-link-tables-in-ms-access/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.