Hi,
I'm currently using MS Access 2000 to keep all my actors measurements, resumes and personal details on a database.
To upload their details onto our website, I have built an event so when I run the query, only certain data is selected and exported onto a separate database that I can easily upload onto our ftp server.
It has been working fine for all year until the past few weeks I have run into some problems.
Initially when I pushed the button to run the query, an error box popped up and I have the choice to end or debug.
When I choose debug, some of the coding appears with a few lines highlighted. Since playing around with it trying to fix it, this has stopped happening and instead an 'error, MS Access must close' box is appearing instead. I can't remember what the number of the initial error report was.
Through trial and error, I have discovered that this error only occurs when 'memo' datatypes are in the code.
The Text, Yes/No, Date, Number datatypes in the coding don't cause any problems at all and so when I exclude the memo datatypes, the query works fine.
I have double checked the 'memo' datatypes on my form to make sure their names and control sources haven't changed for any reason and they appear to be fine as well.
Does anyone have any idea why the memo datatypes are causing an error to occur?
Any help would be really appreciated as I am very illiterate when it comes to MS Access.
Cheers
Julie.
3  2007   MMcCarthy 14,534
Recognized Expert Moderator MVP
This would depend on your code.
Can you copy and paste the code into a post so we can have a look at it.
Hi,
I'm currently using MS Access 2000 to keep all my actors measurements, resumes and personal details on a database.
To upload their details onto our website, I have built an event so when I run the query, only certain data is selected and exported onto a separate database that I can easily upload onto our ftp server.
It has been working fine for all year until the past few weeks I have run into some problems.
Initially when I pushed the button to run the query, an error box popped up and I have the choice to end or debug.
When I choose debug, some of the coding appears with a few lines highlighted. Since playing around with it trying to fix it, this has stopped happening and instead an 'error, MS Access must close' box is appearing instead. I can't remember what the number of the initial error report was.
Through trial and error, I have discovered that this error only occurs when 'memo' datatypes are in the code.
The Text, Yes/No, Date, Number datatypes in the coding don't cause any problems at all and so when I exclude the memo datatypes, the query works fine.
I have double checked the 'memo' datatypes on my form to make sure their names and control sources haven't changed for any reason and they appear to be fine as well.
Does anyone have any idea why the memo datatypes are causing an error to occur?
Any help would be really appreciated as I am very illiterate when it comes to MS Access.
Cheers
Julie.
I have made a new discovery which may be contributing to my database problem. 
It is a very strange entry that I didn't enter in there.
Normally, I can easily alter or delete a person's entry off that table. If i try to do that with this entry, I either get a pop up box saying:
"the jet databse stopped working cause another using is using....", or else the database errors and closes down.
I don't want to jump to conclusions but do i have a hacker?
The code shouldn't be a problem because it has worked fine all year until the past 2 weeks (which is when this entry probably appeared).
I have tried to copy/cut out all of my normal entries except for that strange one so i can copy them into a new database and it won't let me - same error problem occurs.
I don't know what else i can do?!?
MMcCarthy 14,534
Recognized Expert Moderator MVP
This looks like corruption. It can happen when database is closed using close button on window rather than exiting the database correctly.
Create a new table and append all the records excluding the corrupted record and see if that solves your problem. Once you have done this I would recommend running a compact and repair. Take a copy of your database first.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: abcd |
last post by:
kutthaense Secretary Djetvedehald H. Rumsfeld legai predicted eventual
vicmadhlary in Iraq mariyu Afghmadhlaistmadhla, kaani jetvedehly after "a
ljetvedehg, hard slog," mariyu vede legai pressed Pentagjetvedeh
karuvificials madhla reachathe strategy in karkun campaign deshatinst
terrorism.
"mudivae maretu winning or losing karkun global varti jetvedeh terror?" Mr.
Rumsfeld adugued in a recent memormariyuum. vede velli jetvedeh madhla...
|
by: baustin75 |
last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie
only when debugging in php designer 2005
--------------------------------------------------------------------------------
Hello,
I have a very simple problem but cannot seem to figure it out. I have a
very simple php script that sends a test email to myself. When I debug
it in PHP designer, it works with no problems, I get the test email. If
|
by: Dom Boyce |
last post by:
Hi
First up, I am using MS Access 2002.
I have a database which records analyst rating changes for a list of
companies on a daily basis. Unfortunately, the database has been set
up (by my predecessor, I hasten to add) so that each day it creates a
copy of the record for each company, changes the date to today's date,
and prompts the user for any changes of ratings on that day. The
resulting data table grows by approx 600 records per...
|
by: Ken |
last post by:
I wrote a function to use in queries that takes a date and adds or
subtracts a certain length time and then returns the new value. There
are times when my function needs to return Null values.
Function DateCalc (blah...) As Variant
Do Stuff...
If Not IsNull(varNewDate) Then
DateCalc = varNewDate
End If
End Function
|
by: skinnybloke |
last post by:
Hi - I have a problem with a memo field being truncated to about 255
characters when running a Access 2002 query.
This only seems to happen if I use SELECT DISTINCT. It works ok using
SELECT by itself.
does anyone know why this happens and how to stop it?
| | |
by: hope |
last post by:
Hi
Access 97
I'm lost on this code please can you help
=================================
Below is some simple code that will concatenate a single field's value from multiple records into a single string separated by a user defined character. There is no error trapping
(by design), USE AT YOUR OWN RISK.
|
by: Kevin |
last post by:
Thanks for the very quick response posting that I can use a memo
datatype to store large amounts of text.
I understand that I can turn on "Can Grow" for a memo type, but is
there either a property or VB code that will allow the text box to
expand vertically as the user adds lines, so that it isn't necessary to
use the vertical scroll bar to view text above/below the displayed
window? I'm looking for a sort of dynamic autosize.
|
by: mathewbutler |
last post by:
Access 2000 SR-1
I've spent some time investigating this, and researching both here and
on the MS support site. Briefly;
Problem Description:
-------------------------------
I have the following query which I am using to export data into CSV
format;
|
by: Kunal Desale |
last post by:
Hi,
How to insert/update data in foxpro table field having datatype MEMO using Linked Server?
I have written sql insert queries in which i have used linked server to insert data into foxpro tables. Some fields have datatype Memo and in these fields my data is not getting inserted/updated.
My queries contains local tables & dbf tables (Both).
I try simple insert query which insert data into one memo field in foxpro editor
and sql...
|
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: 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,...
| | |
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: 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: 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: 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
| |
