Copy tables & relationships

[Darizotas]

Hello to everybody,

I have a question, I have a split database (FE/BE) and from the application
(FE) I am trying to copy (duplicate) several tables and their corresponding
relationships (all contained at BE). But I have found several problems:

1. First, I tried using CopyObject, but I realized that it copied only the
link!!
2. Second, I tried also to use TransferDatabase, but it seems not to work.
Or may be I have not used it properly.
3. Third, I know I could copy that tables just by using SQL: select into..
but it does not copy the indexes, and I need them, because they are involved
in the relationship constraints.

Somebody could throw me some light on this issue??

Thanks in advance,

Dario.

 

[Kevin Jameson]

you cant do this with microsoft access 2003

you must upgrade to access 20004 by clicking here:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html

HTH

Kevin

 

[Darizotas]

Sorry, I forgot to tell that I am working with Access 2000 and it seems to be
a restriction up to now.

Thanks,

Dario.