access 2007 menu question

[james_lankford]

in access when you create or import a table with fields ending with ID (CustomerID, SiteID, AccountID), it automatically indexes those fields

I know how to turn this option off in access 2003

but where do I turn it off in 2007 ?

 

[boblarson]

I don't have access to it at the moment to confirm but I believe it is under the ADVANCED selection in ROUND OFFICE BUTTON > ACCESS OPTIONS.

 

[james_lankford]

thank you
tha got me searchign in the right spot

ROUND OFFICE BUTTON > ACCESS OPTIONS > Object Designers <!-- / message --><!-- sig -->