All,
I had originally started this topic in the Forms Forum, but to my discovery it has nothing to do with forms and my question has really changed, so I thought I'd ask here...
My table callled licenses has a primary key field called licenseID. I am connecting to postgreSQL server. When I send all the required fields (minus the licenseID) to the server, the server generates an autonumber for the licenseID. This is working properly as immediately after I hit the enter key in the access table, the server shows the new record with the proper licenseID.
HOWEVER, after hitting the enterkey, the new record is displayed in ACCESS as an exact duplicate of the previous record. The newly added record cannot be found in the table unless the table is sorted, opened and closed, etc...
Also, if I enter a number for the licenseID rather than letting the server take care of it, there are no problems and no duplicates. The the only issue is when adding new records without the licenseID.
Bringing the autonumber to the access side is not an option as the table properties can't be changed. And again, the record is displayed correctly on the SQL side so I'm pretty sure the problem is within Acces. Any help would be greatly appretiated.
Thanks!
Brady
I had originally started this topic in the Forms Forum, but to my discovery it has nothing to do with forms and my question has really changed, so I thought I'd ask here...
My table callled licenses has a primary key field called licenseID. I am connecting to postgreSQL server. When I send all the required fields (minus the licenseID) to the server, the server generates an autonumber for the licenseID. This is working properly as immediately after I hit the enter key in the access table, the server shows the new record with the proper licenseID.
HOWEVER, after hitting the enterkey, the new record is displayed in ACCESS as an exact duplicate of the previous record. The newly added record cannot be found in the table unless the table is sorted, opened and closed, etc...
Also, if I enter a number for the licenseID rather than letting the server take care of it, there are no problems and no duplicates. The the only issue is when adding new records without the licenseID.
Bringing the autonumber to the access side is not an option as the table properties can't be changed. And again, the record is displayed correctly on the SQL side so I'm pretty sure the problem is within Acces. Any help would be greatly appretiated.
Thanks!
Brady