Make adds to existing db and get current data from client

  • Thread starter Thread starter SRussell
  • Start date Start date
S

SRussell

I am helping a friend with their db. I added a table, added a form and
changed some existing ones.

How do I put the current data into the modified mdb I have?

TIA
 
I am helping a friend with their db. I added a table, added a form and
changed some existing ones.

How do I put the current data into the modified mdb I have?

TIA
Click to expand...

With considerable difficulty, often.

That's why it's almost always best to use the Database Splitter Wizard
to split the database into a backend (containing only the tables) and
frontend (with everything else). You can work on the forms, reports,
and code using your own "testing" backend; when they're working right,
the friend can simply replace their frontend with the new one, and
relink it to their backend.

You'll need to use File... Get External Data... Import to import a new
table into the backend, but hopefully that will be much rarer than
changing forms.

John W. Vinson[MVP]
 
John Vinson said:
With considerable difficulty, often.

That's why it's almost always best to use the Database Splitter Wizard
to split the database into a backend (containing only the tables) and
frontend (with everything else). You can work on the forms, reports,
and code using your own "testing" backend; when they're working right,
the friend can simply replace their frontend with the new one, and
relink it to their backend.

You'll need to use File... Get External Data... Import to import a new
table into the backend, but hopefully that will be much rarer than
changing forms.
Click to expand...

Wow that sounds sucky :(

Anyway to truncate a table in my db? I can hook in from SQL2005.
 
Back
Top