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

x
?
Solved

Access 2007 Split Database

Posted on 2011-03-23
4
Medium Priority
?
269 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 2000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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. …

618 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