Sloooow Queries

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I am running a series of delete and append queries from
an Access application running on laptops. The laptops
connect by dial-up to a RAS server and the target Access
database is on a server at the dial-in location.

The queries are deleting or appending just a few records
and the target tables contain only a few records but each
one takes 2 or 3 minutes to complete. If the tables were
in the laptop database they would run in a couple of
seconds.

I am using VB to run 6 SQL query statements. For example:

DoCmd.RunSQL "INSERT INTO products " _
& "IN '\\server\public\orderquotes\orderdata.mdb' " _
& "SELECT * FROM products " _
& "WHERE stMASordernum = [forms]![form1]!stMASorderid];"

I have removed the indexes from the target tables but
that was no help.

Many thanks to anyone who can help me with this.
 
Bob said:
I am running a series of delete and append queries from
an Access application running on laptops. The laptops
connect by dial-up to a RAS server and the target Access
database is on a server at the dial-in location.
Click to expand...

Running queries over a dial-up connection to an Access db is always very
sloooow.
 
I am running a series of delete and append queries from
an Access application running on laptops. The laptops
connect by dial-up to a RAS server and the target Access
database is on a server at the dial-in location.
Click to expand...

As MGFoster correctly says, linking Access databases across a dialup
is VERY slow; in addition, it's VERY risky! Access is extremely
sensitive to network communication drops, and this may irreversibly
corrupt your backend database.

If you want to do this, I'd suggest a different (albeit somewhat
tricky) method: Replication. See http://www.trigeminal.com and search
for Michka's Replication FAQ and use it as a resource. It's a fair bit
of work but it's much safer than trying to use a database split across
a dialup.
 
Back
Top