Hi i'm fairly new to access, i'm designing a system where users can upload their data into a simple table that can be queried and so forth.
When they try to upload from the frontend i get this error "you cannot record your changes because a value you entered violates the settings defined.."
When I import from the Backend that they don't access to, it works first time no error.
Why is this happening and how do I fix it. So far i have tried pasting the raw data to a new book in Excel and the import works but this isn't practical.
Thanks
Fraser