Any help appreciated with this problem --
I have a Microsoft Access 2002 application. The Access
mdb has a refence to DAO 3.6 (not ADO). A form is bound to
a linked table in a second mdb. In the AfterUpdate event
method of a text box, after a SaveRecord, a method is called which is
in a
GlobalMultiuse class in an ActiveX code component that I
compiled in VB6. In this method, a DAO recordset is
opened on the same record in the same database table that
the form is linked to, and then, some
fields of the record are modified with rs.Edit / rs.Update, and
then the recordset is set = Nothing. These
modified fields are also shown on the Access form.
I have tried this technique on a small test app, and all
works fine: the changes appear on the Access form.
However, in my app, the AfterUpdate results in:
"Microsoft Access has encountered a problem and needs to
close. We are sorry for the inconvenience."
Clicking a button brings up s screen that says ModName =
dao3600.dll.
I have seen this message in other Access apps, but
usually I can compact & repair or import all objects into
a new MDB and that fixes it. Here though it happens every
time.
Any ideas how to proceed??? 2 3080
Access and the Jet engine are both fully up to date with service packs? If
you're using the db on multiple machines then ensure that that's true for
all of them.
"bo**@4bcx. com" <bc******@ix.ne tcom.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. . Any help appreciated with this problem --
I have a Microsoft Access 2002 application. The Access mdb has a refence to DAO 3.6 (not ADO). A form is bound to a linked table in a second mdb. In the AfterUpdate event method of a text box, after a SaveRecord, a method is called which is in a GlobalMultiuse class in an ActiveX code component that I compiled in VB6. In this method, a DAO recordset is opened on the same record in the same database table that the form is linked to, and then, some fields of the record are modified with rs.Edit / rs.Update, and then the recordset is set = Nothing. These modified fields are also shown on the Access form.
I have tried this technique on a small test app, and all works fine: the changes appear on the Access form.
However, in my app, the AfterUpdate results in: "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience."
Clicking a button brings up s screen that says ModName = dao3600.dll.
I have seen this message in other Access apps, but usually I can compact & repair or import all objects into a new MDB and that fixes it. Here though it happens every time.
Any ideas how to proceed???
MDB is crap
DAO is crap
Sqeak SQL or pass it to someone who does
MDB isn't reliable enough for a single user and a single record This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ray |
last post by:
Date problem.
Using non American date formats with Microsoft Access and Visual Basic.
I set my regional settings to English(Ireland) or English(United Kingdom)
and my date appears in Access as DD/MM/YYYY.
However if the day is less than 12 the day then becomes the month
e.g. 3 July 2003 is displayed in Visual Basic as 7 March 2003.
So if...
|
by: Ryan Strauss |
last post by:
I was wondering if someone could help me out with this
exception I'm encountering on a few of our C# reports. The
issue occurs sporadically and only to certain users,
myself not included. Whenever someone runs into the
problem, all I have to do is load the report and the issue
magically goes away for everyone that couldn't access it.
I...
|
by: Yannick Turgeon |
last post by:
Hello,
We are in the process of examining our current main application. We have to
do some major changes and, in the process, are questionning/validating the
use of MS Access as front-end. The application is relatively big: around 200
tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data
(SQL Server 2000), 40 users.
...
|
by: Bob Darlington |
last post by:
I have been getting the above error message intermittently when I open any
one of five or six forms in design view, change some control formatting
(like backcolor) and try to open the form in form view.
The application is closed down, and when I reopen it, all changes have been
saved, and all appears well.
It makes no difference if I select...
|
by: Randy Harris |
last post by:
I've run into a nasty problem, can't find a way around it.
This line of code:
DoCmd.OutputTo acOutputTable, "GSQ_Criteria", acFormatXLS, FileName
errors with
#2385 - Errors were encountered during the save operation.
| |
by: sticks |
last post by:
I hope someone can help with this strange problem I've encountered:
I have an Access interface that is used to access a SQL database. The
interface uses some stored procedures to display information from the
DB. If I edit the underlying tables of the SQL DB using the ALTER
TABLE statement, I encounter a problem where the Access interface...
|
by: PJ6 |
last post by:
Pages were working fine that used Microsoft.ApplicationBlocks.Data.dll, and
now, with no changes, we're getting this -
Access is denied: 'Microsoft.ApplicationBlocks.Data'.
All I can find with Google is that indexing service and antivirus software
can cause this (which would be consistant, perhaps, with a deplayed
failure). But on this...
|
by: Saher |
last post by:
Hi, im new on this forum and just joined today. I HAVE A HUGE PROBLEM! My microsoft access does not work. I click on the link, that opens up to microsoft access, its fine untill then. But when i try do do anything after that, such as, open a file, or create a new database, it shuts down, saying, that microsoft access has encountered a problem and...
|
by: Martin |
last post by:
I have an intranet-only site running in Windows XPPro, IIS 5.1, PHP
5.2.5. I have not used or changed this site for several months - the
last time I worked with it, all was well.
When I tried it just now, I am getting the subject error message
(specifically: PHP has encountered an access violation at 00F76E21).
The error is NOT occurring...
|
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...
|
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...
| |
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...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |