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

How to deal with a VBA-project that is damaged in Access2000

P: n/a
How to deal with a VBA-project that is damaged?

Hi everyone.
I am BigOlle from sweden and I have been working with Accees for ten
years
I am now working on a project that started in Access97 and since a few
months it continues in Access2000.

My plan is to use Access2000 as it is supposed that mdb-files in
Access 2000-format can be opened from all Access versions after that
one. (I hope it is so)
It all seemed to work very well until last week when my mdb-file could
not be opened on my computer.
(it was at the time about 60 mb. and not data only vb-code and
forms,reports and modules)

It showed that I had the wrong version of the Vbe6.dll file, so I
went on from that day on another Pc.

I went back to a copy of the database that semeed to be alright.
( I must tell that my mdb file is working on a linked mdb-file on the
same library on my computer and since one month ago
the data-mdb-file is passwordprotected.)

Now I make a backup of my mdb-file every half an hour as it regulary
happens that I get the error message:
"VBA-project is damaged"
I have tried:
1/ To convert my project till Access2002 and convert it back to
Access2000.
(It sometimes works but sometimes I even get this same error message
in Access2002:
("VBA-project is damaged")

2/ Decompile the project.

3/ Save form modules as text and import the text-modules to the mdb-
version that is not corrupt.

But all the same I regulary (some days many times a day) I get the
errormessage.
("VBA-project is damaged")
I have noticed that on decompile and converting get the message that
the form FrmMySeachform_070726_1 can't be loaded. And this is when I
am working in the form frmMySearchform. (I make backup-copies of the
forms that I am working on this way)

I hope that someone can give me an advice how I could go on with my
project
Regards BigOlle

Jul 27 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
When you saved your form modules as text, did you also save your other
modules as text, set the forms and reports HasModule property to No, then
copy the objects to a new, empty database, and then reload the modules from
text?

My guess would be that something is corrupted, and this additional step may
be helpful.

There's very good information on corruption, and on recovering from it, and
avoiding it at MVP Tony Toews' website,
http://www.granite.ab.ca/accsmstr.htm. It would be worth your reviewing.
And, you might take a look at the content at http://www.accessmvp.com/ where
MVP's Arvin Meyer, Doug Steele, and Jeff Conrad have contributed
information.

Larry Linson
Microsoft Access MVP
<ol**@ylm.sewrote in message
news:11*********************@19g2000hsx.googlegrou ps.com...
How to deal with a VBA-project that is damaged?

Hi everyone.
I am BigOlle from sweden and I have been working with Accees for ten
years
I am now working on a project that started in Access97 and since a few
months it continues in Access2000.

My plan is to use Access2000 as it is supposed that mdb-files in
Access 2000-format can be opened from all Access versions after that
one. (I hope it is so)
It all seemed to work very well until last week when my mdb-file could
not be opened on my computer.
(it was at the time about 60 mb. and not data only vb-code and
forms,reports and modules)

It showed that I had the wrong version of the Vbe6.dll file, so I
went on from that day on another Pc.

I went back to a copy of the database that semeed to be alright.
( I must tell that my mdb file is working on a linked mdb-file on the
same library on my computer and since one month ago
the data-mdb-file is passwordprotected.)

Now I make a backup of my mdb-file every half an hour as it regulary
happens that I get the error message:
"VBA-project is damaged"
I have tried:
1/ To convert my project till Access2002 and convert it back to
Access2000.
(It sometimes works but sometimes I even get this same error message
in Access2002:
("VBA-project is damaged")

2/ Decompile the project.

3/ Save form modules as text and import the text-modules to the mdb-
version that is not corrupt.

But all the same I regulary (some days many times a day) I get the
errormessage.
("VBA-project is damaged")
I have noticed that on decompile and converting get the message that
the form FrmMySeachform_070726_1 can't be loaded. And this is when I
am working in the form frmMySearchform. (I make backup-copies of the
forms that I am working on this way)

I hope that someone can give me an advice how I could go on with my
project
Regards BigOlle

Jul 27 '07 #2

P: n/a
hi Larry.
Thanks for your advice.
No, I haven't copied all moduls as text and imported them to a new
database.
It is so many forms and so many reports and so many modules in my
applikation so I haven' t done this yet.
Guess I will have to do it.
(but i Haven't get corruption for 6 days now)
Regards Olle
On Jul 27, 11:19 pm, "Larry Linson" <boun...@localhost.notwrote:
When you saved your form modules as text, did you also save your other
modules as text, set the forms and reports HasModule property to No, then
copy the objects to a new, empty database, and then reload the modules from
text?

My guess would be that something is corrupted, and this additional step may
be helpful.

There's very good information on corruption, and on recovering from it, and
avoiding it at MVP Tony Toews' website,http://www.granite.ab.ca/accsmstr.htm. It would be worth your reviewing.
And, you might take a look at the content athttp://www.accessmvp.com/where
MVP's Arvin Meyer, Doug Steele, and Jeff Conrad have contributed
information.

Larry Linson
Microsoft Access MVP

<o...@ylm.sewrote in message

news:11*********************@19g2000hsx.googlegrou ps.com...
How to deal with a VBA-project that is damaged?
Hi everyone.
I am BigOlle from sweden and I have been working with Accees for ten
years
I am now working on a project that started in Access97 and since a few
months it continues in Access2000.
My plan is to use Access2000 as it is supposed that mdb-files in
Access 2000-format can be opened from all Access versions after that
one. (I hope it is so)
It all seemed to work very well until last week when my mdb-file could
not be opened on my computer.
(it was at the time about 60 mb. and not data only vb-code and
forms,reports and modules)
It showed that I had the wrong version of the Vbe6.dll file, so I
went on from that day on another Pc.
I went back to a copy of the database that semeed to be alright.
( I must tell that my mdb file is working on a linked mdb-file on the
same library on my computer and since one month ago
the data-mdb-file is passwordprotected.)
Now I make a backup of my mdb-file every half an hour as it regulary
happens that I get the error message:
"VBA-project is damaged"
I have tried:
1/ To convert my project till Access2002 and convert it back to
Access2000.
(It sometimes works but sometimes I even get this same error message
in Access2002:
("VBA-project is damaged")
2/ Decompile the project.
3/ Save form modules as text and import the text-modules to the mdb-
version that is not corrupt.
But all the same I regulary (some days many times a day) I get the
errormessage.
("VBA-project is damaged")
I have noticed that on decompile and converting get the message that
the form FrmMySeachform_070726_1 can't be loaded. And this is when I
am working in the form frmMySearchform. (I make backup-copies of the
forms that I am working on this way)
I hope that someone can give me an advice how I could go on with my
project
Regards BigOlle- Hide quoted text -

- Show quoted text -

Jul 31 '07 #3

P: n/a
Hi Again Larry.
Now I have I new question:
About 10 days ago I had a corrupt database (mdb-file).
And I got corruption, error messages even afte importing
a form without module. I wonder if you think that that is possible,
I think that it was a form that was a copy of another form.
That was form FrmMySeachform_070726_1 . I was working in the form
frmMySearchform. (I make backup-copies of the forms that I am working
on this way)
What do you think?
/regards Olle

When you saved your form modules as text, did you also save your other
modules as text, set the forms and reports HasModule property to No, then
copy the objects to a new, empty database, and then reload the modules from
text?
My guess would be that something is corrupted, and this additional step may
be helpful.
There's very good information on corruption, and on recovering from it, and
avoiding it at MVP Tony Toews' website,http://www.granite.ab.ca/accsmstr.htm. It would be worth your reviewing.
And, you might take a look at the content athttp://www.accessmvp.com/where
MVP's Arvin Meyer, Doug Steele, and Jeff Conrad have contributed
information.
Larry Linson
Microsoft Access MVP
<o...@ylm.sewrote in message
news:11*********************@19g2000hsx.googlegrou ps.com...
How to deal with a VBA-project that is damaged?
Hi everyone.
I am BigOlle from sweden and I have been working with Accees for ten
years
I am now working on a project that started in Access97 and since a few
months it continues in Access2000.
My plan is to use Access2000 as it is supposed that mdb-files in
Access 2000-format can be opened from all Access versions after that
one. (I hope it is so)
It all seemed to work very well until last week when my mdb-file could
not be opened on my computer.
(it was at the time about 60 mb. and not data only vb-code and
forms,reports and modules)
It showed that I had the wrong version of the Vbe6.dll file, so I
went on from that day on another Pc.
I went back to a copy of the database that semeed to be alright.
( I must tell that my mdb file is working on a linked mdb-file on the
same library on my computer and since one month ago
the data-mdb-file is passwordprotected.)
Now I make a backup of my mdb-file every half an hour as it regulary
happens that I get the error message:
"VBA-project is damaged"
I have tried:
1/ To convert my project till Access2002 and convert it back to
Access2000.
(It sometimes works but sometimes I even get this same error message
in Access2002:
("VBA-project is damaged")
2/ Decompile the project.
3/ Save form modules as text and import the text-modules to the mdb-
version that is not corrupt.
But all the same I regulary (some days many times a day) I get the
errormessage.
("VBA-project is damaged")
>
I have noticed that on decompile and converting get the message that
the form FrmMySeachform_070726_1 can't be loaded. And this is when I
am working in the form frmMySearchform. (I make backup-copies of the
forms that I am working on this way)
I hope that someone can give me an advice how I could go on with my
project
Regards BigOlle- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

Jul 31 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.