RE: Edit existing Autoexec macro

I do not have Access 2007 so I can not tell you how to get to the macros.
--
KARL DEWEY
Build a little - Test a little


"Bernice Lau" wrote:

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!

"KARL DEWEY" wrote:

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.
--
KARL DEWEY
Build a little - Test a little


"Bernice Lau" wrote:

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!
.

Relevant Pages

  • Re: web application framework
    ... Actually the macros will shroud the details, ... and teach it to output database schemas or schema ... I'm partial to a fine grained object model with a generated core mostly ... core engine is completely off base, then sure, changes may be justified. ...
    (comp.lang.lisp)
  • Re: I need some expert advice on database design
    ... What version of Access did the consultant say he worked with last? ... Using Access you can create a workable database without using or knowing ... However, depending on your organizations needs, coding VBA is suitable ... do more than just creating some macros and converting them to code. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: need access to read to SQL db and Access frontend
    ... be using VBA or because if they have a good design they won't need macros? ... tool tip with the path to the source database or DSN for the ODBC database. ... If the tables are linked to a SQL Server database or even another Access ... because my supervisor doesn't like the interface for dbA. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Form name doesnt exist error messge and I cant locate that form.
    ... Macros should have a tab on the database screen... ... In 2003 in the Objects column. ... Is there a Macro by the name of AutoExec. ...
    (microsoft.public.access.reports)
  • Re: need access to read to SQL db and Access frontend
    ... The fact that there are no macros doesn't mean that the database was ... Yes, as long as you can get to the database container, you can see the name ... If the tables are linked to a SQL Server database or even another Access ... separate module/entity from dbA and doesn't need to be related but I ...
    (microsoft.public.access.tablesdbdesign)
Loading