Prev: How to Change the Data Source of a Form
Next: Multiple users, how can users view only their entries
From: MJ on 2 Jul 2008 12:04
When using this command to create a copy of an existing table into another
database, what happens if the table already exists in the destination mdb?
1) Does it append to existing table (without creating duplicates of
existing records)?
2) Does it add it to the already existing table (potentially creating
duplicates of existing records)? OR
3) Does it overwrite the existing table?

Thank you for your assistance?

--

MJ
From: Maurice on 2 Jul 2008 15:40
Data doesn't get appended because you are transferring an object. So my guess
would be that you would get a notification that the table already exists or
you would get a duplicate with a 1 appended to the name (something like
table1)

hth
--
Maurice Ausum


"MJ" wrote:

> When using this command to create a copy of an existing table into another
> database, what happens if the table already exists in the destination mdb?
> 1) Does it append to existing table (without creating duplicates of
> existing records)?
> 2) Does it add it to the already existing table (potentially creating
> duplicates of existing records)? OR
> 3) Does it overwrite the existing table?
>
> Thank you for your assistance?
>
> --
>
> MJ
 | 
Pages: 1
Prev: How to Change the Data Source of a Form
Next: Multiple users, how can users view only their entries