Make Table query... to another database

[lipin]

I created a make-table query that places the new table into another database. Here it has multiple queries run on it and reports to generate. But when it goes to make the table and then place it into the other DB, I get the message saying there is already a table named this--OK I need it to be the same name so the queries that are there will run OK. So I say yes replace the existing table. Then the problem: It says that the table to be replaced can't be because it has relationships and that I must delete them first. Well I need that same relationship with the new table. So How can I replace the table?

Thanks.

 

[Dave Eyley]

Pehaps trying to replace the table is not the thing to do. How about replacing the data. If you linked the tables in both databases then any changes you make in one should carry thru to the other?

It seems too simple, doesn't it?.....
But it's worth a try.

 

[lipin]

Can you do this even though the two tables are not exactly the same. I need the fields named a little different, but the info in the fields is the same. And I Don't need all the fields that are kept in the first table. So if they are linked do they have to be the exact same?

 

[Dave Eyley]

Mmmm...interesting. It does make it more complicated.

If they are linked, they are the same table. Is it too late to change the fieldnames in one of the tables? The text labels for the field names can be the same. The user wouldn't see the changes.

Otherwise, any other way I can think of would get messy.
Perhaps somebody else on here can come up with a smooth solution?

As an afterthought, if the fields aren't that similar why not link the tables in addition to the other table and then extract the fields you need from there? One more table in a database wouldn't make that much difference. Not a perfect answer, I know.