Forum Discussion
Can not enter new record via Access front end after linking tables to SQL Express
I have a Time & Billing Access program. I just migrated the tables to a SQL Express database and using it as the back end: tables all linked to the front end Access program. With my Access front ...
(1) what error do your get?
Please provide the full exact text + screenshot (notice that I Said "+" and not "OR"!!!)
(2) What is the table DDL (please provide the query to create the table in the SQL Server). The exact type of the column is the main information we need, but please provide the exact DDL so we will not miss any important point which can be the source.
(3) What is the type of the column in your access? WHat is the exact type of the field in the form you use in the access
Note: Most common is that you try to INSERT text instead of DATE/TIME. In any case, without more information my guess us that the issue related to differences in types