Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Multiuser database

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Multiuser database

Resolved · Medium Priority · Version 2007

Reply Fri 27 May 2011, 13:47Delegate Dorota said...

Dorota has attended:
Access Introduction course
Excel Intermediate course
Excel Advanced course
Access Intermediate course
Excel VBA Intro Intermediate course

Multiuser database

Hi

I wonder if a database can be set in mustiuser mode so a few people can work on it at the same time?

I would appreciate your advise on this.

Thank you

Dorota

For upcoming training course dates see: Pricing & availability

Reply Fri 27 May 2011, 14:15Trainer Simon said...

RE: multiuser database

Hi Dorota,

Thank you for your question.

You could split the database which keeps the data(tables) in the main database and creates a new front end database that contains the forms, queries and reports. The front end is linked to the main database.

http://support.microsoft.com/kb/304932

The other person could open up the front end copy and create their queries, forms etc.

I hope this answers your question.

Regards

Simon

Fri 3 Jun 2011: Automatically marked as resolved.

Access articles

· Getting To Grips With Templates In Access 2007
· Material covered on a Microsoft Access Course
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data
· MS Access and Database Normalisation
· Data validation in MS Access

Please browse our web site to find out more about
advanced microsoft access courses in london and other Microsoft training courses.

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips