Thanks John. As usual your advice worked.
I compiled and then was able to create the MDE file.
(When I opened the VB Editor, I realized that many,many forms were open. I thought that when I save and close the form, it also closed the VB code, but that does not seem to be the case?. I closed each form individually. Maybe this had something to-do with my problem, because I edit most forms in my 2003 DB and when they are finished I copy/paste them to the 2000 DB, so my 2000 DB did not have many open forms in the VB Editor.)
Thanks again
Sarah
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Sarah-
>
> Can you open the VB Editor and compile the VB project? Choose Compile from the
> Debug menu. The project must be compiled and saved before you try to create an
> MDE.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of novice012000
> Sent: Tuesday, November 29, 2011 5:23 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Form corrupts Access 2003 database: Symptons
>
>
>
>
> Perform AutoCorrect is off in both databases 2000&2003.
>
> Symptons: Freezes when I try to create MDE file. I can compact and repair, I can
> import all forms, tables queries etc into a new database, but when I try to make
> a change to the same form in the new database and then try to crease an MDE
> file, it also freezes.
>
> Sarah
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Sarah-
> >
> > What makes you think it's corrupted? What are the symptoms? Have you turned
> > off Perform AutoCorrect in the database?
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
> > -----Original Message-----
> > From: MS_Access_Professionals@yahoogroups.com
> > [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of novice012000
> > Sent: Tuesday, November 29, 2011 2:13 AM
> > To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Form corrupts Access 2003 database
> >
> > If have a database in Access 2000 and the 'same' DB in Access 2003. I need to
> > change one form. The form is a simple form that starts a report. I need to
> make
> > a small change to the on-open event of the form. As soon as I change the form
> in
> > 2003 it corrupts the database. The exact same change in the Access 2000
> database
> > works. If I copy the changed from from the 2000 db to the 2003 db, it corrupts
> > the 2003 db.
> > Any hints?.
> > Thanks
> > Sarah
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar