Access autorun

[wolves_chris]

I have a problem in that I have created a database and set it up so that the menus do not show and a switchboard is displayed straight away on opening.

This is the only copy of the database I have and was wondering if there was anyway I can stop the autorun on opening so that I can do some updates.

Thanks in advance

 

[Mile-O]

Hold down [Shift] while you open the database.

 

[wolves_chris]

Thanks for the quick response - unfortunately I have also disabled that - I have a feeling I have got a lot of work ahaead of me!!

(It will teach me to be more careful when choosing between save and save as I suppose)

 

[Mile-O]

(It will teach me to be more careful when choosing between save and save as I suppose)

...and keeping a development copy of your database.

 

[wolves_chris]

I take it that I have no option but to do a complete re-write then?

 

[SforSoftware]

Did you also disable the Access Keys ? If not, press F11 when running the database to show the database-window, or ALT+F11 for the VB-editor.

Else you can set the AllowByPass-property to True from another database using DAO

 

[Rich]

Import everything into a new blank db

 

[wolves_chris]

I have disabled the Access Keys as well - doh.

When I try to import into a blank database, I can only get the tables and queries - the forms and reports stay greyed out. At least I won't have to recreate everything.

 

[Rich]

Then it's an MDE db, where's the original?

 

[wolves_chris]

The original database was stored on my server and the mde was on a local drive. I had a hard disk failure on the server (which I hadn't backed up) and so I lost the only copy of the original I had.

At least I have the table and query files and so that will save me some work. The reports and forms shouldn't take too long to recreate, and at least I have learned some valuable lessons (regular backups, multiple copies etc)

Thanks to everyone for their help - I'm going to crawl into a corner and hang my head in shame for a while and think about what I have done.