"Run-time error - 3219 Invalid Operation (1 Viewer)

[Gasman]

What I wanted to do is; remove all linked tbl in FE and once the db starts up, it should RE-LINK all the tbls from BE.

One of the links I posted did exactly that.

 

[CJ_London]

What I wanted to do is; remove all linked tbl in FE

if you remove all linked tables, then you cannot use the tabledefs as a reference for relinking

 

[Ashfaque]

if you remove all linked tables, then you cannot use the tabledefs as a reference for relinking

Thats the correct point you catch CJ.....Thanks,

So what is the solution to this...any alternate?

 

[Gasman]

Thats the correct point you catch CJ.....Thanks,

So what is the solution to this...any alternate?

Read that link I posted in #12 perhaps?
They stored the linked tables in a table of their own, by reading the tables in the BE.
You could just manually add your table names to your own table and use that to create the links.

Really a waste of my time finding you options, if you cannot be bothered to read them.
They might not be *exactly* what you want, but should go a good way to show you what you need to do?

 

[Gasman]

if you remove all linked tables, then you cannot use the tabledefs as a reference for relinking

Which highlights the fact you never walked through your code?

 

[CJ_London]

So what is the solution to this...any alternate?

Since the code provided by @Gasman works for me (different be, different tables, different password) still says there is something wrong with your setup. I note you haven’t said wether you have compacted or decompiled/recompiled

alternative- do it manually