Prev: Tab Order
Next: Hide ribbon event not working
From: JamesJ on 4 Jun 2010 11:52
Access 2007 sp2.

I hope I explain this ok... Here goes.

When I want to discard changes made to a form by importing a form form a backup
the imported form takes on all the characteristics of the form I want to replace.
As an example, lets say I remove a command button from Myform in my main db.
I then import Myform from a backup knowing that this form still has the
command button. When I open the imported formj (Myform1) it still has the command
button and is identical to the form I'm trying to replace.
Keep in mind this is only an example 'cause I wouldn't import a form just for one command button.
Actually I made many changes to this form when I decided I didn't like it and decided to import from the backup.
After importing the imported form was identical to the one I'm trying to replace.
When I open the db with the form I want to import the form is fine. It seems to magically change
to the one I want to replace after importing.
I tried importing the form from a backup I did in February and the same thing happened.
Doesn't matter, I could import a form from February 2007 and there would be the same results.
In fact I imported the form from 5 other backup with the same results.
I renamed to old form before importing and I deleted the form before importing with the same results.

Access seems to see both the old form and the imported as the same even though they are different.
Only if I create a new db and import all the objects from the db with the form I was trying to import
does the form import properly.
I've created several new dbs and have imported all the objects from a backup several
time in the past 2 weeks just to try to eliminate corruption.
As far as corruption is concerned I printed out 'Preventing Corruption' from Allen Browne's fine web site.
The only thing I might have here is if my computer is over heating without my knowledge.
I have no other problems with any other software on my computer. My os Vista Basic sp2 x32
seems to be running fine.
If it is corruption my db becomes corrupt ever few days or so.
Seems I can't breath on my db the wrong way.
Oh yes, I can admit I gave unplugged my power cord to the computer on several occasions in the past year.

Any help or suggestions will be appreciated,
James
From: Allen Browne on 4 Jun 2010 22:08
Hi James

There does appear to be some corruption in your database, so here's how I
would approach it.

Follow the 8 steps on this page to:
http://allenbrowne.com/recover.html

Now delete the form you plan to replace, and compact again.

Then open the database that you plan to import from, and go through the
first 7 steps in that one too.

Now try the import. Because you cleaned up both files, and deleted and form
and compacted it to get completely rid of it before importing it, the ghost
form should be gone.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JamesJ" <jjy(a)darwin_roadrunner.com> wrote in message
news:uBbJn3$ALHA.6116(a)TK2MSFTNGP02.phx.gbl...
Access 2007 sp2.

I hope I explain this ok... Here goes.

When I want to discard changes made to a form by importing a form form a
backup
the imported form takes on all the characteristics of the form I want to
replace.
As an example, lets say I remove a command button from Myform in my main db.
I then import Myform from a backup knowing that this form still has the
command button. When I open the imported formj (Myform1) it still has the
command
button and is identical to the form I'm trying to replace.
Keep in mind this is only an example 'cause I wouldn't import a form just
for one command button.
Actually I made many changes to this form when I decided I didn't like it
and decided to import from the backup.
After importing the imported form was identical to the one I'm trying to
replace.
When I open the db with the form I want to import the form is fine. It seems
to magically change
to the one I want to replace after importing.
I tried importing the form from a backup I did in February and the same
thing happened.
Doesn't matter, I could import a form from February 2007 and there would be
the same results.
In fact I imported the form from 5 other backup with the same results.
I renamed to old form before importing and I deleted the form before
importing with the same results.

Access seems to see both the old form and the imported as the same even
though they are different.
Only if I create a new db and import all the objects from the db with the
form I was trying to import
does the form import properly.
I've created several new dbs and have imported all the objects from a backup
several
time in the past 2 weeks just to try to eliminate corruption.
As far as corruption is concerned I printed out 'Preventing Corruption' from
Allen Browne's fine web site.
The only thing I might have here is if my computer is over heating without
my knowledge.
I have no other problems with any other software on my computer. My os Vista
Basic sp2 x32
seems to be running fine.
If it is corruption my db becomes corrupt ever few days or so.
Seems I can't breath on my db the wrong way.
Oh yes, I can admit I gave unplugged my power cord to the computer on
several occasions in the past year.

Any help or suggestions will be appreciated,
James

From: JamesJ on 5 Jun 2010 06:03
I've made a hard copy of 8 steps and when it happens again (and it will
happen again)
I'll follow the instructions.
Thing that bothers me is what's causing the frequent corruption.

James

"Allen Browne" <AllenBrowne(a)SeeSig.Invalid> wrote in message
news:uTqB6PFBLHA.1892(a)TK2MSFTNGP05.phx.gbl...
> Hi James
>
> There does appear to be some corruption in your database, so here's how I
> would approach it.
>
> Follow the 8 steps on this page to:
> http://allenbrowne.com/recover.html
>
> Now delete the form you plan to replace, and compact again.
>
> Then open the database that you plan to import from, and go through the
> first 7 steps in that one too.
>
> Now try the import. Because you cleaned up both files, and deleted and
> form and compacted it to get completely rid of it before importing it, the
> ghost form should be gone.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "JamesJ" <jjy(a)darwin_roadrunner.com> wrote in message
> news:uBbJn3$ALHA.6116(a)TK2MSFTNGP02.phx.gbl...
> Access 2007 sp2.
>
> I hope I explain this ok... Here goes.
>
> When I want to discard changes made to a form by importing a form form a
> backup
> the imported form takes on all the characteristics of the form I want to
> replace.
> As an example, lets say I remove a command button from Myform in my main
> db.
> I then import Myform from a backup knowing that this form still has the
> command button. When I open the imported formj (Myform1) it still has the
> command
> button and is identical to the form I'm trying to replace.
> Keep in mind this is only an example 'cause I wouldn't import a form just
> for one command button.
> Actually I made many changes to this form when I decided I didn't like it
> and decided to import from the backup.
> After importing the imported form was identical to the one I'm trying to
> replace.
> When I open the db with the form I want to import the form is fine. It
> seems to magically change
> to the one I want to replace after importing.
> I tried importing the form from a backup I did in February and the same
> thing happened.
> Doesn't matter, I could import a form from February 2007 and there would
> be the same results.
> In fact I imported the form from 5 other backup with the same results.
> I renamed to old form before importing and I deleted the form before
> importing with the same results.
>
> Access seems to see both the old form and the imported as the same even
> though they are different.
> Only if I create a new db and import all the objects from the db with the
> form I was trying to import
> does the form import properly.
> I've created several new dbs and have imported all the objects from a
> backup several
> time in the past 2 weeks just to try to eliminate corruption.
> As far as corruption is concerned I printed out 'Preventing Corruption'
> from Allen Browne's fine web site.
> The only thing I might have here is if my computer is over heating without
> my knowledge.
> I have no other problems with any other software on my computer. My os
> Vista Basic sp2 x32
> seems to be running fine.
> If it is corruption my db becomes corrupt ever few days or so.
> Seems I can't breath on my db the wrong way.
> Oh yes, I can admit I gave unplugged my power cord to the computer on
> several occasions in the past year.
>
> Any help or suggestions will be appreciated,
> James

 | 
Pages: 1
Prev: Tab Order
Next: Hide ribbon event not working