Linked Tables

  • Thread starter Thread starter Josef
  • Start date Start date
J

Josef

hi,

i am curious to the advantages and disadvantages of linked tables.

we have a multi-user environment where the database sits on a shared
drive on the server. users have a shortcut to the database on their
desktop.

could anyone advise me on some advantages & disadvantages?

thx
 
Josef,

Is this a monolithic database? If that's the case it won't go far, sooner or
later (sooner being more likely) it'll start getting corrupted.
You need to split it to a front end / back end, leave the back end on the
server and districute a copy of the front end to each user. Browse through
the access.multiuser newsgroup, you'll find lots of interesting stuff in
there.

HTH,
Nikos
 
thanks nikos.

yes, it has the potential of being big.

so what you are recommending is that i should split access into a front
end and a back end for data storage.

joe.
 
Josef,

Yes, definitely. Use Access's built-in splitter wizzard (Tools > Database
Utilities > Database Splitter in A2K), it's a piece of cake. Then distribute
a separate copy of the FE to each user. Have a look at Tony Toews' auto FE
refresher at:

http://www.granite.ab.ca/access/autofe.htm

It'll come in really handy.

Also, have a look at another Tny Toews' page at:

http://www.granite.ab.ca/access/performancefaq.htm

It will help you improve your db performance enormously.

HTH,
Nikos
 
Back
Top