Unsplitting a database

[Bob H]

I have a database which I split on my company's server and copied the
front end to local computers. Now I want to unsplit that database on my
own PC to modify the forms.
I managed to get it to load onto my own PC by holding down the shift key
as the database loaded, but now when I try to open any table or form I
get an error message telling me that V:\database_be.mdb is not a valid path.
I know that it isn't so how can I a/ unsplit the said database back to
one instead of a front end and backend, and also make it ignore the
server path and see my own PC's path?

Thanks

 

[fredg]

I have a database which I split on my company's server and copied the
front end to local computers. Now I want to unsplit that database on my
own PC to modify the forms.
I managed to get it to load onto my own PC by holding down the shift key
as the database loaded, but now when I try to open any table or form I
get an error message telling me that V:\database_be.mdb is not a valid path.
I know that it isn't so how can I a/ unsplit the said database back to
one instead of a front end and backend, and also make it ignore the
server path and see my own PC's path?

Thanks

Do you still have access to the back end on the company server?
If so ....
On your own computer, if you look at the tables they all have an arrow
next to the table name.
Delete those table(s) (you are only deleting the link to the table not
the table itself).

Then, after deleting all of the links, click on File + Get External
Data + Import.
Navigate to the server database back end and click on the Table tab.
Select all of the tables.
Click on the Options button.
Select Definition and Data.
Select Relationships. Click OK.

You now have imported the back end tables into your local machine. Any
changes you make on your computer will NOT affect the original Server
back end tables.

 

[Bob H]

Do you still have access to the back end on the company server?
If so ....
On your own computer, if you look at the tables they all have an arrow
next to the table name.
Delete those table(s) (you are only deleting the link to the table not
the table itself).

Then, after deleting all of the links, click on File + Get External
Data + Import.
Navigate to the server database back end and click on the Table tab.
Select all of the tables.
Click on the Options button.
Select Definition and Data.
Select Relationships. Click OK.

You now have imported the back end tables into your local machine. Any
changes you make on your computer will NOT affect the original Server
back end tables.

Thanks but when I said my own computer, I meant my own one at home not
at work. But I'll try that anyway.

 

[Jeff Boyce]

Bob

How would your home computer know about your work LAN?

FredG offers a way to create an all-in-one version on your PC at work. Then
you can move that to your home PC.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bob H]

Hi Jeff,
well you are right, my computer wouldn't know about the work LAN, maybe I
thought it could.

Anyway, I have done as FredG told me, as in deleting the links, then I
imported the backend database which gave me the tables back into the
database, but I noticed that they still have arrows pointing to them, as
though they were still linked.
I'll see how it goes later when I get home and load it on my home PC.

Thanks

 

[Jeff Boyce]

If the arrows show, the tables are linked.

Try once more, importing rather than linking.

Regards

Jeff Boyce
Microsoft Office/Access MVP