|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
January 6th, 2003, 08:41 PM
|
|||
|
|||
Change my Access 2K BE from LAN server to SQL SERVER 2K OVER THE INTERNET HOW
I have an Access 2K application where the Back End, the actual data, resides on the LAN server and the front end, what the users see and use loaded on each desktop.
The front end tables were "Linked" to the Back End tables, containing the actual data, using the Tools>Database Utilities>Linked Table Manager. I'm just starting to read up on SQL SERVER 2K and found a web hosting service offering SQL SERVER 2K running on Win 2K Server. Could I achieve the same simplicity using, say ODBC connectivity, to "Link" my front end tables to the back end, recreated in SQL Server 2K on the web host? Thank you
|
|
#2
January 24th, 2003, 12:17 AM
|
|||
|
|||
|
depends if your host allows connections from the internet to the sql server. If they do then just include an odbc connection thingy (a file one) with ur front end. But i doubt the host allows this type of connection.
Learn ASP and write your front end as a Web page probably be faster.
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Change my Access 2K BE from LAN server to SQL SERVER 2K OVER THE INTERNET HOW |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
