Share via

Access 2013 Split Database

Anonymous
2014-11-18T10:45:26+00:00

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

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2014-11-20T08:32:37+00:00

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!

Was this answer helpful?

1 person found this answer helpful.
0 comments

14 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-11-21T00:12:55+00:00

    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.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2014-11-20T04:58:15+00:00

    I'm looking for a solution to this too, have you had any luck with it?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2014-11-20T20:23:05+00:00

    Received this helpful reply:

    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 (not 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!

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-11-20T20:19:53+00:00

    Great advice. Thank you for your help. I really appreciate it.

    Was this answer helpful?

    0 comments