Table Linking Access 2000 FE / Access 2000 BE

[Timothy Golden]

Can anyone tell me what goes on beneath the hood with table linking in
Access?

We have a speed issue with our database. It uses access for the front
end and the back end. Prior to splitting the database it took 15
seconds to open it over the network. Now with the split it takes 2
minutes 15 seconds to open. We are exploring all options. Advice
Please!

-Tim

[Douglas J. Steele]

Tony Toews has some suggestions at
http://www.granite.ab.ca/access/performancefaq.htm and
http://www.granite.ab.ca/access/splitapp/index.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Timothy Golden" <tt*******@yahoo.com> wrote in message
news:5c**************************@posting.google.c om...

Can anyone tell me what goes on beneath the hood with table linking in
Access?

We have a speed issue with our database. It uses access for the front
end and the back end. Prior to splitting the database it took 15
seconds to open it over the network. Now with the split it takes 2
minutes 15 seconds to open. We are exploring all options. Advice
Please!

-Tim

[PC Datasheet]

The wire from the network server to your screen is much longer than the wire
from your harddrive to the screen. It's just like the Olymics - it takes
longer to run the Marathon than it take for the 100M hurdles. Check your
network to be sure there's not a defrocked Irish priest trying to push those
electrons off the network wire.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Timothy Golden" <tt*******@yahoo.com> wrote in message
news:5c**************************@posting.google.c om...

Can anyone tell me what goes on beneath the hood with table linking in
Access?

We have a speed issue with our database. It uses access for the front
end and the back end. Prior to splitting the database it took 15
seconds to open it over the network. Now with the split it takes 2
minutes 15 seconds to open. We are exploring all options. Advice
Please!

-Tim

[Silvia Hooks]

Yes also sometime the wire get all hot an swollen so the data come fast but
on cold day data come slow cause it all like shrunken.

Silvia
Jackson Town
"PC Datasheet" <no****@nospam.spam> wrote in message
news:%s******************@newsread2.news.atl.earth link.net...

The wire from the network server to your screen is much longer than the wire from your harddrive to the screen. It's just like the Olymics - it takes
longer to run the Marathon than it take for the 100M hurdles. Check your
network to be sure there's not a defrocked Irish priest trying to push those electrons off the network wire.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Timothy Golden" <tt*******@yahoo.com> wrote in message
news:5c**************************@posting.google.c om...

Can anyone tell me what goes on beneath the hood with table linking in
Access?

We have a speed issue with our database. It uses access for the front
end and the back end. Prior to splitting the database it took 15
seconds to open it over the network. Now with the split it takes 2
minutes 15 seconds to open. We are exploring all options. Advice
Please!

-Tim

[Tony Toews]

tt*******@yahoo.com (Timothy Golden) wrote:

We have a speed issue with our database. It uses access for the front
end and the back end. Prior to splitting the database it took 15
seconds to open it over the network. Now with the split it takes 2
minutes 15 seconds to open.

Refreshing the links to tables can be quite slow even in Access 97. This can get much
worse for the second and subsequent users into a shared MDB on a server. Once you've
successfully refreshed the first table open a recordset based on that table. Once
you've finished refreshing all the links close that recordset.

Then open a bound form or keep this recordset open if so desired depending on your
preference for better overall performance.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm