I have an inventory written in access w/macros, I am just learning access myself and bought vba access 2007 by mistake. This program was written previous to 2007 and i am don't know how to access the tables let alone change the index key. can anyone help me please?

Welcome to the Forum, Paul,

What version of Access is your inventory written in?

i think it was done in access xp but it could be earlier.

When you say "index key" I am assuming you want to add a new field and make it the primary key. To do so, open the database window, click on "tables" (on the left of the window) and select the table. Open the table in design view. Add a new field, click the "key" icon while you have the cursor on the field you want to become the new primary key. Then to remove the previous primary key (if there was one) select the field, again click on the "key" icon. That should make that field a regular field. (If I understood what you want, are you certain you really you want to change the primary key? You could be headed to trouble.)

If you only want to remove an index from a field, open the table in design view, select the field, in the bottom of your screen you will see properties for the field. Select "Index" and choose what type of index you want (or none.)

HTH,

Loralee