Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rating: Thread Rating: 5 votes, 5.00 average. Display Modes
Old 05-11-2003, 06:25 PM   #1
Essendon
Member
 
Join Date: Oct 2001
Location: Australia
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Essendon
Unhappy Access database crashes access on startup

Hi,

I am developing a database in Access XP. I have been coding away all day. I did a compact and repair and then closed access. Later on when I tried to open up my database again it crashed access on startup. It does it every time now. About the same time the default form should be displayed

I have code that runs on startup and I was wondering if there is any way that I can stop this code from executing to see if it is the cause of the problem.

I thought I could just import everything into a new blank database, but because my database is secured with a workgroup file when I go to import from a new database it says that I "Don't have the necessary permissions...." Can I set these permissions up?

I really need help. This wouldn't be the first time I've lost a couple of days work because of something stupid like this.

Any advice appretiated.

Thanking you,

Peter


Last edited by Essendon; 05-11-2003 at 06:35 PM.
Essendon is offline   Reply With Quote
Old 05-11-2003, 06:41 PM   #2
ghudson
Newly Registered User
 
ghudson's Avatar
 
Join Date: Jun 2002
Location: USA
Posts: 6,199
Thanks: 1
Thanked 83 Times in 48 Posts
ghudson has a spectacular aura about ghudson has a spectacular aura about ghudson has a spectacular aura about
Cool

You can hold down the Shift key before the db is opened (after you key the Name: and Password: but before you click the OK button). Unless the Shift key has been disabled, the Shift key will prevent the Startup form from opening and also prevent the AutoExec macro from running.

HTH
__________________
.................................................. ......
Searching this forum or Microsoft.com or MSDN.com or Google is a great way to discover and learn the answers to your Access programming questions.

Well if it seems to be real, it's illusion...

I am using Access 2010 with Windows 7

The
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
function on this forum really does work.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

.................................................. ......
ghudson is offline   Reply With Quote
Old 05-11-2003, 06:57 PM   #3
Essendon
Member
 
Join Date: Oct 2001
Location: Australia
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Essendon
Thankyou for that.

After I got into the database I tried to compact and repair it, but the crash would keep occuring. Then I compiled all of my modules and did another compact and repair and all of a sudden it was back to normal. Very wierd.

Thanks again.

Essendon is offline   Reply With Quote
Old 05-17-2003, 09:44 PM   #4
Benny Wong
Registered User
 
Join Date: Jun 2002
Location: San Francisco, Ca.
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Benny Wong
Same problem before

Hello Essendon,
I have the same experience before but I took some precautions. What I did was:

1. create a new database and import everything into the new database. This way I can eliminate the database container being intermittant.
2. Periodically run compact & repair then save the database.
3. When I save the database I zipped it with a format as such: May_17.zip for the first version of the day. The next version will be May_17a.zip, etc... I create a readme.txt file that explains the May_17.zip, May_17a.zip development process. This is my cheap version of version control and insurance if something goes wrong I can go back to the previous version and also keep track of what I need to accomplish with a check off list of ideas I need on the database.

Hope my idea help you on your process.

Benny Wong is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 05:33 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World