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 4 10517
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****@zingsol utions.com> wrote in message
news:6a******** *************** **@posting.goog le.com... 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
> 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
What we do is include a couple of text boxes on our HelpAbout form, with
test boxes like:
=fGetProductVer sion(SysCmd(9) & "msaccess.e xe")
=fGetProductVer sion(fReturnSys Dir() & "\msjet40.d ll")
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****@zingsol utions.com> wrote in message
news:6a******** *************** ***@posting.goo gle.com... 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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 school. When I tried to
open it in the lab, I got a message saying I couldn't open it because
it was created with a newer version. Evidently the lab is using Visual
Studio.Net 2002.
My professor doesn't just want the executable file, he wants...
|
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 error) Save your work and restart
Visual Studio .NET."
has anyone seen this bug and can you confirm one way or the other whether or
not it can corrupt your source files? (by 'corrupt' i mean: do anything to
it that will cause it to fail to load and...
|
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 in Visual Studio to create reports and labels as it's in
Access?`
The advantage of VS.net is that not every user needs Access, right? And
that would eliminate the Access version problem as well I guess.
|
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 converted. A mixture of
modules, forms, linking tables & temp. tables at the access end.
Exporting to a new database doesn't work (same error). Importing from a
new database doesn't work (same error). Trying to open any form or module in
code view...
|
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 quickly and easly."
I don't agree on what concernes ASP .NET Web Sites in VS2005.
All what involves Namespaces in Web sites has been disappeared. I know
you can still MANUALLY manage them, but not QUICKLY and EASLY. In a
| |
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 everything I can find on COM Interop
and .NET. I've also tried many of the 'Walkthroughs' on the MSDN site
relating to COM add-ins, .NET and Office XP but am unable to get even these
working in Excel 2002 or Word 2002.
I've installed the Office XP...
|
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 Applications, no more then 65MB of data in the tables right now.
I have 2 college courses in Visual Basic 6 and have written VBA code in Access and AutoCad. I work for a steel fabricator and the database is written to track material usage, purchase...
|
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 applications into Visual Basic.Net.
My managers main thought is that Visual Basic 6 is (or has!) stopped being supported
by Microsoft.
|
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 elements of
VB.net....so that
you were confident to write a application from scratch. This wouldnt
necessarily
|
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...
|
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...
| |
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |