database splitting

  • Thread starter Thread starter David Mainland
  • Start date Start date
D

David Mainland

It is my intention to split a database and access the back
end over a peer to peer network from three front ends.
Can I do so and alter the front ends. In other words, I
want to remove invoicing forms, queries and reports from
one PC so the operator doesn't have access to the data.
If this is doable, is there any pitfalls. Any help would
be appreciated.
 
It is my intention to split a database and access the back
end over a peer to peer network from three front ends.
Can I do so and alter the front ends. In other words, I
want to remove invoicing forms, queries and reports from
one PC so the operator doesn't have access to the data.
If this is doable, is there any pitfalls. Any help would
be appreciated.
Click to expand...

Absolutely. The frontends merely contain links to the tables; they
don't contain links to each other, and there is no requirement
whatsoever that they be identical. You can, if you wish, even have
different frontends linking to different subsets of the tables in the
backend.
 
In theory this sounds like it will work. A word of
caution, however: When we split on our peer-to-peer, the
performance decrease was considerable. Basically it took
x10 as long to open some forms. What I ended up doing was
using one computer as a "pseudo-server" (the one with the
most kick) and setting up record level locking. So
basically everyone will be accessing the same application,
but there will be some rules as to how they update
information simultaneously.
 
Trent said:
In theory this sounds like it will work. A word of
caution, however: When we split on our peer-to-peer, the
performance decrease was considerable. Basically it took
x10 as long to open some forms.
Click to expand...

See the Access Performance FAQ at my website.

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
 
Back
Top