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!
Inserting data into a linked table
- Thread starter k_heppner
- Start date
O
OPMCoordinator
Guest
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
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
