A
Aamer
If a database is splited can it be joined back?
If so how?
If so how?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Daniel Pineault
Yes, but the bigger question is why would you rejoin it??? The proper
deployment of a database (multiple users) is to always split it.
If you really wish to rejoin it, you simply need to reimport (File - Get
External Data - Import...) the tables from the back-end into the front-end
and then simply use the front-end. Depending on the sofistication of your
database, you may need to make change to code. For instance, you may need to
disable vba which attempts to relink your tables...
But once again, I ask: why would you need to do this?
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
deployment of a database (multiple users) is to always split it.
If you really wish to rejoin it, you simply need to reimport (File - Get
External Data - Import...) the tables from the back-end into the front-end
and then simply use the front-end. Depending on the sofistication of your
database, you may need to make change to code. For instance, you may need to
disable vba which attempts to relink your tables...
But once again, I ask: why would you need to do this?
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
J
John Spencer
Yes, it can be joined back.
Delete all the links in the front-end
Import all the tables from the back-end
(IN Access 2003 and earlier, look at the following on the menu
FILE: Get External Data: Import)
In Access 2007, you might have to start at the Office Button.
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Delete all the links in the front-end
Import all the tables from the back-end
(IN Access 2003 and earlier, look at the following on the menu
FILE: Get External Data: Import)
In Access 2007, you might have to start at the Office Button.
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
A
Aamer
Thank you for your reply
John Spencer said:Yes, it can be joined back.
Delete all the links in the front-end
Import all the tables from the back-end
(IN Access 2003 and earlier, look at the following on the menu
FILE: Get External Data: Import)
In Access 2007, you might have to start at the Office Button.
John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
.
A
Aamer
Thank You For Your Reply
I just wanted to know if it can be done.
So far there is no need for it, it was just for my info, if it can be done
or not.
I just wanted to know if it can be done.
So far there is no need for it, it was just for my info, if it can be done
or not.