Make adds to existing db and get current data from client

[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

 

[John Vinson]

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

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]

 

[SRussell]

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.

Wow that sounds sucky

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

 

[John Vinson]

Anyway to truncate a table in my db?

Sure, just run a Delete query with no criteria:

DELETE * FROM tablename;

John W. Vinson[MVP]

 

[SRussell]

Sure, just run a Delete query with no criteria:

DELETE * FROM tablename;

I knew it would be simple, thanks.

__Stephen