Novice
Windows Vista 
Access 2010 32bit
@orange: I read your list.
The deal is the program has worked for years
There hasn't been any changes made to the .mdb
It throws the error intermittently
This all started when I moved the .mdb to a different server.
The other two divisions have the same C# program, and they were moved to the same server, without problems.
Moderator
Windows 10 Access 2010 32bit
It could be a permissions issue, if you moved an account to a different server????
VIP
Windows 7 64bit Access 2007
You could try to create a New database and import everything from problem database. See if that resolves whatever is hanging up. Sometimes Access gets lame and you have to shoot it and start again.
Novice
Windows Vista Access 2010 32bit
OK, I want to rebuild the table. Not being an Access user, I Googled around. I exported the data and structure to xml / xsd.
Then I imported - into SHIPT01. All seems fine. Except when I open the new table I get a dialog that says: Enter Parameter Value, then it asks me for the last field in the table: shipto.query.time.
I noticed that it says shipto.query.time - like it's looking at the old table?
Select Query Intermittent Error: value you entered isn't valid for this field
Use updateable query error
Posting Permissions
Reply With Quote