If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Corrupt Forms
I have database with 15 forms. 2 out of the 15 forms are the most heavily
used and somewhat more complex than the other forms. Every so often when I use the forms or go into the design view and make changes, the forms seem to dissapper but are sill listed in the Database Window. Sometimes, compacting and repairing reinstates the forms. However, other times the forms can neither be opened nor designed after compact and repair. I used the 'Saveastext' and respectively 'Loadfromtext' functions to copy all the forms, queries, reports and modules from a backup copy of the database to a new database and imported the tables to solve the problem. However, the problem is still popping after continued design or repetitive use of the two forms. Any help would be appreciated. I know I can copy over the controls from the suspect forms to blank forms, but wanted to avoid that because it seemed easier do use the 'Saveastext' and 'Loadfromtext' |
#2
|
|||
|
|||
Corrupt Forms
Since this is a chronic problem for you, you might want to read Allen
Browne's treatise on the causes and methods of preventing corruption: http://allenbrowne.com/ser-25.html -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Corrupt Forms
Sorry, meant to add, the page also has a link to Allen's paper on recovering
from corruption. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
#4
|
|||
|
|||
Corrupt Forms
Linq Adams wrote:
Sorry, meant to add, the page also has a link to Allen's paper on recovering from corruption. Thank You, I will take a look. |
Thread Tools | |
Display Modes | |
|
|