[groupsource]

Hello Masters of Access

I have written a reservation program in Microsoft Access and when I open my form I get the following message "reserved error (-1517); there is no message for this error". At this point I can click ok or help When I click help it says "Reserved error <Item>; there is no message for this error. (Error 3000)
An unexpected error occurred. The specified code identifies the conditions under which this error can occur. Please contact Microsoft Product Support Services for more information."

I have shut down and done a compact and repair but it keeps coming back

Any help?

 

[MustBNuts]

Has it always done this or did this just start happening? What version(s)?

MBN

 

[groupsource]

it just started 2 days ago. We have had the program for about 3 years now We created it in 2000 and the data sits on a server but the workstations are between 2000 & 2003

 

[MustBNuts]

Any pattern to which machines throw the error? Have you made any changes to the prog?

...and do you have any backups that you might be able to use for comparison purposes, or better yet, replacement?

MBN

 

[groupsource]

the error appears on all versions Yes we do backup every night. I would rather not have to do that as we have entered a lot of info over the last 2 days

 

[MustBNuts]

Something had to have changed two days ago....any changes to structure, etc?

Another thing to consider trying, extract data added in the last two days and append it to an older version and see what happens. Is it possible there is some corrupt data in there?

MBN

 

[groupsource]

We did backup the program on a flash drive the night before this happened. When we came in the following morning we started getting the message. But that is it. A few days earlier we added a macro on our form so that we can email out of the form. The macro moves it to word and puts it in a email. That had been working fine

 

[MustBNuts]

That HAD been working fine...is it no longer working? Found this in MSKB regarding email in Access:

http://support.microsoft.com/default.aspx?scid=kb;en-us;260819&Product=acc

 

[MustBNuts]

I realize it doesn't conform exactly to your error....but hey, it's a start....maybe take a look at your macro again...possibly disable it, to get it working....

 

[MustBNuts]

here's another one, pertains to reserve errors, looks again like it may revolve around your new macro:

http://support.microsoft.com/default.aspx?scid=kb;en-us;126825

 

[MustBNuts]

okay, did a search on "reserved error" (without quotes), all products, in MSKB and came up with a few possibilities, I suggest you take a look at all of them...I can't be/get more specific because, on this side, we just don't have enough info on the structure/changes on your dbase.

But post back with anything else...I'm curious too....

MBN

 

[MustBNuts]

jetpack error codes:
http://support.microsoft.com/default.aspx?scid=kb;en-us;172570

 

[groupsource]

I sure will reply with results. Question, In my reservation system I created with Access, I have many tables. When I open the program-go to tools-and do a compact & repair. Does it compact every table or is there another method to do this

 

[MustBNuts]

From what I understand, it compacts the entire system, tables included.

 

[groupsource]

hey guess what I went to each workstation and did a compact and repair. At this point in the day the error has not occured. I'll keep you posted

 

[MustBNuts]

WOOHOOOOO!

but....question: how is this dbase distributed?

 

[groupsource]

the program sits on our workstations and the data sits on the server. does that answer your question?

 

[MustBNuts]

yup...

doesn't really explain how the error popped up...hmmmmm, interesting...

MBN