dkilby
asked on
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?
from the FE, ribbon
external data > Import > access > select link
browse for the back end
external data > Import > access > select link
browse for the back end
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
also do the table refresh automatically of does the user have to refresh the tables?
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
http://allenbrowne.com/ser-01.html
look for
Attached tables: reconnect on start up
Relink Access tables from code
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
http://allenbrowne.com/ser-13.html
Relink Access tables from code
http://www.mvps.org/access/tables/tbl0009.htm
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
Done.
mx
Capture1.gif
ASKER
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
Move ?
Data Macro ?
mx
Data Macro ?
mx
ASKER
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.
Can you open the related table from the Front End directly ?
mx
mx
ASKER
i had split it wrong, not sure what i did but tired again and it worked - thanks for all the help
You are welcome ...
mx
mx
mx