Sharing a Database

Would like to know what is the best way to share a database on a share drive.
The db that I am working on right now is being shared by two individuals on
a share drive. However, the db bombs once in a while. When one person is on
no problems. Can someome pls guide me on what is the best way to share this
database? Thank you.

Split it into a front-end (containing the queries, forms, reports, macros
and modules), linked to back-end (containing the tables and relations).

Put the back-end on the shared drive.

Give each user his/her own copy of the front-end, and put it on their hard
drive.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"TotallyConfused" wrote in
message ...
Would like to know what is the best way to share a database on a share
drive.
The db that I am working on right now is being shared by two individuals
on
a share drive. However, the db bombs once in a while. When one person is
on
no problems. Can someome pls guide me on what is the best way to share
this
database? Thank you.

Thank you. Will the individuals looking at data on their copies be able to
see what the person entering data is updating even though they maybe looking
at the same data?

"Douglas J. Steele" wrote:

Split it into a front-end (containing the queries, forms, reports, macros
and modules), linked to back-end (containing the tables and relations).

Put the back-end on the shared drive.

Give each user his/her own copy of the front-end, and put it on their hard
drive.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"TotallyConfused" wrote in
message ...
Would like to know what is the best way to share a database on a share
drive.
The db that I am working on right now is being shared by two individuals
on
a share drive. However, the db bombs once in a while. When one person is
on
no problems. Can someome pls guide me on what is the best way to share
this
database? Thank you.

TotallyConfused wrote:
Thank you. Will the individuals looking at data on their copies be
able to see what the person entering data is updating even though
they maybe looking at the same data?

The ability will be the same as it is now.

Thanks for your response, however, are you saying that if I do all the above
my database will still bomb and run slow? If so, is there no way around it?

"Rick Brandt" wrote:

TotallyConfused wrote:
Thank you. Will the individuals looking at data on their copies be
able to see what the person entering data is updating even though
they maybe looking at the same data?

The ability will be the same as it is now.

TotallyConfused wrote:
Thanks for your response, however, are you saying that if I do all
the above my database will still bomb and run slow? If so, is there
no way around it?

No. I mean the ability (or lack thereof) to see changes made by other users is
not affected by splitting a database. Those capabilties will be the same as
what you have now. If you are satisfied with what you have now then splitting
will not introduce anything to make you unhappy in that regard.

It WILL provide many benefits that have nothing to do with this issue.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com