Did MS Access ever tell you that.... :)

Hi guys,

Yesterday I typed an SQL statement in MS Access and got an error, please see it attached.

Does this mean my code is right but Access can't do it and that's why it is wrong?



I was loughing for an hour or so

 

I had this error once.. and did some research on it
Error Number: 3025
Error Message: Reserved error <item>; there is no message for this error. Class : unused

There are two possibilities in this case either a timestamp problem or the query hitting an un-used class.
Removing the timestamp and recreating at end can fix this problem if its related with the first one...
Hopefully you have fixed the error by now?

 

no didn't need to continue, I just needed a system for an Army database for a friend of mine, he said its okay if I have one less function so I stopped it

 

Just out of curiosity what was that query meant to do?

 

that query meant to do the following:

When you choose a soldier and want to send him lets say to the district X, it was suppost to see how many people with the mention profession are allowed to go to district X and how many are there now. then put that data in a TEMP table, then the VB script should have checked the TEMP and see whether they can send that person there or no

hope I was clear in explaining

 

ok seems pretty simple .. i am sure you must have done it easily

 

i'd do it easily with ASP and MsSQL or even ACCESS but not VB