Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS Access 2010 + Splitting Database

Posted on 2011-02-23
13
Medium Priority
?
361 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 MVP, Access and Data Platform) earned 2000 total points
ID: 34963674
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

610 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