Solved

Access 2007 Split Database

Posted on 2011-03-23
4
223 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
  • 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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…

758 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

20 Experts available now in Live!

Get 1:1 Help Now