>       I just got a set of databases and one of them contain many Linked
> tables. I think it is not convenient so I want to combile all of them into
> only one database. Therefore I delete Linked table and then import a same
> table from the original source. It should work but unfortunately it didn't
> work. It said "The link to database is fail" How can I overcome this?
Please
> help me.

> For starters, don't change things you don't understand.  Most likely,
there
> was code running on start up to relink the tables.  Now that the tables
are
> no longer linked, the code fails.

> >       I just got a set of databases and one of them contain many Linked
> > tables. I think it is not convenient so I want to combile all of them
into
> > only one database. Therefore I delete Linked table and then import a
same
> > table from the original source. It should work but unfortunately it
didn't
> > work. It said "The link to database is fail" How can I overcome this?
> Please
> > help me.

> Thanks for your help
> Could you please show me some function or keyword in VBA that might used
for
> maintaining the link.

> Best Regards,
> Dach


> > For starters, don't change things you don't understand.  Most likely,
> there
> > was code running on start up to relink the tables.  Now that the tables
> are
> > no longer linked, the code fails.

> > >       I just got a set of databases and one of them contain many
Linked
> > > tables. I think it is not convenient so I want to combile all of them
> into
> > > only one database. Therefore I delete Linked table and then import a
> same
> > > table from the original source. It should work but unfortunately it
> didn't
> > > work. It said "The link to database is fail" How can I overcome this?
> > Please
> > > help me.