OK to modify db copy and then import original tables?

  • Thread starter Thread starter Vivian Carroll
  • Start date Start date
V

Vivian Carroll

Hi,

Some of you helped me before to know that I should create a back-end copy of
my database that has the tables in it. However, for a variety of reasons,
I'm keeping it as one file for now and the users are using it.

My question is whether I will run into any problems if I make design changes
as follows: Copy the original database file to a copy. Modify the copy. Then
import the original tables into the copy. Then replace the original database
with the copy (after kicking everyone out of the original first). It woreds
on my test database but I want to be sure I haven't overlooked anything.

TIA,
Vivian Carroll
 
Hi Vivian,

That will work, especially if you only make changes to the application /
user interface (you're not changing the data structure i.e. table
structure).

HTH,
Immanuel Sibero
 
Thank you Immanuel!

Immanuel Sibero said:
Hi Vivian,

That will work, especially if you only make changes to the application /
user interface (you're not changing the data structure i.e. table
structure).

HTH,
Immanuel Sibero


copy
 
Back
Top