Table name and links ---URgent

[bhusiva]

i have 2 mdb and both mdb have table link

in one of the mdb , they had a link to dbf (paradox) and they have lot of queries and reports created.

Now the functionality has changed so we have created a access table and need to replace the dbf with the table.

The problem is we need to retain all the queries and reports as such but the table will be access table instead of dbf.

Example

First.mdb has test table
Second.mdb has a table called old.dbf. and associated quries

but now test table is been linked to second.mdb and we got to rename or delete old.dbf and associated all queries and reports pointing to test table

is there a way to do it automatically or should it be done manually?

Please let me know as it is urgent

 

[gemma-the-husky]

if all the field names are the same, cant you just give the access table the same name as the dbf table was previously, anf name the dbf link something else

then it should work