Microsoft Access can't find the macro '.'

Hi,
I'm getting an error message "Microsoft Access can't find the macro '.'" when tryi
ng to open any database.
I use MS Access 2003.
Any ideas to correct this issue?
I have attached image of error message.

Emil.

Check your macros and see it there is one called "autoexec".

The Autoexec macro runs first thing when you start Access. It would normally be used for somthing like opening your switchboard or menus when you first open the database. It could be someone placed it into your macros at some point and its referencing another macro that isn't there.

The chances are, you've placed a full stop in one of the events.

I've done the same thing before.

Find out at what point this message triggers and it will lead you to the culprit.

I'm getting the same error message when I open ANY database in Access 2003, including blank databses with no content (created to test this error). Does anyone have any ideas as to what could be causing this?

Many thanks in advance.

Try this http://www.access-programmers.co.uk/forums/archive/index.php/t-77492.html

Thanks for the link, but I'm afraid I'd already seen that... the problem is that it seems to be an actual 2003 error rather than one that's tied to a specific db or bit of code - I've had them try opening a number of different files with different content, including one with no content at all.

I appreciate you trying though

can't find macro '.' with every new/old database

Hi,

Did this problem get resolved?

I have the same problem with the fact that any new created or old opened database comes up with this error.

It isn't anything to do with a space in a form command "open with"

It happens before you can even do anything.

Where would I find this macro called "Autoexec"?

Thanks for your help!

Matt

Problem resolved!!!!!

It is to do with the File association on MDB files

The long way around to do it is

1. Open My Computer

2. Tools > Folder Options > File Types

3. MDB > Advanced

4. Select "Open" and then click Properties

Change the settings in there to:

DDE
[SetForeground][ShellOpenDatabase "%1"]

Application
Msaccess

DDE App not running
[SHELLNOOP]

Topic
ShellSystem


The easy way is to copy and paste this into a notepad and call it macro.reg

WARNING! This one is for Access 2003 - for earlier versions, please go the long way around.
________________________________________________________________

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Access.Application.11\shell]

[HKEY_CLASSES_ROOT\Access.Application.11\shell\New]

[HKEY_CLASSES_ROOT\Access.Application.11\shell\New\ddeexec]
@="[SetForeground][ShellNewDatabase \"%1\"]"

[HKEY_CLASSES_ROOT\Access.Application.11\shell\New\ddeexec\application]
@="Msaccess"

[HKEY_CLASSES_ROOT\Access.Application.11\shell\New\ddeexec\ifexec]
@="[SHELLNOOP]"

[HKEY_CLASSES_ROOT\Access.Application.11\shell\New\ddeexec\topic]
@="ShellSystem"

[HKEY_CLASSES_ROOT\Access.Application.11\shell\open]

[HKEY_CLASSES_ROOT\Access.Application.11\shell\open\command]
@="\"C:\\Program Files\\Microsoft Office\\OFFICE11\\MSACCESS.EXE\" /NOSTARTUP \"%1\""

[HKEY_CLASSES_ROOT\Access.Application.11\shell\open\ddeexec]
@="[SetForeground][ShellOpenDatabase \"%1\"]"

[HKEY_CLASSES_ROOT\Access.Application.11\shell\open\ddeexec\application]
@="Msaccess"

[HKEY_CLASSES_ROOT\Access.Application.11\shell\open\ddeexec\ifexec]
@="[SHELLNOOP]"

[HKEY_CLASSES_ROOT\Access.Application.11\shell\open\ddeexec\topic]
@="ShellSystem"

______________________________________________________________

Sorted