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

Apparently you can also just change the extension of the back-end file from .accdc to .accdb and it will work.

http://www.accessforums.net/access/problems-accessing-split-database-backend-48064.html

I've not tried this method.

I read that somewhere else and tried it, but then the front end forms/queries/reports refer to a back end that doesn't exist anymore because the extension changed.

I am fixing it manually.  Good luck.

Answer 3

if you change the extension of the back-end file from .accdc to .accdb it will work.   Just tried it.    been struggling with this for a while.    

Tks Poster.

Eric.

Answer 4

Hi tospig

You are absolutely right!  It was a typo - I meant "now" instead of "not".  It changes the meaning somewhat, doesn't it?  :-)

I have edited the original post - thanks for the heads-up.

Answer 5

Thanks Graham, I had seen a similar solution on another forum too so it sounds like this is the way to go. 

However, in your point 4 should it read

"4. Open the original database (which is now the front-end)...?