Splitting a Database: How?

[Valeriya]

SOS, I have an urgent request to split the Access Database, located on shared network drive among 4 people. Not sure how it suppose to be done, if the front-end has to have all the tables, all the queries, but certain reports and macros? Some of the tables are linked with SQL tables in our Access Database? How to apply the updates from my back end copy to all 4 front-end copies? If I'll be able to change the relationships, write a VBA function after splitting? Would the splitting allow users to run macros, queries simultaneously?
Thanks a lot!

 

[jadams0173]

Under Tools>Database Utilities> Database Splitter run the wizard and follow the steps. The backend will contain all the tables and the fronted will have the forms, macros, queries... and links to the backend tables. As long as you have access to the backend you can change anything as you normally would. Splitting would allow users to run macros and queries simultaneoulsy assuming that 2 users aren't updating the same records at the same time.

 

[KenReay]

Hi

To begin, there is a waizard to gouide you through this, ensure you ahve copy of your database BEFORE you start

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Valeriya]

Thank you, guys for the quick response! However, I still have some difficulties to understand what in case, if I'll change a formula in query or delete a relationship, how to apply those changes to front-end copies?
Thank you in advance,
Valeriya.

 

[jadams0173]

If each user has a copy of the front end on their PC's then you will have to distribute a copy of the new front end to each user. If the front end is being accessed from a network drive and all users run the same file, then the update takes effect as soon as you make it with no need to distribute a new front end copy.

If you have the front end on each users PC you can search this forum for good ideas on how to make sure each user has the latest version.

 

[Valeriya]

After I split an Access Database, 4 different front ends will be created on each user PC (I have to split a database by 4 different regions). How to make sure that each front end user has the latest version of his database, in case some major updates in the back end?
How to to distribute a copy of the new front end to each user?
Thank you in advance for your suggestions!
Thank you, jadams0173!

 

[evalesthy]

In the Microsoft: Access Modules (VBA Coding) forum go the the FAQ section and look at all the postings under "Multi User Databases". You will get a lot of great background information on managing split databases. Also do a Search in these fora and you will find many related posts.

 

[Valeriya]

Thaks a lot!

 

[jadams0173]

A quick search turned up this thread that has some code examples in it thread181-931490