Help - AccessXP database error - Microsoft Access / VBA

bobh

Hi All,

In AccessXP I was running a query when I got the following error

"The Visual Basic For Applications Project in the Database is corrupt"

I have been developing this datbase applications for two months and I
really can not afford
loss it at this point. Can this be fixed????
I tried creating an empty db and importing the objects but I get the
same message
I can get to database window in it but I get the same message when I
try to export the
objects.
I get the same message when I try to compact/repair it as well.
I am in very deep sneakers.... I need to get this back to a usable
state, help!

Jan 23 '07 #1

Subscribe Reply

1150

salad

bobh wrote:

Hi All,

In AccessXP I was running a query when I got the following error

"The Visual Basic For Applications Project in the Database is corrupt"

I have been developing this datbase applications for two months and I
really can not afford
loss it at this point. Can this be fixed????
I tried creating an empty db and importing the objects but I get the
same message
I can get to database window in it but I get the same message when I
try to export the
objects.
I get the same message when I try to compact/repair it as well.
I am in very deep sneakers.... I need to get this back to a usable
state, help!

I went to Google Groups/Advanced Search and searched for
The Visual Basic For Applications Project

Lots of hits. Here's one response David Fenton made.

"The problem appears to be the versions of Access and Jet. In the
unpatched version of Access 2000 (no service packs applied) with
Jet versions that have not been updated to SP6, we see CORRUPT VBA
PROJECT when we try to decompile, and a complete crash whenever we
try to open the code for any form.

However, in Access SR1 or later with SP6 applied, there is no
problem."

Jan 24 '07 #2

Similar topics

1569

Forms errors for DB created in Chinese version AccessXP/WinXP running in english version AccessXP/WinXP

by: Bill | last post by:

I created a very simple DB with several forms and tables in chinese version of Access XP running in Chinese Win XP. Now I try to run the same DB in English version of Access XP running in English Win XP. The DB opens just find excpet all buttons or event on froms I click or do it gives me the following error. ______________ The expression On Click you entered as the event property setting produced the following error: A problem...

Microsoft Access / VBA

1527

AccessXP/Access2003

by: Dennis | last post by:

If I create a database in AccessXP-2000mode, can someone with Access2003 run it? Do either of us have to do anything special? Thanks! Dennis

Microsoft Access / VBA

2264

DoCmd.OutputTo Help...

by: Ima Lostsoul | last post by:

I have an application that is being used in both the retail and run time Access (XP). One feature is that reports can be exported to SnapShot files. I have a custom menu for the reports and VB code creates the snap shot via the menu for the current report. This works just fine. Now I also have a button on my report menu that will generate a snapshot for a complete set of reports. All that is prompted for is a directory to create the...

Microsoft Access / VBA

1323

Access97 RTF vs AccessXP RTF output

by: Bob Hynes | last post by:

Hi All, In one of my Access97 db applications I created a report which I output to a RichTextFormat file attach it to an Email and send it out, that has worked just fine for a couple of years now. My company is in the midst of migrating to AccessXP. I loaded my Access97 application in AccessXP and converted it. The user who generates the report now has AccessXP and when she runs the process the format of the outputted RTF is messed up;...

Microsoft Access / VBA

2690

AccessXP Startup switch /ro

by: bobh | last post by:

Hi All, In the desktop shortcut I added the /ro switch to the command line \\Homf6\Vol2\LifeComp\ComonDbs\AVA\Apps\AvaXP.mdb /ro and the db opens but I can still change data that is displayed on a form. So, what am I missing?? If the "/ro" switch is suppose to open the db as read-only then why is it letting me change data thru a opened form.

Microsoft Access / VBA

1249

Help with Error

by: bobh | last post by:

Hi All, In an AccessXP application I have a vba process which creates a document on the users 'c' drive and then opens and attaches that document to the users mail client which in this case is Groupwise. This process works fine for all users except one, the one user gets the following error message; "Error 2147221934 was Returned" in a pop-up box within Access. I've looked and tested all over and can

Microsoft Access / VBA

2851

Help with Mapi emailing

by: bobh | last post by:

Hi All, I've been using this function which I got from here for some time now in two of my AccessXP multiusers applications and it has worked without issue until lately it has stopped functioning on several user pc's and I don't know why. I've asked our PC Services group what they changed on the pc's that this does not work on and they say 'nothing'. Well something has changed cause this did work at one time. When I step thru it in...

Microsoft Access / VBA

3519

AccessXP/Groupwise fix

by: bobh | last post by:

Hi All, Below is a function I want to use in AccessXP, it works as is but as the comment says I need to manually open Tools - References and check off 'Groupware Type Library' and I'm hoping someone here can show me some sample code so I do not have to do that manually. If I run this without that library checked off I get this error message 'Compile Error - User Defined Type Not Defined' thanks bobh.

Microsoft Access / VBA

2135

AccessXP file size limit question

by: bobh | last post by:

HI, I understand AccessXP file size has a 2 gig limit but I trying to understand the following I have a tab delimited data file that is 1.3 gigs big and I try to import it into an empty AccessXP database and it starts to import then stops, I look at the database size and it shows 1.99 gigs. AccessXP blots to almost twice the size of the import file??? is that

Microsoft Access / VBA

8413

What is ONU?

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

General

8324

Changing the language in Windows 10

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

Windows Server

8842

Problem With Comparison Operator <=> in G++

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

C / C++

8740

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

6176

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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

Microsoft Access / VBA

4173

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

4330

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2742

transfer the data from one system to another through ip address

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

C# / C Sharp

1970

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP