I'm developing a simple database with a number of tables, forms etc etc but for some reason a problem has developed with one of my forms. When I'm moving round the database working on forms, tables, queries, report etc as part of the development process sometimes the main data entry form fails to open in any view and I don't know why. My only option is to import the form from a backup database and once thats done everthing is fine ! Has anybody come across this or have any suggestions?? I'm a fairly novice user of Access so go gentle. BTW I using Access 2003. Thanks
My form wont open and I dont know why!!
- Thread starter lodgey47
- Start date
missinglinq
AWF VIP
- Local time
- Today, 15:11
- Joined
- Jun 20, 2003
- Messages
- 6,420
Sounds like recurring corruption of the main form. Two things commonly considered to be causes of corruption in databases, even in the development stage, are Compacting & Repair and Name AutoCorrect. Go to
Tools - Options - General
and untick Compact on Close and all checkboxes in the Name AutoCorrect section.
Probably would be a good idea to also create a new. blank database and import all objects, tables, forms, queries, modules, etc., into it. This will often do away with corruption problems.
Linq ;0)>
Tools - Options - General
and untick Compact on Close and all checkboxes in the Name AutoCorrect section.
Probably would be a good idea to also create a new. blank database and import all objects, tables, forms, queries, modules, etc., into it. This will often do away with corruption problems.
Linq ;0)>
spikepl
Eledittingent Beliped
- Local time
- Today, 21:11
- Joined
- Nov 3, 2010
- Messages
- 6,142
#2
This is very interesting. I have a DB with some tables, the contents of which are deleted (but not the tables themselves) each time new data is entered into the db. For this reason I have "Compact & Repair on close " ticked. Should one just let it balloon? Or what would the recommended operational maintenance practice be? Please enlighten me.
This is very interesting. I have a DB with some tables, the contents of which are deleted (but not the tables themselves) each time new data is entered into the db. For this reason I have "Compact & Repair on close " ticked. Should one just let it balloon? Or what would the recommended operational maintenance practice be? Please enlighten me.
Is it giving any errors at all?
Try going to VB Editir and unter Tool/Options set the debug to stop on all errors.
Second, are you sure your form is not running, or is it doing a loop before loading the GUI. Check task manager and see what is loaded.
Tells us more about the guts and function of the form.
What type of project are you developing MDB, ADP?
Try going to VB Editir and unter Tool/Options set the debug to stop on all errors.
Second, are you sure your form is not running, or is it doing a loop before loading the GUI. Check task manager and see what is loaded.
Tells us more about the guts and function of the form.
What type of project are you developing MDB, ADP?
