RE: Link updates are very slow

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On the network drive, be sure and use UNC paths. It will be much faster. Use
paths such as:
\\server\directory\filename
Google unc path names or check help.
--
Milton Purdy
ACCESS
State of Arkansas


"TADropik" wrote:

I have a .mdb on a network drive, L:\Data\data.mdb.
This database contains nothing but tables. About 100 of them.

I have a .mdb on a local computer C:\Data\data.mdb.
This database contains nothing but tables. About 100 of them.

I have a .mdb on a local computer C:\Data\client1.mdb.
This database links to all the tables in the .mdb C:\Data\data.mdb on the
same local.

I have another .mdb on a different local computer C:\Dta\Client2.mdb
This database links to all the tables in the .mdb L:\Data\data.mdb on the
Network.
This database has automated functions built in that update the data
periodically.

The problem I have is...

When I want to change the table links from C:\Data\Client1.mdb on the first
local to the tables on the Network, it takes forever for the link update to
finish.

If I close down C:\Data\Client2.mdb the update link process on
C:\Data\Client1.mdb happens exrtremely fast.

Anything I can do to speed up the link update from C:\Data\Client1.mdb to
L:\Data\Data.mdb while c:\Data\Client2.mdb is still up and running?
.

Relevant Pages

  • Link updates are very slow
    ... I have a .mdb on a network drive, ... This database contains nothing but tables. ... I have a .mdb on a local computer C:\Data\client1.mdb. ...
    (microsoft.public.access.tablesdbdesign)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: temp db
    ... If the database is not in use, you can create a copy just by copying the MDB ... The purpose is to create a temp db for all the ... ' This subroutine illustrates how to use a temporary MDB in your app. ...
    (microsoft.public.access.formscoding)
  • RE: Access to Access Automatic Updates
    ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... MS Office Master 2000 ed. ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)
  • RE: Access to Access Automatic Updates
    ... MS Office Master 2000 ed. ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)