Funny thing is just yesterday I had an Access 2007 .accdb format file
crashing on me. I have a form with a subform. If I go in and set the link
master and link child properties and then hit save it crashes. I tried
copying all the objects into a new file and it still crashes.
Working with .adp files it crashes all the time too. For a while I thought
it was because I had Office 2003 and 2007 on the same pc, but recently my
hard drive died and I only installed Office 2007, yet it still crashes.
"a a r o n _ k e m p f" wrote:
> I really don't think that I've had any problems with this since Access
> 2000.
>
> Honestly. Not one crash or corruption.
>
> -Aaron
>
>
> On Jul 26, 11:18 am, "Sylvain Lafontaine" <sylvain aei ca (fill the
> blanks, no spam please)> wrote:
> > And especially if you are opening your ADP project file over a bad network.
> >
> > If copying or importing the objects don't work, then you should rebuild your
> > forms: create an empty form and then copy&paste all the controls from the
> > other form; after that, copy the code. To simplifying the copy of the
> > controls at their exact same location, add a control at the position (0,0)
> > before doing the copy&paste.
> >
> > Also, you can change the default font/size: create a form called Normal and
> > then click on any control *in the toolbar*, for example the Label control..
> > In the property form, you should see Default Label. Change its properties
> > and close the Normal form. Now, all new forms will be created with the new
> > defaults. You can also change the default values of an existing form but
> > this must be done form by form. Same thing for the reports.
> >
> > --
> > Sylvain Lafontaine, ing.
> > MVP - Technologies Virtual-PC
> > E-mail: sylvain aei ca (fill the blanks, no spam please)
> >
> > "bcap" <b...@nospam.nowhere> wrote in message
> >
> > news:488b578c$0$26080$(E-Mail Removed)...
> >
> > > Yep, ADP files corrupt easily and frequently.
> >
> > > Usually importing everything into a new file cures it, but not always!
> > > Ensure that you make very frequent backup copies!
> >
> > > "alderran" <alder...@discussions.microsoft.com> wrote in message
> > >news:2CE07C8E-2027-4348-8890-(E-Mail Removed)...
> > >> 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.
> >
> > >> That's just one of many examples. It happens all the time. If I use
> > >> Access
> > >> 2007 it happens less often, but still it's a pretty unstable file. I
> > >> have
> > >> 100's maybe even 1000's of hours devoted to it and I'm always afraid to
> > >> do
> > >> anything without a million copies. Now my client is asking about making
> > >> his
> > >> own changes to the forms. Which would normally be okay but not with this
> > >> file.
> >
> > >> any help would be greatly appreciated!
>
>
|
Similar Threads
