MS Access 2010 + Splitting Database

I would like to use the splitting database feature and put the back end database on a shared drive, then have the users utilize the front end part of the database, how do i setup the front end so it knows where to find the backend database?
dkilbyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Take a 'master' copy of the FE ... and link to the BE using the FULL UNC path to the BE on the server.

mx
0
 
Rey Obrero (Capricorn1)Commented:
from the FE, ribbon
external data > Import > access > select link
browse for the back end


0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
dkilbyAuthor Commented:
i guess that is where i am stuck - where in the FE db do i enter the full UNC path of the BE db?

also do the table refresh automatically of does the user have to refresh the tables?
0
 
Rey Obrero (Capricorn1)Commented:
see this link to to do the linking  in codes

http://allenbrowne.com/ser-01.html

look for

    Attached tables: reconnect on start up

    Relink Access tables from code
0
 
Rey Obrero (Capricorn1)Commented:
Reconnect Attached tables on Start-up
http://allenbrowne.com/ser-13.html

Relink Access tables from code
http://www.mvps.org/access/tables/tbl0009.htm
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Once you click Open on the Wizard ... the list of tables in the BE will appear. Select the tables you want to link and click OK.

Done.

mx
Capture1.gif
0
 
dkilbyAuthor Commented:
when i move i get an error - saying that a data macro could not be found, do i need to do something to ensure it is copied or should it stay on the front end db
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Move ?
Data Macro ?

mx
0
 
dkilbyAuthor Commented:
when i split the database i now get an error when trying to complete something on a form, i had used a data macro - now with the database split i get an error that it cant be found.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Can you open the related table from the Front End directly ?

mx
0
 
dkilbyAuthor Commented:
i had split it wrong, not sure what i did but tired again and it worked - thanks for all the help
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You are welcome ...

mx
0
All Courses

From novice to tech pro — start learning today.