473,842 Members | 1,370 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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 passwordprotect ed.)

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
3 1793
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.sewro te in message
news:11******** *************@1 9g2000hsx.googl egroups.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 passwordprotect ed.)

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
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...@localh ost.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.c om/where
MVP's Arvin Meyer, Doug Steele, and Jeff Conrad have contributed
information.

Larry Linson
Microsoft Access MVP

<o...@ylm.sewro te in message

news:11******** *************@1 9g2000hsx.googl egroups.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 passwordprotect ed.)
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
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.c om/where
MVP's Arvin Meyer, Doug Steele, and Jeff Conrad have contributed
information.
Larry Linson
Microsoft Access MVP
<o...@ylm.sewro te in message
news:11******** *************@1 9g2000hsx.googl egroups.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 passwordprotect ed.)
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2070
by: andreas | last post by:
Hi there, I have the following situation: 1. DOT.NET Application is started 2. DOT.NET Application instantiates Access.Application.8 3. Opens a specified database (MDB) 4. DOT.NET application sets a global variable in the access application to itself (type object) 5. Runs a macro
3
1766
by: DKJ | last post by:
Is VBA wholly and completely a subset of VB.net? Are there any objects or methods or coding techniques that one could learn in VBA that wouldn't also apply in VB.net? So if I will have learned VB.net, by definition, I will have learned VBA?
41
3104
by: Matt Alanzo | last post by:
Our SOHO 2 person compay sells furniture (not programmers). In '98 we paid $,$$$ for a VBA -Access '97 accounting application, including VBA source code .... an huge investment for us then (and now!). The application publisher went belly up years ago. Over time we've made a number of VBA code changes (< 500 lines total). Now our CPA is urging us to switch to Quickbooks Premier for Contractors at a cost of $,$$$ plus data entry. Argh, no...
6
3674
by: Terry Bell | last post by:
We've had a very large A97 app running fine for the last seven years. I've just converted to SQL Server backend, which is being tested, but meanwhile the JET based version, running under terminal server, has suddenly started running very slowly. The network engineer has thrown up his hands and said "It's Access 97". I've checked out lots of things including the Oplocks setting and other stuff from this NG, and I think I've done everything...
6
5523
by: Ieuan | last post by:
Hello all and Happy New Year, I've been having this problem for some time and thought I'd try to see if anyone else out there has had the same problem or can give a little help. I'm using a website written in C# to call a .dll which in turn returns a load of information. Most of this information is readable. However, some of the information returned is of type VBA.CollectionClass.
18
2408
by: Ann Scharpf via AccessMonster.com | last post by:
I am not sure which would be the best place to post this question, so I'm posing it here with Access general questions. I have reached the point many times in Word and in Access where my ignorance of VBA is a real detriment to me. I saw some posts about VBA classes with a particular vendor and the poster was advised not to take the class because of the likelihood of an unskilled trainer. My question is, would taking a Visual Basic...
16
1724
by: Sathyaish | last post by:
I am expecting a VBA code module in one of the VBA apps, but much to my astonishment, I don't seem to find my way through it. It seems like I am looking at a fully compiled binary. I have an MDB (Microsoft Access 2000) file that I am guessing is a compiled binary written in Visual Basic for Applications (VBA). I've done a fairly decent amount of VBA myself but mostly in the Excel, Word and Power Point environments. This is the first...
19
1477
by: DesCF | last post by:
What are the differences between vb, vb.net, & vba ? -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
7
3721
by: fcolon75 | last post by:
I'm an experienced Access user, but very new to coding VBA in Access. I'd like to do the following: 1) Develop a basic query in the query designer. 2) Call that query from a VBA script 3) Manipulate the data from the results set in the VBA script (i.e. read data from fields into variables, etc.) This conceptually seems like it should be an easy thing to do. However, I'm finding it difficult to find articles or postings on the subject.
3
20668
MMcCarthy
by: MMcCarthy | last post by:
Although some users find Macros simple and easy to use, there are some major limitations to using them. Although you can use macros to perform tasks, there is limited control on when and how those tasks should be performed, and setting conditions can be difficult. There is however, another even stronger reason not to use macros and that is that when errors are thrown during a macro's execution it is difficult to trap the error and therefore...
0
9876
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9717
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10952
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10618
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10320
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7045
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5699
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5887
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4506
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.