How do I use SQL to Drop a Column from a MS ACCESS Database if that column is a replication ID?

I had a notion to use a database column of type replication ID, but have sin开发者_如何学Goce changed my approach and want to use this column for another purpose.

However, I'm unable to use SQL to drop the column to remove it from my database.

My SQL is:

ALTER TABLE foo_bar DROP COLUMN theFoo;

However, I get a "syntax error" and I'm assuming this has something to do with this column being a replication ID.

I'd rather not download the file and edit it directly using the MS Access application, but not sure if that's my only recourse.

Thanks so much in advance.

Regards,

Kris

If you have access to the database in a command shell, Michael Kaplan's Replication System Removal Fields utility should do the trick. However, I've found that in some circumstances, it's unable to do the job. Also note that the utility will only work with a Jet 4 format database (MDB), not ACE format (ACCDB).

If all else fails, you can recreate the table structure and append the existing data to it. That can get messy if you have referential integrity defined, though, but it will get the job done, and likely most of it is scriptable (if not all possible using just DDL).

Here is a link that may help you, I had a similar idea but when browsing the web found this

AccessMonster - Replication-ID-Field-size

EDIT: Well I don't have much time but what I was thinking of first was if you could alter the column to make it different (not a replication ID) and then drop it. (two separate actions). But I have not tested this.