The database I am using is running on an SQL server, using MS Access as the front end. One of the tables has a column CompanyID which is an auto-incremented primary key. I am unable to add a new company from a form unless I input the CompanyID - it isn't doing it automatically. I get an error until I put in a company ID, any suggestions would be greatly appreciated!

Talk to your DBA. I think he has to create a trigger for the field in the SQL table to make this work for you.

Thanks - I'll do that. (I am the dba)
http://www.access-programmers.co.uk/ubb/smile.gif

Hello!

I had the same symptoms and here is how i fixed it...

The primary key was set on the Server table OK, but it was not set up as identiy = yes.

I changed that an off it went fine.
:)

hope this helps someone.

Mike Collett