Solved

MS Access 2010 + Splitting Database

Posted on 2011-02-23
13
353 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 - Access MVP) earned 500 total points
ID: 34963674
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…

813 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

13 Experts available now in Live!

Get 1:1 Help Now