Front end on local computer be on a web server

B

bert

Can I link tables from my local computer to a web server where we store
the back end of an access 2003 database?
 
J

John Vinson

Can I link tables from my local computer to a web server where we store
the back end of an access 2003 database?
Click to expand...

Not if you want it to work effectively, no. Access frontend/backend
links are VERY demanding of network speed and stablility, and work
over a fast, stable LAN - not over the internet.


John W. Vinson[MVP]
 
A

Albert D. Kallal

bert said:
Can I link tables from my local computer to a web server where we store
the back end of an access 2003 database?
Click to expand...

Sure, but you will have to be networked to that comptuer. A internet
conneciton to that web server is WAY WAY too slow.

Remmber, a high speed t1 interline is still 100 times slower then your
cheap-o office network.

so, if you are on the same network at the web server...then, yes..you can do
as you ask.....

if you are not connnected to the same network, or are talking about a wan,
then likely sql server would be better. I explain some of your options when
using a wan as opposed to a LAN here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
 
Top