Access 2003, sharing application over a Novell Network

[Guest]

I recently built a simple 12,000 record database (a little over 7 MB) for my
assoicates all over the country via our VPN . It was created in Access 2003,
converted to Access 2000, and runs off a shared drive on a Novell server in
Washintgton DC. The response times have been incredibly slow, upwards of a
minute to query an initial record tied to the primary key. (although it
responds instantly when running off a single stand alone PC)

Does anyone have any tips about how I can make it run quicker or respond
faster over a Novell network via VPN? It's pretty much dead in the water
now. (I already doubled the default server settings for the file and locks)

Thanks, Tom Welte

 

[Baz]

Running an all-Access application over a VPN is an absolutely terrible idea.
The only ways to get acceptable performce will be to *either* convert the
application to use a server database engine such as SQL Server *or* have the
users run it via Terminal Services.

 

[Synapsys]

Tom,

BAZ is correct. Access over IP doesn't perform well unless in a LAN.
VPN will always be a dog. You could also try putting the mdb on an
IIS server and writing some ASP scripts or use the Access Data Pages
to access/input the data.

regards,

Todd

 

[Albert D. Kallal]

I expain the solusions to running access on a wan here:

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