?
Solved

Access 2007 Split Database

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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…
Suggested Courses

777 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