A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Database distribution



 
 
Thread Tools Display Modes
  #1  
Old February 12th, 2009, 10:35 AM posted to microsoft.public.access.tablesdbdesign
LindaBee
external usenet poster
 
Posts: 52
Default Database distribution

I have created a database which works well and now it is ready for user input
I have read in various forums that you need to split the database in 2 FE and
BE which I have done I have also read that you need to make a copy to put on
each users desktop.

Here lies the problem: I have almost 200 user does that mean I will have to
make about 200 copies and go to each desktop to install the copy. is there an
easier way of distibuting the database or do I make one copy and get each
user to copy it onto their desktop.


  #2  
Old February 12th, 2009, 01:32 PM posted to microsoft.public.access.tablesdbdesign
Golfinray
external usenet poster
 
Posts: 1,597
Default Database distribution

I put a copy on the network drive that everyone uses and then have them copy
it to My Documents. Then all they have to do is make a shortcut to it.
Remember that the users must have read/write/edit/ and delete rights to the
folder the BE resides in and the BE. Then Tony Toews has an updater where you
can automatically update all 200 user's as you update the frontend. Google
Tony Toews (or maybe it is Teows) to find his site.

"LindaBee" wrote:

I have created a database which works well and now it is ready for user input
I have read in various forums that you need to split the database in 2 FE and
BE which I have done I have also read that you need to make a copy to put on
each users desktop.

Here lies the problem: I have almost 200 user does that mean I will have to
make about 200 copies and go to each desktop to install the copy. is there an
easier way of distibuting the database or do I make one copy and get each
user to copy it onto their desktop.


  #3  
Old February 12th, 2009, 01:51 PM posted to microsoft.public.access.tablesdbdesign
LindaBee
external usenet poster
 
Posts: 52
Default Database distribution

Thanks I will do that when we are ready to deploy, much appreciated also I
have seen posts about workgroups is that something I should be looking at?

"Golfinray" wrote:

I put a copy on the network drive that everyone uses and then have them copy
it to My Documents. Then all they have to do is make a shortcut to it.
Remember that the users must have read/write/edit/ and delete rights to the
folder the BE resides in and the BE. Then Tony Toews has an updater where you
can automatically update all 200 user's as you update the frontend. Google
Tony Toews (or maybe it is Teows) to find his site.

"LindaBee" wrote:

I have created a database which works well and now it is ready for user input
I have read in various forums that you need to split the database in 2 FE and
BE which I have done I have also read that you need to make a copy to put on
each users desktop.

Here lies the problem: I have almost 200 user does that mean I will have to
make about 200 copies and go to each desktop to install the copy. is there an
easier way of distibuting the database or do I make one copy and get each
user to copy it onto their desktop.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.