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 (1 Viewer)
- Thread starter k_heppner
- Start date
- Local time
- Today, 07:06
- Joined
- Feb 19, 2002
- Messages
- 43,430
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.
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
