Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can I access a SQL2000 database on remote server with SQL7 or access 1
- Thread starter roblasch
- Start date
-
1
- #2
If you have access yes you can get around this. The first step is to setup a file dsn through the odbc admin. once this is done just add a linked table to an access database selecting an odbc source. select the odbc you setup and away you go. I also like to use this to create my SQL for ASP pages.
- Thread starter
- #3
That is so cool. I had pretty much given up and resigned myself to having to scrape up enough money to upgrade to 2000. But it works, and it is not too dificult. I give you tremendous thanks, and hope that I will someday have the knowledge to help someone in distress. Thanks again
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question