TransferDatabase problem

[campbellbrian2001]

Thanks in advance,

I am automating copying tables from one database to another.
Everything works fine except on the tables I want only the structure I
put the word "True" (to transfer only the structure) instead of
"False". The code runs, tables appear perfectly, except I still get
tables with data when I type "True". Here's my syntax / code and it all
works except the true has no effect:

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"C:\Documents and Settings\dcampbe\Desktop\Copies of
Apps\Master_MI.mdb", acTable, "tblCustomer", "tblCustomer", True

Any ideas?
Thanks!!! Brian

[Anthony England]

<ca***************@yahoo.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

Thanks in advance,

I am automating copying tables from one database to another.
Everything works fine except on the tables I want only the structure I
put the word "True" (to transfer only the structure) instead of
"False". The code runs, tables appear perfectly, except I still get
tables with data when I type "True". Here's my syntax / code and it all
works except the true has no effect:

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"C:\Documents and Settings\dcampbe\Desktop\Copies of
Apps\Master_MI.mdb", acTable, "tblCustomer", "tblCustomer", True

Any ideas?
Thanks!!! Brian

Are you absolutely sure tblCustomer does not already exist when you run the
code? If it does, the code will create another table named tblCustomer1
(2,3,etc) and you might be opening 'tblCustomer' unaware that it was not
created by the code you just ran.

[campbellbrian2001]

I double-checked and the table doesn't exist before the transfer....
Anthony England wrote:

<ca***************@yahoo.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

Thanks in advance,

I am automating copying tables from one database to another.
Everything works fine except on the tables I want only the structure I
put the word "True" (to transfer only the structure) instead of
"False". The code runs, tables appear perfectly, except I still get
tables with data when I type "True". Here's my syntax / code and it all
works except the true has no effect:

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"C:\Documents and Settings\dcampbe\Desktop\Copies of
Apps\Master_MI.mdb", acTable, "tblCustomer", "tblCustomer", True

Any ideas?
Thanks!!! Brian

Are you absolutely sure tblCustomer does not already exist when you run the
code? If it does, the code will create another table named tblCustomer1
(2,3,etc) and you might be opening 'tblCustomer' unaware that it was not
created by the code you just ran.

[Anthony England]

<ca***************@yahoo.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

I double-checked and the table doesn't exist before the transfer....
Anthony England wrote:

<ca***************@yahoo.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

> Thanks in advance,
>
> I am automating copying tables from one database to another.
> Everything works fine except on the tables I want only the structure I
> put the word "True" (to transfer only the structure) instead of
> "False". The code runs, tables appear perfectly, except I still get
> tables with data when I type "True". Here's my syntax / code and it all
> works except the true has no effect:
>
> DoCmd.TransferDatabase acImport, "Microsoft Access", _
> "C:\Documents and Settings\dcampbe\Desktop\Copies of
> Apps\Master_MI.mdb", acTable, "tblCustomer", "tblCustomer", True
>
> Any ideas?
> Thanks!!! Brian

Are you absolutely sure tblCustomer does not already exist when you run
the
code? If it does, the code will create another table named tblCustomer1
(2,3,etc) and you might be opening 'tblCustomer' unaware that it was not
created by the code you just ran.

I have just double-checked the code works OK on my system (Acc XP).
Another shot in the dark ...Is tblCustomer local to Master_MI.mdb (i.e. not
a linked table)?
If it is still not working, then maybe this is a bug I am not aware of - but
I did do a quick Google but found nothing on this. Perhaps post back with
further details:
Access version?
Jet SP?
mdb/mde/adp/etc?
Any security? user-level, db password, etc?
Does code compile/ no missing references?
Can you replicate this on another machine?

[Lyle Fairfield]

Anthony England wrote:

I have just double-checked the code works OK on my system (Acc XP).

Same here for Acc 2003.

TransferDatabase has been troubled with bugs and misinformation in the
Help files over the years, but this is new to me (to my memory at
least).

If OP doesn't need indexes I suggest he accomplish task with SQL.

[campbellbrian2001]

Access 2000, Code compiles fine, tables are linked from my "transfer
from DB" to a master database (also Access). I tried to code the path
to the Master database instead of the Master_MI, but that didn't work
either. None are .mde's. No passwords.