By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 2,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Access 2003 Corrupting adp files

P: n/a
Anyone else experiencing corruption problems using Access 2003 to
edit .adp files? I've been experiencing corruption problems with a
particular database. I've tried copying all the objects into a new
file, but it didn't help.

Here is an example of the problem, yesterday I added a new field to my
SQL table. To put it on the form I copied an existing text field and
converted that field from text to combo box. Quicker because I'm
using a different font/size than the Access default. Anyway each time
I did that Access would crash when I would try to save the form. When
Access would reopen the form was unusable. I couldn't even open it.
I tried it a second time just to see if it was a series of actions
that would consistently crash Access and it did crash again.

I went to a back up copy and created a new combo box field from the
toolbox and it saves fine.
Jul 26 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Just this morning this happened repeatedly to me when I copied a
textbox from a group header on a report to another group footer and
changed it to a label. Solution was the same as well; I stopped
copying the textbox and just created a new label; no more crash.
(Access 2007 - 2000 ADP - Vista).

On Jul 26, 9:26*am, Access <alderran...@gmail.comwrote:
Anyone else experiencing corruption problems using Access 2003 to
edit .adp files? *I've been experiencing corruption problems with a
particular database. *I've tried copying all the objects into a new
file, but it didn't help.

Here is an example of the problem, yesterday I added a new field to my
SQL table. *To put it on the form I copied an existing text field and
converted that field from text to combo box. *Quicker because I'm
using a different font/size than the Access default. *Anyway each time
I did that Access would crash when I would try to save the form. *When
Access would reopen the form was unusable. *I couldn't even open it.
I tried it a second time just to see if it was a series of actions
that would consistently crash Access and it did crash again.

I went to a back up copy and created a new combo box field from the
toolbox and it saves fine.
Jul 26 '08 #2

P: n/a
Yep, just about the first thing I discovered with Access 2007 is that if you
change a text box to a label and then save the form, Access will crash every
time. It's on Allen Browne's list of bugs, and is *not* fixed in SP1.

However, the OP is using Access 2003, where I for one have not encountered
this particular problem. However, in my experience Access 2003 ADP files
*are* generally very corruption-prone.

"lyle fairfield" <ly************@gmail.comwrote in message
news:4c**********************************@34g2000h sh.googlegroups.com...
Just this morning this happened repeatedly to me when I copied a
textbox from a group header on a report to another group footer and
changed it to a label. Solution was the same as well; I stopped
copying the textbox and just created a new label; no more crash.
(Access 2007 - 2000 ADP - Vista).

On Jul 26, 9:26 am, Access <alderran...@gmail.comwrote:
Anyone else experiencing corruption problems using Access 2003 to
edit .adp files? I've been experiencing corruption problems with a
particular database. I've tried copying all the objects into a new
file, but it didn't help.

Here is an example of the problem, yesterday I added a new field to my
SQL table. To put it on the form I copied an existing text field and
converted that field from text to combo box. Quicker because I'm
using a different font/size than the Access default. Anyway each time
I did that Access would crash when I would try to save the form. When
Access would reopen the form was unusable. I couldn't even open it.
I tried it a second time just to see if it was a series of actions
that would consistently crash Access and it did crash again.

I went to a back up copy and created a new combo box field from the
toolbox and it saves fine.

Jul 26 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.