ISAUTOINCREMENT property of a field

Posted on 2006-05-02
Medium Priority
Last Modified: 2010-05-18
I've found two EE cases where people asked how to determine if a table field is an Autonumber field. Both answers show how to check the ISAUTOINCREMENT propety of a field. When I try that with Access 2003 I get an error that the property is not found.
Question by:paulmcneil
1 Comment
LVL 44

Accepted Solution

Leigh Purvis earned 2000 total points
ID: 16592062
You could try a one liner

If (Currentdb.TableDefs("TableName").Fields("FieldName").Attributes and dbAutoIncrField) > 0 Then
    'Yep - it is one
End If

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question