Question Unable to split access database (1 Viewer)

DigitalS27

Registered User.
Local time
Today, 01:29
Joined
Sep 13, 2013
Messages
13
Good day guys,

I am trying to split my access database. I copied the access file to my local drive then I click split database. the computer loads for a while and then instead of split successful I get a prompt record deleted.

Can you please assist ?
 

CJ_London

Super Moderator
Staff member
Local time
Today, 09:29
Joined
Feb 19, 2013
Messages
16,607
not enough information to explain why this is the case, but very easy to do manually

create two copies of your app - suffix the name with BE (backend) and FE (frontend)

open the BE file and delete everything except tables. Then compact and repair

open the FE file and delete all the tables, then use the linked table manager on the external data tab to link to the tables in the BE. Then compact and repair
 

Users who are viewing this thread

Top Bottom