By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Access Dragging it's feet on a WAN/VPN

P: 3
I am currently developing a database that is split into a frontend/backend both stored on a file server.

Currently whenever the database is used over the WAN it is a bit slow, but really gets slow on VPN. It does use a lot of SQL to import data into the Backend tables and does several DLookup's of data.

Other applications appear to work ok on WAN and VPN.

Is there any way of speeding it up.
Jul 18 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
The Dlookup() function (and other "D" functions) tend to be slow.
It's better to used JOIN's in queries (and/or subqueries) to speed-up the process.

Best would be to have a non-access backend database (e.g. SQL Server 2005 or the free MySQL) and issue "Pass through" queries. (Check the helpfile for the basics). These only transport the filtered data instead of the entire table that Access needs to issue the query...

Aug 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.