Forum home » Delegate support and help forum » Microsoft Access Training and help » Split Database

Split Database

ResolvedVersion 2003

Wed 4 Mar 2009, 15:11 Delegate Jo said...

Jo has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel Intermediate course

Split Database

I need to split a database which willbe used over 7 sites, and will be accessed by 130 staff. Most likely, only 40 staff will actually ever access it, but all staff need to be able to access it if the need arose.

Is there any easy way of updating the links, and installing the front end without visiting all locations and installing this on each desk?

Thu 5 Mar 2009, 10:01 Trainer Stephen said...

RE: Split Database

Hi Jo

Thank you for your question

The front end databases would all need to be installed separately on each machine. Possible solutions would be to either email the database to each user with instructions on how to refresh the links. Alternatively you could send the database to your IT support people at each site and get them to do it for you

Regards

Stephen

Wed 11 Mar 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

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

Split Database

Split Database

RE: Split Database

Access articles

Access tip:

Random sampling