Edit existing Autoexec macro

B

Bernice Lau

I am relatively new to using Access, and I've inherited a project using an
Access database.

The database was created in Access 2003, and we're currently trying to run
it in Access 2007. It uses an Autoexec macro to run the database, and on
startup it gives me a message "cannot find the toolbar 'Page View'". I would
like to edit the macro, so that it no longer uses the 'Page View' toolbar,
but I can't seem to figure out how to actually edit the Autoexec macro. I can
find how to create new macros and run them, but I can't edit any of them.

Any help would be greatly appreciated!
 
K

KARL DEWEY

First back up your database.
Open the database window by clicking on the first open item listed under
menu Window. It will have a 1 that has an underscore.
Click on Macros.
Click on the one named Autoexec.
Click on the design icon.
Click on menu FILE - Save As and type in Autoexec_1 to save a copy of what
you have now just in case.
Close the window.
Click on the one named Autoexec.
Click on the design icon.
Find the offending line(s) in the macro and edit by using menu EDIT - Delete.
Save. Close the window.
Restart the database.

If there are problems in starting due to errors then on starting hold down
the SHIFT key so that the Autoexec macro does not attemp to run.

If there are problems then open the Autoexec_1 and save as Autoexec to work
with the orignal copy.
 
B

Bernice Lau

Thanks for your quick reply Karl. Unfortunately, I'm not very familiar with
Access 2007, and the ribbon menus are not helping to make things easier.
Which view should I be in to try and click on Macros?

I'll try to explain what I can see when I open my database. Since I want to
edit the database and not run it with the Autoexec, I use shift+double click
to open it. Upon opening, I get a list of the tables in the database. Under
database tools, I can run the macros, but I can't seem to edit them.

Thanks for your help so far!
 
B

Bernice Lau

Thanks for all your help, Karl. In Access 2007, the database window was
replaced by a Navication Pane, and from there I could follow your
instructions. It's all fixed now!

Bernice
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top