Access should be made to run on a Wide Area Network

[SS Analyst]

I work for a company that employs about 15000 people. Hurricaine Katrina
destroyed our LAN and we were forced to move everything to another state.
Our network now operates on a WAN. My Access databases run extremely slow,
the ones with a large number of records in the tables are impossible to run
and it is very frustrating.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...419&dg=microsoft.public.access.tablesdbdesign

 

[John Vinson]

On Mon, 7 Nov 2005 12:21:02 -0800, "SS Analyst" <SS

I work for a company that employs about 15000 people. Hurricaine Katrina
destroyed our LAN and we were forced to move everything to another state.
Our network now operates on a WAN. My Access databases run extremely slow,
the ones with a large number of records in the tables are impossible to run
and it is very frustrating.

Good idea - but it won't happen soon.

Two suggestions:

- Use MSDE or SQL Express to migrate your data to a SQL server (with
appropriate modifications to your applications, if necessary) and link
to that rather than to a JET backend

- Use Terminal Server or Citrix as a "thin client" to connect over the
WAN

John W. Vinson[MVP]