Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / July 2007

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
olle@ylm.se - 27 Jul 2007 07:31 GMT
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
Larry Linson - 27 Jul 2007 22:19 GMT
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

> How to deal with a VBA-project that is damaged?
>
[quoted text clipped - 50 lines]
>
> Regards BigOlle
olle@ylm.se - 31 Jul 2007 07:20 GMT
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

> 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
[quoted text clipped - 73 lines]
>
> - Show quoted text -
olle@ylm.se - 31 Jul 2007 07:29 GMT
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
[quoted text clipped - 61 lines]
> > > 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
[quoted text clipped - 9 lines]
>
> - Show quoted text -
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.