Database Splitting not working

[HubbellL]

Hi,

I'll start with some back story so whomever can assist me knows my frustration and can give me constructive feedback. I am fairly new to database design, have used front end but never back end. My company needed a database, and I made one in Access 2013 over a few days. That was about 6 months ago. Windows updated about 2 months ago and we were was unable to open the database on the network. I had to make a new database from scratch. Because of this, I am trying to split an access database into the front end and back end, so if that happens again at least we can save the table. When I split the table, it will not let me open the back end file. When I do, it shows an error message "a potential security concern has been identified. Warning: this content does not have a digital signature and the origin of this content cannot be verified" then just goes to the general access open screen. Upon researching and double checking, it is saved as an .accdc file. Two options that I found to fix this solution is 1) Save it as an .accdb file (which is not an option while splitting the database) and 2) linking the database with the back end. I fear with option 2, this puts me in the same situation because I will never be able to open up the back end if something does happen since Microsoft updates occur automatically and without asking first.



I guess I have two questions:
1) Does anyone have any input on how to save the back end file as a .accdb?
2) Are there any other alternatives to splitting? I basically want the database to be located in 2 locations in case something happens to one of them. But I still want them to be linked.

Thanks a bunch for your help in advance, and I will answer any questions if I wasn't thorough enough.

[ssanfu]

Splitting means that 1 accdb, the "back end" (BE) has only the tables, and the "front end" (FE) has everything else: Queries, Forms, Reports, Modules and Macros.

Easiest method I have found is to split the dB manually.

Create 2 copies of the dB:

Using the copies:
Have FE in the name of one dB and BE in the name of the other dB.
Open the dB with BE in the name. Delete all objects EXCEPT the tables.
Open the dB with FE in the name. Delete ONLY the tables.
Open the Linked table Manager (menu->External Data\ Access), select the dB with BE in the name, then click on the radio button for "Link to the Data Source....." option.
Select all of the tables and click OK.

[ssanfu]

Now that the dB is split, put the BE on the server where everyone has R/W privileges. In the FE on your local computer, relink to the BE (on the server).
Then, everyone get a copy of the FE on their local computer.

Warning: If you have one FE on the server that everyone opens, you will, at some point, corrupt the dB.