Linked Tables

[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

 

[Nikos Yannacopoulos]

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

 

[Josef]

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.

 

[Nikos Yannacopoulos]

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