Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access+training+in+london - version control multiple adminis

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+training+in+london - Version control for multiple administrators

access+training+in+london - Version control for multiple administrators

ResolvedVersion Standard

Rachel has attended:
Access Introduction course
Access Intermediate course

Version control for multiple administrators

Is it possible to create some kind of version control over tables that are updated by other users?

For example Mr A, Ms B and Mr C maintain tables A, B and C respectively, but I need to run queries on the aggregate data (in tables A, B and C) at the end of each quarter.

I'd like to keep a 'trail' of data entered e.g. as at 31 December 2006 in the underlying tables as well as using 'save as' on my own queries.

Please help!

RE: Version control for multiple administrators

Try create another replica set made from a converted backup copy, will not be able to synchronize with the existing members in the original replica set.
Before replicating your database, it is recommended that you read about the changes that are made to a database when it's replicated.
Create a replica of your database by using the menu bar

Open the database you want to replicate. If you are working in a multiuser environment, make sure that all other users have closed the database.
If your database employs a database password to help protect it, remove the password.
How?

On the File menu, click Open.
Click the arrow to the right of the Open button, click Open Exclusive, and then open the database.
On the Tools menu, point to Replication, and then click Create Replica.
Click Yes when you are asked whether you want to close the database.
Click either Yes or No (Yes is recommended) when you are asked whether you want to make a backup of the database (this dialog box is displayed only if the database must first be converted to a Design Master (Design Master: The only member of the replica set in which you can make changes to the database structure that can be propagated to other replicas.) before the first replica is created).
In the Location of New Replica dialog box, do the following:
Select the location where you want to place the new replica.

Click the Priority button, type the priority for the replica, and click OK.
Check the Prevent deletes check box if you do not want users to delete records in the replica.

Select the replica visibility (visibility: A property of a replica that indicates which members of the replica set it can synchronize with and which conflict resolution rules apply. Replicas fall into three visibility types: global, local, and anonymous.) from the Save as type box.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.