FE/BE Question

[Ray Stantz]

I am in the process of splitting a database for the first time and had a question. I see many people state that the FE should be loaded on each user's computer so that they have their own. Does this mean they will not have a shortcut on their desktop but instead a mdb file for the FE? And if so, how will they be able to pull the workgroup file without the shortcut if they are just clicking on the FE.mdb file?

Your assistance is greatly appreciated and if anyone can point me to a step by step tutorial i would also greatly appreciate that!

Ray...

 

[pbaldy]

I suspect many do something similar to me. I use a version control utility that checks for new versions on the server. If it finds one, it copies it to the client. Either way it then starts the FE. Therefore, my users have a shortcut to this utility on their desktop.

Can't answer on the security question, since I don't use it, but presumably the path used by the utility could include the security bit.

 

[Ray Stantz]

I suspect many do something similar to me. I use a version control utility that checks for new versions on the server. If it finds one, it copies it to the client. Either way it then starts the FE. Therefore, my users have a shortcut to this utility on their desktop.

Can't answer on the security question, since I don't use it, but presumably the path used by the utility could include the security bit.

How would i go about locating or creating a version control utility?

 

[pbaldy]

I wrote mine, but several have been posted here. Here's one:

http://www.access-programmers.co.uk/forums/showthread.php?t=111132

 

[Ray Stantz]

I wrote mine, but several have been posted here. Here's one:

http://www.access-programmers.co.uk/forums/showthread.php?t=111132

Thank you for your help! I'll try this out and i'll keep searching for the answer to my security question.

Ray

 

[Wiz47]

I am in the process of splitting a database for the first time and had a question. I see many people state that the FE should be loaded on each user's computer so that they have their own. Does this mean they will not have a shortcut on their desktop but instead a mdb file for the FE? And if so, how will they be able to pull the workgroup file without the shortcut if they are just clicking on the FE.mdb file?

Your assistance is greatly appreciated and if anyone can point me to a step by step tutorial i would also greatly appreciate that!

Ray...

The fe is linked to the be and the usual permissions to the WG files apply. (which the administrator sets up). So if a person has a copy of the fe on their system but does not have permissions to retrieve the be, they would just sit there and spin their wheels - so to speak. The administrator can update the fe on any computer at any time from the server at his discretion or an automated system can be used as has been described here.

 

[MicroE]

How would i go about locating or creating a version control utility?

You can also use a simple batch file to update the FE and launch the db.
http://www.myaccesstips.com/deploy/deploy.html