Community
Showing results for 
Search instead for 
Do you mean 
Reply

Convert Remote Database to a Main Database?

Accepted Solution Solved
Astute Commentator
Posts: 12
Country: USA
Accepted Solution

Convert Remote Database to a Main Database?

I have purchased some new laptops running Windows 7 Home Premium. I had my main database on my old laptop, and the remote on my desktop. (So I could more easily isolate my main database from power surges, etc.)

 

If possible, I would like to convert the remote database on my desktop to function as a main database. Then install remote databases on each laptop. Is it possible to convert a database, or do I have to save a copy of the main database on a removable drive, then copy it over to the desktop?

 

Any ideas?

 

Pat Lekawa 


Accepted Solutions
Solution
Accepted by topic author plekawa
‎09-25-2015 03:20 AM
Nickel Contributor
Posts: 205
Country: United_Kingdom

Re: Convert Remote Database to a Main Database?

Hi Pat

 

Open up your remote database and then File -> Save as... and select the option to save a copy of the database. Give it a new name "New_Master" etc.

 

This saved copy is your new master. You will then need to create new remote databases from this New_Master.

Trevor Lever

UK - ACT Certified Consultant
www.actpartners.co.uk
trevor@actpartners.co.uk

View solution in original post


All Replies
Solution
Accepted by topic author plekawa
‎09-25-2015 03:20 AM
Nickel Contributor
Posts: 205
Country: United_Kingdom

Re: Convert Remote Database to a Main Database?

Hi Pat

 

Open up your remote database and then File -> Save as... and select the option to save a copy of the database. Give it a new name "New_Master" etc.

 

This saved copy is your new master. You will then need to create new remote databases from this New_Master.

Trevor Lever

UK - ACT Certified Consultant
www.actpartners.co.uk
trevor@actpartners.co.uk
Astute Commentator
Posts: 12
Country: USA

Re: Convert Remote Database to a Main Database?

Easy & Elegant! Thank you!

 

Pat

Platinum Elite Contributor
Posts: 14,384
Country: Australia