Split or Share

N

Nigel

I have a database which only 4 or 5 users need to use. What is the better
option: share the database or split it? Is one way better than the other
under certain circumstances.

Thanks
 
E

Eric Blitzer

Whenb more than one user is going to connect to a database it is better to
split. Put the tables on the server and the forms, reports... on each PC
 
D

Douglas J. Steele

Even with single user databases, I still always split. That way, you can
make changes to the application without having to worry about their existing
data.
 
N

Nigel

Many thanks, in other words, forget sharing!!

Douglas J. Steele said:
Even with single user databases, I still always split. That way, you can
make changes to the application without having to worry about their existing
data.
Click to expand...
 
D

David W. Fenton

I have a database which only 4 or 5 users need to use. What is the
better option: share the database or split it? Is one way better
than the other under certain circumstances.
Click to expand...

There are no options.

SPLIT.

ALWAYS.
 
N

Nigel

Now that I've split the database, I've got the BE on the server and have the
FE copies on two machines. I've re-linked the tables, but when I go into
either of the FE I cannot create any new data. What else do I now have to do?

Thanks
 
D

Douglas J. Steele

Each user must have Change permission (at least Read, Write, eXecute and
Delete) on the folder where the back-end file exists.
 
A

aaron.kempf

you don't need to split; these guys are full of hot air

you do need to use Access Data Projects to support that many users
with MS Access
 
N

Nigel

Many thanks

Douglas J. Steele said:
Each user must have Change permission (at least Read, Write, eXecute and
Delete) on the folder where the back-end file exists.
Click to expand...
 
D

Douglas J. Steele

David W. Fenton said:
Delete is not necessary.
Click to expand...

You're right that it's not absolutely necessary, but if they don't have it,
it can impact the ability to do compacts (since the ldb file won't get
deleted when the last user disconnects)
 
D

David W. Fenton

You're right that it's not absolutely necessary, but if they don't
have it, it can impact the ability to do compacts (since the ldb
file won't get deleted when the last user disconnects)
Click to expand...

Why would anyone other than an administrator be doing compacts? All
you have to do is give regular users MODIFY permossion and your
administrators CHANGE permission (i.e., with DELETE).
 
Top