Thanks for the help. We found it was the regional settings combined with the ODBC settings that were causing the problem. We have tested it and made the changes for everyone.
We have an Access 2003 database that has tables linked from our SQL server (SQL 2003) database. The SQL database stores data from our HRIS system. We recently upgraded from SQL 7 and Access 97 to this newer environment.
In one of the tables we have a field, which is a numeric field with 4...
Matthew,
What you need to do is to turn the warning messages off.
If you are using a macro, you will need to insert a row and select SetWarnings and then the "Warnings On" option to No.
It is a good practice to turn them on again when you have completed your macro.
If you are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.