michaelak117
Registered User.
- Local time
- Today, 10:09
- Joined
- Mar 12, 2009
- Messages
- 37
I recently split my database to take advantage of multi user capabilities and also set passwords for my database. I created a pw for my BE and FE databases. Everything within the FE DB has been working fine except for one feature. On the daily I run a process that involves importing data and runnning queries off of it. I have set my imports to be automatic at the press of a button on a form.
After these security additions this automatic import no longer works, I have been having to manually import in the BE database, when I was to automatically import on the FE. Previously I had passwords set, ( i have now taken them off) and would get a "invalid password" error message when trying to import on the FE. Now the error message I get says "You cannot record your changes because a value you have entered violates the settings for this table (for example a value is less than the minimum or greater than the maximum). Correct the error and try again."
What would cause this and can I fix it. Also, if I can fix this would it hurt to make the front end DB a ACCDE file? Thanks
Mike
After these security additions this automatic import no longer works, I have been having to manually import in the BE database, when I was to automatically import on the FE. Previously I had passwords set, ( i have now taken them off) and would get a "invalid password" error message when trying to import on the FE. Now the error message I get says "You cannot record your changes because a value you have entered violates the settings for this table (for example a value is less than the minimum or greater than the maximum). Correct the error and try again."
What would cause this and can I fix it. Also, if I can fix this would it hurt to make the front end DB a ACCDE file? Thanks
Mike
