Access 2013 Split Database

Question

When I try to split the database (Move data - access database) it only gives me the option as saving it as a Microsoft Access Signed Package. When I try to open the back end, it states

A potential security convcern as been identified. The origin of this content cannot be verified. The file is missing a digital signature and cannot be opened.  Thank you for your help

Answer 1

In 22 years of using Access I confess I have never used the wizard to split a database.  However, I just tried it now in Access 2013 (15.0.4663.1000) and it worked fine, so I can't say what the problem is on your computer.

However, it is easy to split a database manually - I have done it hundreds of times:

1. Take a backup copy of the database.
2. Take another copy of the database and rename it as the back-end (e.g. MyDatabase Data.accdb)
3. Open the new back-end and delete all the objects EXCEPT the tables.
4. Open the original database (which is now the front-end) and delete all the tables (except the system tables - MSys* - if they are visible)
5. Use External data > Import & Link > Access to link all the tables from the back-end to the front-end.

Good luck!

Answer 2

Please don't piggyback your question on another thread. Please use the participate link above and start a new thread. You can reference the older thread by inserting a link if you need to. 

Formalized relationships would be created in the back end.

Answer 3

In which database does the relationships reside, front end or back end?