split database

AI Training: For Busy Decision Makers & Professionals Book now

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

Split database

resolvedResolved · High Priority · Version 2010

Stuart has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Split database

I've recently split a database as we have 3 users. The front end forms are saved on the server and the back end is saved on my PC.

Now I'm the only user able to access the forms and database. I've shared the folder on my PC that contains the back end to no avail.

we're still getting a message saying the path is not valid.

Help..!

Edited on Wed 19 Jun 2013, 15:35

RE: Split database

Hello Stuart,

Hope you enjoyed your Microsoft Access courses with Best STL.

Thank you for your question regarding Splitting a Database.

There are many issues related to splitting a database such as: pros and cons; where to place the backend file and where to place the frontend file; security issues both for frontend and backend. All these issues must be addressed before actually splitting.

If you wish to revert back to the way it was then first make a backup of the backend file. After this, open the backend file and import all forms, queries by selecting all. Check that your relationships are still there.

Then rename the backend file extension to .aacdb (was .be)

This should now work as before and you can later split the database again once you have gone over all the issues mentioned above.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer


 

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips


Server loaded in 0.12 secs.