Forum Home
Press F1
Thread ID: 79498	2007-05-22 00:05:00	troublesome MS Access Database	susann (12077)	Press F1

Post ID	Timestamp	Content	User
551883	2007-05-22 00:05:00	I'm trying to open a MS Access database but it keeps closing on me! I see it briefly for a second or 2 and then it closes itself and Access as well . I've tried opening it in both Access 2002 & 2007 . The table in the database it linked to by another database (which contains a data entry and a data search form) . When I opened it in 2007 I could see a form called "frmCloseIt" with a message saying "This application will close now!!!" . Does this mean it can't be opened directly? Some sort of protection maybe? I need to access it so I can add another field (a hyperlink) . I didn't create the database - it was created back in 2003 . Cheers Susan	susann (12077)
551884	2007-05-22 00:37:00	Is it a mdb or mde? What exactly do you want to do here? Looks like the database has been coded to stop anybody from opening the database.	singh (11829)
551885	2007-05-22 00:41:00	it's an mdb. I can understand that whoever created it wanted to protect the data - all the data going in should be entered via the data entry form in the second database which is linked to this one. But if I wanted to add another field, surely I need to access it? I don't think that if I added another field to the data entry form that it would automatically add it to the table (would it???).	susann (12077)
551886	2007-05-22 01:29:00	It's been a while since I dabbled in Access but when I had to change a db that ran some VBA when it was opened, I had to open the db while holding the shift key down to stop the VBA from executing.	Sam's Dad (11848)
551887	2007-05-26 01:10:00	Hi Susan No, adding another field to the form will not add the field to the table. As Sam's Dad mentioned, it appears the designer of the database created a form that opens at start-up and there is a VBA timer event in that form that forces the database to close. Locate the database using Windows Explorer, press the shift key (and kept it pressed) while you open the database. Only release the shift key once the database screen appears. To stop this from happening again, go to the Access menu option Tools > Startup > under 'Display Form/Page' set the option to 'None' from the drop down list. If it still occurs, re-open the database and see if there is a macro called 'Autoexec' - if so then rename it to '_Autoexec'. Once you are in to the database then you can add the new field(s) to the table and then modify your form. HTH, Andrew	andrew93 (249)
1