|
| |
|
|
Dan Wheeler
Posts: 103
Joined: 12/31/2002
Status: offline
 |
connecting to sql with access - 3/19/2003 16:19:18
Can anyone point me to an article or something that will help me to connect to my online sql server 2000 via access? I know it can be done, but I can' t find the information to get it done. My host has given me the server IP, Database name, DSN, username and password. I have access 2000. Any help would be greatly appreciated.
|
|
|
|
Doug G
Posts: 1189
Joined: 12/29/2001
From: SoCal
Status: offline
|
RE: connecting to sql with access - 3/19/2003 17:18:26
You need Access 2000 or greater.
Open Access, and choose " Access database wizards, pages and projects"
Click the General tab, and then choose a new project. For your hosted SQL server you will want to choose the " .. Existing Database" option. You might want to install MSDE on your local computer, then you can work with your SQL Server data locally. MSDE is a SQL Server compatible database engine. With a local MSDE, you might want to create a project with a new database. This will create a new SQL database.
Once your " access data project" is open, you' ll have a different set of tools for working with a SQL Server db. The access project will be saved in a file with an .adp extension
_____________________________
======
Doug G
======
| |
|
|
|
Dan Wheeler
Posts: 103
Joined: 12/31/2002
Status: offline
|
RE: connecting to sql with access - 3/19/2003 22:24:47
Thank you Doug, that was basically what I was doing, and it made me think if some of my info was wrong. When I checked it out I remembered that when we moved the database onto the new server we had some problems with it, and the database name was changed. I changed the name in the login info and it works now. Thank you very much for your time.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
