quote:
The problem is, that some of the fields in the Access DB have Validation Rules and Input masks setup. For instance, there is an email field with a validation of *@*.*The * wildcard is not recognized by SQL server and is consequently throwing an error on valid email addresses.
Have you created check constraint in your table in SQL Serevr to ensure the emaill address entered into SQL Server is valid before it goes to Access database?