multiple tables

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

Hi all,

i have a netwok application that read tables in 3 different mdb files.

Would it be a good idea for the network load to put all the table in
one mdb files instead of three.

Best regards,
Pierre
 
Would it be a good idea for the network load to put all the table in
one mdb files instead of three.
Click to expand...

It's not really a question about network loads, it's about application
integrity. If the three tables are related -- in other words, if there are
rules that constrain what can happen to one table depending on the contents
of another table -- then they _have_ to be in the same mdb file.

As a second point, if you are even slightly worried about your network
capacity or efficienc, then just don't use mdb sharing. Move straight onto
MSDE. Jet sharing is highly susceptible to network problems and time-outs
or even a rogue NIC somewhere else on the network can corrupt an mdb file.

Hope that helps


Tim F
 
As a second point, if you are even slightly worried about your network
capacity or efficienc, then just don't use mdb sharing. Move straight onto
MSDE. Jet sharing is highly susceptible to network problems and time-outs
or even a rogue NIC somewhere else on the network can corrupt an mdb file.
Click to expand...

What's a NIC?
 
Jesper Fjølner said:
What's a NIC?
Click to expand...

Network card.

One of the few pieces of computer hardware that can "work poorly". By that I
mean that most hardware either works or it doesn't. NICs can work less than
optimally and many programs wouldn't care other than performance. Access is a
bit of a canary in the coal mine for this area. A poorly working NIC will
usually butcher an Access file in short order.
 
@newssvr11.news.prodigy.com:

Like he said,
A poorly working NIC will
usually butcher an Access file in short order.
Click to expand...

.... wherever it is on the network; even if it's not directly involved in
the Access application at all...


B Wishes


Tim F
 
Back
Top