the expression you entered has a function name Microsoft Access can't find

[Amy Blankenship]

I have a startup function that I run from the AutoExec macro that
essentially checks the connection between the front end and back end and
reconnects if necessary. This has been working for a really long time.
Today, when I opened the database, I got the message:
The expression you entered has a function name Microsoft Access can't find.

Then I get a dialogue entitled "Action Failed" with the following
information
Macro Name: AutoExec
Action Name: RunCode
Arguments: TestStuff(0)

It has three buttons, Step, Halt, Contine. Halt is the ony active one.

If I run the macro by itself, it works fine.

Any idea why this would suddenly do this?

Thanks;

Amy

 

[John W. Vinson]

I have a startup function that I run from the AutoExec macro that
essentially checks the connection between the front end and back end and
reconnects if necessary. This has been working for a really long time.
Today, when I opened the database, I got the message:
The expression you entered has a function name Microsoft Access can't find.

Then I get a dialogue entitled "Action Failed" with the following
information
Macro Name: AutoExec
Action Name: RunCode
Arguments: TestStuff(0)

It has three buttons, Step, Halt, Contine. Halt is the ony active one.

If I run the macro by itself, it works fine.

Any idea why this would suddenly do this?

Thanks;

Amy

Sounds like some sort of corruption. Make a backup of the database (don't
overwrite any existing backups, you may need them!!!) first.

Try in order:

Tools... Database Utilities... Compact and Repair.

Ctrl-G to open the VBA editor, and select Debug... Compile <your database>.
Fix any VBA errors that appear and compile again. If there were errors,
compact and repair a second time.

You may need to Decompile the database - see the instructions at
http://www.granite.ab.ca/access/corruptmdbs.htm.

It might be necessary to delete the TestStuff() Sub from the module that it's
in; copy and paste the source code out to Notepad, delete the routine, compile
and compact the database, copy it back in, compile and compact again.

John W. Vinson [MVP]

 

[Amy Blankenship]

OK, thanks. Will do.

Sounds like some sort of corruption. Make a backup of the database (don't
overwrite any existing backups, you may need them!!!) first.

Try in order:

Tools... Database Utilities... Compact and Repair.

Ctrl-G to open the VBA editor, and select Debug... Compile <your
database>.
Fix any VBA errors that appear and compile again. If there were errors,
compact and repair a second time.

You may need to Decompile the database - see the instructions at
http://www.granite.ab.ca/access/corruptmdbs.htm.

It might be necessary to delete the TestStuff() Sub from the module that
it's
in; copy and paste the source code out to Notepad, delete the routine,
compile
and compact the database, copy it back in, compile and compact again.

John W. Vinson [MVP]