Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Ms/ACCES split database folder change

Posted on 2011-09-06
5
Medium Priority
?
298 Views
Last Modified: 2012-08-13
I have an access database that I splitted a few months ago. As I need to move the Back End to a new computer with different organization, I need to change the address of the back end folder. How do I do it?
Is there a manner to unsplit the database?
0
Comment
Question by:João serras-pereira
  • 3
5 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 36490630
You can use the Linked Table Manager to Relink to the new location ... Tools>>Database Utilities>>Linked Table Manager.

mx
Capture1.gif
0
 
LVL 75
ID: 36490644
"Is there a manner to unsplit the database?"
No need to do this nor would it be recommended.

mx
0
 
LVL 21
ID: 36490664
<<Is there a manner to unsplit the database? >>
Sure it is possible. Just reverse the process of splitting.

FWIW: I split every database from the start. I will only would on a database that is split.  

I have written some article on the subject.

How to Manage Your Linked Tables

Splitting your Access database into application and data

0
 

Author Closing Comment

by:João serras-pereira
ID: 36490768
Thanks! it worked perfectly!
0
 
LVL 75
ID: 36490805
You are welcome ..

mx
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

926 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