Re: Faster than Access?
From: Morgan (abcd_at_senditon.com)
Date: 07/16/04
- Next message: Dan Guzman: "Re: Logging in irrespective of database access"
- Previous message: Brad: "Re: Restoring from MDF and LDF"
- In reply to: Ken: "Faster than Access?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 15 Jul 2004 19:07:49 -0500
If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
>
> Ken
- Next message: Dan Guzman: "Re: Logging in irrespective of database access"
- Previous message: Brad: "Re: Restoring from MDF and LDF"
- In reply to: Ken: "Faster than Access?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
