OK to modify db copy and then import original tables?

[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

 

[Immanuel Sibero]

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

 

[Vivian Carroll]

Thank you Immanuel!

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