Solved

Ms/ACCES split database folder change

Posted on 2011-09-06
5
289 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:jirdeaid
  • 3
5 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 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:jirdeaid
ID: 36490768
Thanks! it worked perfectly!
0
 
LVL 75
ID: 36490805
You are welcome ..

mx
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

708 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

13 Experts available now in Live!

Get 1:1 Help Now