serious error

[krzysztof via AccessMonster.com]

Help!

(good day as well!)


I have been wotking on data base for very long time now, and the db uses a
lot of append queries. I have a lot of code, and functions, and the datbase
froze. upon re-opening it, every query i get states:

Compile error: in query expression Mid(([JCJOB]),4,3)

it is like it does not recognize that 'Mid' is a function.

Also, my toolbars at the top are all messed up, my formatting one is greyed
out.

Has anyone heard of this before?

if so, is there a cure?

Very Much TIA

~K

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200606/1

[Deano]

Re: serious error


"krzysztof via AccessMonster.c om" <u11875@uwe> wrote in message
news:6205fa560f 01e@uwe...[color=blue]
> Help!
>
> (good day as well!)
>
>
> I have been wotking on data base for very long time now, and the db uses a
> lot of append queries. I have a lot of code, and functions, and the[/color]
datbase[color=blue]
> froze. upon re-opening it, every query i get states:
>
> Compile error: in query expression Mid(([JCJOB]),4,3)
>
> it is like it does not recognize that 'Mid' is a function.
>
> Also, my toolbars at the top are all messed up, my formatting one is[/color]
greyed[color=blue]
> out.
>
> Has anyone heard of this before?
>
> if so, is there a cure?
>
> Very Much TIA
>
> ~K[/color]

Are all your references ok?

Faliing that I would decompile, compact, compile and compact again. Working
on a backup of course.