ID Column removal

[endri81]

Hi I have several Access databases with identical tables.Let's say all these db's have table1,table2,table3.I need a script to remove ID column from table1 in all databases.Can you tell me where to find something like that?

 

[DCrake]

Consider the following issues

ID is a Primary Key
ID is a Foreign Key

ID appears in a relationship

Other objects depend on ID
Code is linked to ID

Why do you want to do this anyway?

 

[endri81]

I need to merge table1 from each db using merge tool.But this is not done correctly because of ID column.Please help with the script