I am trying to split an access 2007 DB into a front and back end.
Anyone know of any resources on how to do this?
Thanks.
I am trying to split an access 2007 DB into a front and back end.
Anyone know of any resources on how to do this?
Thanks.
in the db, tools, Access database. (yeah, bad labeling)
it will ask you to name the backend.
(2007 may have SPLIT, its been a while)
It is pretty easy to do it yourself. (I always do).
OK, a BE (back end) has only tables in it. A FE has everything EXCEPT tables.
The FE (front end) gets linked to the BE.
Lets say your dB is named "DealerData.accdb".
First, make 2 COPIES of you dB. Most important, move one copy somewhere safe.
Second, rename 1 of the remaining copies to "DealerData_BE.accdb". Rename the other database to "DealerData_FE.accdb".
Open the BE and delete all objects that are not tables. That means delete all Queries, Forms, Reports, and Modules. Also Macros if you use them (I don't). Close and save the database.
Open the FE and delete ALL Tables. Close and save the database.
Now to link the tables:
Open the FE dB. In the menu click on "External Data". In the "Import & Link" Group, click on "Access".
Follow the prompts to select the BE database ("DealerData_BE.accdb") and be sure to select the radio button to LINK to the tables.
Then select all of the tables you want to link to the FE (should select ALL tables). Click OK and you should be done. (I use A2010 so things might be a little different in A2007).
All linked tables will have an arrow to the left of the name.
TADA!!!
If multiple people are going to use the database, EACH user should have a COPY of the FE on their local computer. DO NOT create a shortcut that everyone used to open the database.
That is a sure way to corrupt your dB. Not a maybe, just a when will it happen!!
Good luck with your project.....