Copy tables & relationships

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darizotas - 19 Sep 2006 15:33 GMT

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.

Reply to this Message

Kevin Jameson - 19 Sep 2006 15:38 GMT

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

> Hello to everybody,
>
[quoted text clipped - 18 lines]
>
> Dario.

Reply to this Message

Darizotas - 19 Sep 2006 15:49 GMT

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

Thanks,

Dario.

> you cant do this with microsoft access 2003
>
[quoted text clipped - 26 lines]
> >
> > Dario.

Reply to this Message