By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,081 Members | 1,885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,081 IT Pros & Developers. It's quick & easy.

Access 2003 macro to delete a field & add a field to a table

P: 34
Hello. I'm trying to create one macro in Access 2003 that will delete a field (called ID) in a table. I then need a separate macro that will *add* a field back in called ID w/type of autonumber. I was trying to use the Action of RunCommand, DeleteTableColumn for the first macro but I'm not having luck...

Any help you can provide will be very appreciated.
Oct 24 '08 #1
Share this Question
Share on Google+
1 Reply


DonRayner
Expert 100+
P: 489
Just curious, is there a reason why you couldn't just edit the table structure directly?
Oct 24 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.