Hi all!
This has happened to two different databases to me in two days.
A query which has been working flawlessly for over 9 months suddenly won't
run because the "ISNULL" function is undefined.
Compact and Repair - no problems. JetComp utility - no problems.
Then I try to edit a module, and the VB editor won't let me make any
changes. The error is something about the network connection being lost.
Which I could maybe understand for the first instance. But in the second,
the database is a local instance.
So I remove the ISNULL function from the query, and then it says that a User
Defined Function is missing, a UDF that is definitely in te modules list.
But no editing is possible. So I close the database, and then open it, and
the Module has disappeared from the Modules view, but is available in the VB
editor view, but not editable.
Again JetComp reports no problems.
The only resolution was a restore from a backup.
I am open to any and all suggestions.
cheers,
Matt. 5 2079
Matt,
On Tue, 23 Sep 2003 13:10:22 -0400, "Matt."
<ma************ *******@hotmail .com> wrote in comp.databases. ms-access: A query which has been working flawlessly for over 9 months suddenly won't run because the "ISNULL" function is undefined.
Compact and Repair - no problems. JetComp utility - no problems.
Then I try to edit a module, and the VB editor won't let me make any changes. The error is something about the network connection being lost. Which I could maybe understand for the first instance. But in the second, the database is a local instance.
So I remove the ISNULL function from the query, and then it says that a User Defined Function is missing, a UDF that is definitely in te modules list. But no editing is possible. So I close the database, and then open it, and the Module has disappeared from the Modules view, but is available in the VB editor view, but not editable.
Again JetComp reports no problems.
The only resolution was a restore from a backup.
I am open to any and all suggestions.
The problem derives from incompatible versions of the vbe.dll file.
Check the msft kb for an article on this. Basically, if the dll
problem exists, and you import an object with code (for, report or
module) into an mdb, then close the mdb without first compiling it,
the code gets corrupted. You will get a network connection lost error
message, but it has nothing to do with a network or whether the file
is local or remote. The problem is that the code gets mangled. You
can't get to it from the Access interface, but it will still appear
within the vba environment (using, for example, the object browser).
However, you still will not be able to access the code.
There is no easy solution to code retrieval in such circumstances, but
the problem can be immediately prevented by ensuring you always
compact after importing objects that have code, and can be permanently
prevented by applying the appropriate updates. Again, the kb article
will help here.
HTH,
Peter Miller
_______________ _______________ _______________ _______________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results www.pksolutions.com 1.800.987.7716 1.619.839.3900
Thanks Peter!
I'm trying to find that article, but am not having much luck. If you still
have a link, I'd be much obliged.
I'm assuming that I can't just swap out DLL files. Is this going to be an
MDAC installation?
cheers,
Matt.
"Peter Miller" <pm*****@pksolu tions.com> wrote in message
news:i0******** *************** *********@4ax.c om... Matt,
On Tue, 23 Sep 2003 13:10:22 -0400, "Matt." <ma************ *******@hotmail .com> wrote in comp.databases. ms-access:
A query which has been working flawlessly for over 9 months suddenly
won'trun because the "ISNULL" function is undefined.
Compact and Repair - no problems. JetComp utility - no problems.
Then I try to edit a module, and the VB editor won't let me make any changes. The error is something about the network connection being lost. Which I could maybe understand for the first instance. But in the
second,the database is a local instance.
So I remove the ISNULL function from the query, and then it says that a
UserDefined Function is missing, a UDF that is definitely in te modules list. But no editing is possible. So I close the database, and then open it,
andthe Module has disappeared from the Modules view, but is available in the
VBeditor view, but not editable.
Again JetComp reports no problems.
The only resolution was a restore from a backup.
I am open to any and all suggestions.
The problem derives from incompatible versions of the vbe.dll file. Check the msft kb for an article on this. Basically, if the dll problem exists, and you import an object with code (for, report or module) into an mdb, then close the mdb without first compiling it, the code gets corrupted. You will get a network connection lost error message, but it has nothing to do with a network or whether the file is local or remote. The problem is that the code gets mangled. You can't get to it from the Access interface, but it will still appear within the vba environment (using, for example, the object browser). However, you still will not be able to access the code.
There is no easy solution to code retrieval in such circumstances, but the problem can be immediately prevented by ensuring you always compact after importing objects that have code, and can be permanently prevented by applying the appropriate updates. Again, the kb article will help here.
HTH,
Peter Miller _______________ _______________ _______________ _______________ PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL Free quotes, Guaranteed lowest prices and best results www.pksolutions.com 1.800.987.7716 1.619.839.3900
Matt,
On Tue, 23 Sep 2003 14:18:03 -0400, "Matt."
<ma************ *******@hotmail .com> wrote in comp.databases. ms-access: I'm trying to find that article, but am not having much luck. If you still have a link, I'd be much obliged.
See http://support.microsoft.com/default...b;en-us;304548
I'm assuming that I can't just swap out DLL files.
Debatable.
Is this going to be an MDAC installation?
No. An Office service pack update.
Peter Miller
_______________ _______________ _______________ _______________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results www.pksolutions.com 1.800.987.7716 1.619.839.3900
Paii,
On Tue, 23 Sep 2003 14:37:56 -0500, "paii" <pa**@packairin c.com> wrote
in comp.databases. ms-access: A record in a table you were querying may be corrupted. There are some corruptions that repair will not find. I have had this happen to me 2 or 3 times, each time it was a memo field. Repair did not fix the table. Scroll down the table view looking for "ERROR" in a field. Do NOT enter the error record. If this is the problem, create a new table and use a query to copy the good records to this new table. You can then recreate the corrupted record, rename and recreate any references to the new table.
All fine advice in general, but not relevant to the corruption
scenario Matt outlined. His corruption is code-related - not
data-related.
Peter Miller
_______________ _______________ _______________ _______________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results www.pksolutions.com 1.800.987.7716 1.619.839.3900
Thanks again Peter,
The article describes exactly the problem.
cheers,
Matt.
"Peter Miller" <pm*****@pksolu tions.com> wrote in message
news:8n******** *************** *********@4ax.c om... Matt,
On Tue, 23 Sep 2003 14:18:03 -0400, "Matt." <ma************ *******@hotmail .com> wrote in comp.databases. ms-access:
I'm trying to find that article, but am not having much luck. If you
stillhave a link, I'd be much obliged.
See http://support.microsoft.com/default...b;en-us;304548
I'm assuming that I can't just swap out DLL files.
Debatable.
Is this going to be an MDAC installation?
No. An Office service pack update. Peter Miller _______________ _______________ _______________ _______________ PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL Free quotes, Guaranteed lowest prices and best results www.pksolutions.com 1.800.987.7716 1.619.839.3900 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: PamelaDV |
last post by:
I have a database split for back end and front end and my back end (my
data) has been corrupting like crazy lately. Today we have compacted
and repaired like 4 times within an hour. The database is not
experiencing a lot of bloat. We have had instances in the past where
the database has gotten up to 200,00KB before indicating it needed to
be compacted and repaired. After C&R it is usually at 31,700 KB.
Lately when it gets to about...
|
by: Noesis Strategy |
last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles.
Recently, I have begun to design Access databases using an copy of Access
2002 from my previous laptop. It works fine, but I would like to have all
the office apps on the same version. So I have a few questions:
1) Is the file format the same as 2002? Can 2002 users read 2003 files?
2) What are the major reasons for upgrading to 2002 ?
|
by: heather e blair |
last post by:
We have an Access 2002 database of about 35 M with about 7 users. The data
lives on the server (Windows 2000 server), while the queries, forms, reports,
etc. live in a file that is on each person's C drive. There is also a
workgroup file to set the permissions for various groups.
Everybody is running Windows 2000 on their local computer.
People start using the database about 7:30 or 8 in the morning, and then
around noon, one by one...
|
by: Neil Ginsberg |
last post by:
I have a client who is using Access 2002/2000 (the database itself is
written in 2000), and is considering migrating to Access 2003. Any
recommendations on whether Access 2003 is worth the migrate, or should he
stick with 2002?
Thanks!
Neil
|
by: Rob Geraghty |
last post by:
I've just spent some time looking through FAQ sites and searching the
google archives of this newsgroup, but I still haven't been able to
find a clear explanation of an issue with multi-user databases.
Essentially I have two questions;
1) Does the system.mdw file have any significance to multi-user
sharing of an Access 97 database other than security?
2) Can any number of users open an Access 97 database using the same
| |
by: stu |
last post by:
I have several databases that are opened using various versions of
Access and VB. Up till recently everything worked fine, then I started
getting a variety of lock file error messages, both on my PC and other
computers (both Win2k and WinXP).
After a lot of testing I found that if the database was opened by
Access 2.0 (or a VB3 16 bit application), and then subsequently a
Access 2000 (or VB6 32 bit application) opened the database, then...
|
by: Lauren Wilson |
last post by:
Ok I have searched the MS website for info on this. I am totally
confused.
If I want to deploy an Access 2003 app and allow my users to run it
using Access 2003 Runtime, where do I get the Runtime?
I just purchased Office 2003 Professional. Is Access 2003 Runtime
included with that or not?
It APPEARS that the only way I can get Access 2003 Runtime is to
|
by: ship |
last post by:
Hi
We need some advice: We are thinking of upgrading our Access database
from Access 2000 to Access 2004.
How stable is MS Office 2003? (particularly Access 2003).
We are just a small company and this is a big decision for us(!) It's
not just the money it's committing to an new version of Access!
|
by: Bizmark |
last post by:
Access2003,
Windows XP Pro OEM user OS,
Windows Sever 2000 server OS.
Not-so-recently I inherited 3 Access DB's from another company merging with our own. Our own system works off of SQL server, but mainting these databases is critical to keeping the business running. 1 database in particular has been causing problems. Along the course we have had a few problems with random records corrupting (new and old) and Values within fields...
|
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: 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...
|
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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |