Solved

MS Access 2010 + Splitting Database

Posted on 2011-02-23
13
352 Views
Last Modified: 2012-08-14
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?
0
Comment
Question by:dkilby
  • 6
  • 4
  • 3
13 Comments
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
from the FE, ribbon
external data > Import > access > select link
browse for the back end


0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
Comment Utility
0
 

Author Comment

by:dkilby
Comment Utility
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
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
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
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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
 

Author Comment

by:dkilby
Comment Utility
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
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Move ?
Data Macro ?

mx
0
 

Author Comment

by:dkilby
Comment Utility
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
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Can you open the related table from the Front End directly ?

mx
0
 

Author Comment

by:dkilby
Comment Utility
i had split it wrong, not sure what i did but tired again and it worked - thanks for all the help
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
You are welcome ...

mx
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now