ACCESS FEED: RE: [MS_AccessPros] Form corrupts Access 2003 database: Symptons

Rabu, 30 November 2011

RE: [MS_AccessPros] Form corrupts Access 2003 database: Symptons

Sarah-

Number of forms open in the VB Editor shouldn't have made a difference, but it
would affect the make MDE process if you had compile errors that weren't
resolved. If closing all the code windows worked for you, then that's good!
Always compile and save your project before attempting to make an MDE file.

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: Wednesday, November 30, 2011 12:13 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Form corrupts Access 2003 database: Symptons

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
>

------------------------------------

Yahoo! Groups Links