If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Sharing a Database
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. |
#3
|
|||
|
|||
Sharing a Database
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. |
#4
|
|||
|
|||
Sharing a Database
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. |
#5
|
|||
|
|||
Sharing a Database
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. |
#6
|
|||
|
|||
Sharing a Database
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Date range on reports | Mark_Milly | Setting Up & Running Reports | 10 | January 19th, 2006 03:49 PM |
Sharing a database | Owltrax | General Discussion | 9 | October 10th, 2005 03:51 PM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
sharing database | mhmaid | New Users | 1 | August 11th, 2005 01:24 PM |
Access can't open database | Scott B | General Discussion | 1 | June 28th, 2005 04:16 PM |