473,320 Members | 2,000 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

The Visual Basic for Applications Project in the database is corrupt

Can anyone please help?
I have read the postings on the error "The Visual Basic for
Applications Project in the database is corrupt" but none report the
particular problem I am experiencing, i.e., this error only occurs
running my program on computers of some of my clients.

To elaborate: I have a program that is being used by around 60 clients
all over the world. My program is an mde file in Access2003. It works
absolutely without hitch on the 5 computers in our office (running
Windows XP), and on all but 3 of my clients. The program is
"free-standing", i.e., not running via a network/server. However the
same program installed on 3 of my clients' computers results in this
error when they start the program. They have reinstalled the program,
I have sent them a new installation, (following decompiling and
recompiling the program) but to no avail. The same installation
package installed on my systems, and on a new laptop, runs perfectly
correctly.
Any ideas?
Thanks
Harris
Nov 13 '05 #1
4 10456
Is it possible that these clients are running Access 2002?

Although A20002 and 2003 use the same file format, they compile the code
differently, and you do get that (not very helpful) error message if you
create an MDE in A2003 and try to run it under A2002.

If that's not the issue, is this a runtime installation? If so, you may need
to release different runtimes for different operating systems, e.g. one for
Windows 98 machines (created on a Win98 installation) and a different one
for Win XP machines (created under Win XP).

It would also be worth checking that the clients have applied the service
packs to their version of Office and to JET 4, including the runtime service
pack that's named something like ART...

--
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.

"Harris" <ha****@zingsolutions.com> wrote in message
news:6a*************************@posting.google.co m...
Can anyone please help?
I have read the postings on the error "The Visual Basic for
Applications Project in the database is corrupt" but none report the
particular problem I am experiencing, i.e., this error only occurs
running my program on computers of some of my clients.

To elaborate: I have a program that is being used by around 60 clients
all over the world. My program is an mde file in Access2003. It works
absolutely without hitch on the 5 computers in our office (running
Windows XP), and on all but 3 of my clients. The program is
"free-standing", i.e., not running via a network/server. However the
same program installed on 3 of my clients' computers results in this
error when they start the program. They have reinstalled the program,
I have sent them a new installation, (following decompiling and
recompiling the program) but to no avail. The same installation
package installed on my systems, and on a new laptop, runs perfectly
correctly.
Any ideas?
Thanks
Harris

Nov 13 '05 #2
> Is it possible that these clients are running Access 2002?

Although A20002 and 2003 use the same file format, they compile the code
differently, and you do get that (not very helpful) error message if you
create an MDE in A2003 and try to run it under A2002.

If that's not the issue, is this a runtime installation? If so, you may need
to release different runtimes for different operating systems, e.g. one for
Windows 98 machines (created on a Win98 installation) and a different one
for Win XP machines (created under Win XP).

It would also be worth checking that the clients have applied the service
packs to their version of Office and to JET 4, including the runtime service
pack that's named something like ART...


This is a good suggestion but according to my clients they are running
2003. I need to double check. It is not a runtime installation -
however I do supply a 2003 runtime module that can be installed if
they do not have Access installed. I need to follow up on whether they
have installed the service packs and to Jet4, but I do know that I had
asked 1 client to do so, and the error persists. Thanks for
highlighting these issues.
Harris
Nov 13 '05 #3
What we do is include a couple of text boxes on our HelpAbout form, with
test boxes like:
=fGetProductVersion(SysCmd(9) & "msaccess.exe")
=fGetProductVersion(fReturnSysDir() & "\msjet40.dll")

When the user calls you for support, they can then give you the information
to confirm their version and service pack of Office and JET 4.

The functions are from:
http://www.mvps.org/access/api/api0065.htm
http://www.mvps.org/access/api/api0010.htm

--
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.

"Harris" <ha****@zingsolutions.com> wrote in message
news:6a**************************@posting.google.c om...
Is it possible that these clients are running Access 2002?

Although A20002 and 2003 use the same file format, they compile the code
differently, and you do get that (not very helpful) error message if you
create an MDE in A2003 and try to run it under A2002.

If that's not the issue, is this a runtime installation? If so, you may
need
to release different runtimes for different operating systems, e.g. one
for
Windows 98 machines (created on a Win98 installation) and a different one
for Win XP machines (created under Win XP).

It would also be worth checking that the clients have applied the service
packs to their version of Office and to JET 4, including the runtime
service
pack that's named something like ART...


This is a good suggestion but according to my clients they are running
2003. I need to double check. It is not a runtime installation -
however I do supply a 2003 runtime module that can be installed if
they do not have Access installed. I need to follow up on whether they
have installed the service packs and to Jet4, but I do know that I had
asked 1 client to do so, and the error persists. Thanks for
highlighting these issues.
Harris

Nov 13 '05 #4
Allen,

Thanks very much for your input, it was also very valuable. I sent a
small app to my client to check these details, and found that she was
running AccessXP without any service pack installations- I think this
is crucial information as I can now ask her to install the service
packs and retry the software. Thanks a ton for all the input to both
of you!
Harris
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: angelag | last post by:
I am currently taking a college course in Visual Basic.Net and I am a beginner. I bought Visual Studio.Net 2003 to do my homework at home. I built my first project and e-mailed it to myself at...
5
by: K. Shier | last post by:
when attempting to edit code in a class file, i see the bug "Visual Basic ..NET compiler is unable to recover from the following error: System Error &Hc0000005&(Visual Basic internal compiler...
63
by: Jerome | last post by:
Hi, I'm a bit confused ... when would I rather write an database application using MS Access and Visual Basic and when (and why) would I rather write it using Visual Studio .Net? Is it as easy...
12
by: Nick Stansbury | last post by:
Hi, Access 2003. Running over terminal server on a Windows Server 2003 box. The error occurs on every machine that I've tried copying the file to. Latest Jet SP & Office SP. Database hasn't been...
54
by: m.roello | last post by:
In the book: "Working with Microsoft Visual Studio 2005" Craig Skibo wrote: "The power of Visual Studio 2005 lies in its ability to empower users to build, test, and debug powerful applications...
10
by: Steve | last post by:
I am trying to create a DLL in Visual Studio 2005-Visual Basic that contains custom functions. I believe I need to use COM interop to allow VBA code in Excel 2002 to access it. I've studied...
1
by: FlyingBuckner | last post by:
All right be kind, this is my first question on a forum. I need help on selecting the right software to purchase. I have a database set up using Access, 6 users. It is split into Tables and...
4
by: Chris Asaipillai | last post by:
Hi there My compay has a number of Visual Basic 6 applications which are front endeed onto either SQL Server or Microsoft Access databases. Now we are in process of planning to re-write these...
8
by: Chris Asaipillai | last post by:
Hi there I have some questions for those experienced Visual Basic 6 programmers out there who have made the transition from VB6 to Vb.net. How long did it take you to learn at least the basic...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.