I am using ms access as a frontend to a MSSQL database using ODBC. The problem is when I created a form to enter data everythis seemed to be fine, however, after I added the first record access will no longer allow me to edit or add any more. I look on the server and the data went in there fine and it is ready to go for the next record. Any ideas on what the problem may be and how to fix it would be great.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can't add or edit data in access frontend to MSSQL
- Thread starter samelmer
- Start date
- Status
Similar threads
