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
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.
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
@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/
[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/
