Solved

Access 2007 Split Database

Posted on 2011-03-23
4
252 Views
Last Modified: 2012-05-11
I have split databases that we're moving to new folders.  The person that moved that has done so and has resetablished the links.  What is the proper way to distrubute the front-end of the database to end users?  Can you just set up a link, or do you have to send them a copy of the front-end database?  Are there any other issues I need to be aware of?  I'm giving this a high point value given the urgency.
0
Comment
Question by:Luis5011
[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
  • 3
4 Comments
 
LVL 12

Expert Comment

by:rgn2121
ID: 35198520
Give them copies...

Also, in my experience with a split system it is better to open a connection to the backend db and leave that open until the work is done...just makes things faster.
0
 
LVL 12

Expert Comment

by:rgn2121
ID: 35198600
This is also a good resource...
http://allenbrowne.com/ser-01.html
0
 
LVL 12

Accepted Solution

by:
rgn2121 earned 500 total points
ID: 35198628
I noticed that some of those links no longer work so here is one that does... ;)
http://www.fmsinc.com/microsoftaccess/DatabaseSplitter/index.html
0
 

Author Closing Comment

by:Luis5011
ID: 35198768
Thanks for your help
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.

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

Suggested Solutions

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…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

730 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