Improve company productivity with a Business Account.Sign Up

x
?
Solved

MS Access 2010 + Splitting Database

Posted on 2011-02-23
13
Medium Priority
?
363 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
ID: 34963648
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34963669
from the FE, ribbon
external data > Import > access > select link
browse for the back end


0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 2000 total points
ID: 34963674
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 

Author Comment

by:dkilby
ID: 34963679
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34963694
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34963704
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
 
LVL 75
ID: 34963734
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
ID: 34963833
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
ID: 34963845
Move ?
Data Macro ?

mx
0
 

Author Comment

by:dkilby
ID: 34963887
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
ID: 34963925
Can you open the related table from the Front End directly ?

mx
0
 

Author Comment

by:dkilby
ID: 34964076
i had split it wrong, not sure what i did but tired again and it worked - thanks for all the help
0
 
LVL 75
ID: 34964090
You are welcome ...

mx
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

608 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