Access with VPN

[smehnert]

Help...

I have just finished access 2000 database... loacally it works fine... but once I take it over a VPN it doesn't. The front end is about 20MB...

It seems when I try to open a form its caching part of the DB? I tried to open one of the smaller forms it uploaded 2MB?

Should I migrate the DB..? Does the host (win xp pro pc) need to have certain services running on it?

Please help..

Regards

Simon

 

[WayneRyan]

Simon,

Wow! 20Mb is a pretty large Front-End.

Did you: Tools --> Database Utilities --> Compact/Repair after you split them.

Anyway, what is probably happening is that you are basing your forms on tables.
Entire tables. This will lead to an unacceptable amount of network traffic.

You should base your tables on queries that restrict the amount of data
you'll need to move accross the net.

You can look here for "Search" forms. That's roughly the technique that
you should use.

Wayne