Using Delphi for developing, I get and delete records from an Access
Database 2000.
Sometimes, It happened 3 times (but not reproductible), the application did
not succeed in connecting the database. A table is corrupted and when you
compact, this table is deleted with an error -1206 created.
I did not find resources on this problem on the web. if somebody can help, I
have to solve it by Monday (it is quite HOT !).
If somebody can tell me what happened and maybe how to solve it or simply
what it is the turnaround, it will really help.
Thanx a lot !
julien
5  5083 
Jucius wrote: Using Delphi for developing, I get and delete records from an Access
Database 2000.
Sometimes, It happened 3 times (but not reproductible), the application did
not succeed in connecting the database. A table is corrupted and when you
compact, this table is deleted with an error -1206 created.
What is a 1206 error?
"Salad" <oi*@vinegar.co m> a écrit dans le message de
news:40******** *******@vinegar .com... Jucius wrote:
What is a 1206 error?
It is not documented. It seems to explain that a table is corrupted. Maybe
it is a problem with Long Values.
Jucius wrote: Using Delphi for developing, I get and delete records from an Access
Database 2000.
Sometimes, It happened 3 times (but not reproductible), the application did
not succeed in connecting the database. A table is corrupted and when you
compact, this table is deleted with an error -1206 created.
Well, a 1206 is undocumented per your post. Is 1206 a Delphi error? Or is it
an Access error.
When you connect to the database, do you have an error trap? I should think
that if you don't have an error trap, it would be hard to determine when the
error that corrups your table occurs. Somehow, someway, in Delphi you need to
errortrap your connection routine and even the delete routine.
"Jucius" <za********@hot mail.com> wrote: Using Delphi for developing, I get and delete records from an Access
Database 2000.
Sometimes, It happened 3 times (but not reproductible), the application did
not succeed in connecting the database. A table is corrupted and when you
compact, this table is deleted with an error -1206 created.
I did not find resources on this problem on the web. if somebody can help, I
have to solve it by Monday (it is quite HOT !).
Is this on your own system? Or on a network with multiple users in your app?
If on a network then see the Access Corruption FAQ at my website for a wide variety
of reasons. I'd suggest the OpLocks fix first though.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
"Salad" <oi*@vinegar.co m> a écrit dans le message de
news:40******** *******@vinegar .com... Jucius wrote:
Well, a 1206 is undocumented per your post. Is 1206 a Delphi error? Or
is it an Access error.
1206 is the error I get when I try to repair the base. In fact, I compact
and I lost a table and get an error table that indicate an error 1206 (the
database cannot get the description of the table.
When you connect to the database, do you have an error trap? I should
think that if you don't have an error trap, it would be hard to determine when
the error that corrups your table occurs. Somehow, someway, in Delphi you
need to errortrap your connection routine and even the delete routine.
I did not succeed in connecting the database via ODBC.
The problem is that we did not succeed in reproducing the error from start
(when the table is OK)
Thanks, This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Jucius |
last post by:
After a common use of Access with a Delphi Application, I restart the
application an it does not succeed in accessing the database. (after 3
months of use, nothing special was done !)
I try to use it with access and I have a problem opening a table (Database
Format Not Known !). The other tables are OK.
When I try to compact the database, it simply delete the table that is
concerned and indicate an error -1206 ?
The problem happened 3...
|
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: L Mehl |
last post by:
I tested a FE/BE application developed in A2000 on a A2002 machine and got
this message when exiting the app. Clicking the only available button "OK",
exits the application, as intended.
The FE is just the mdb, not an mde. FE and BE are in different directories
on the same machine.
Are there settings, preferably via code, that I can add to stop this error?
Thank you for any help.
|
by: ALFRED |
last post by:
Hi
Using access 2003
I have a front end and back end. I would like to close the connection to the
backend so that I can compact the back end without leaving the front end.
Currently I must exit the datbase and start the repair form from another mdb
that is not connected to the back end.
I have tried
Dim appAccess As Access.Application
|
by: Ken Davis via AccessMonster.com |
last post by:
I get this error message when trying to compact and repair my database:
(Could not find field "Description"). When I clicked on Help, the error message number comes up as (Error 3799) It's the first time I see this. Help anyone?
--
Message posted via http://www.accessmonster.com
| | |
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: rdemyan via AccessMonster.com |
last post by:
I've converted my application from A2K format to A2003 format.
I tried to follow Allen Browne's protocol in getting my app into A2003
(although I was unable to find informtion on the conversion process). Lots
of decompiling and lots of compacting of the original application in A2000.
Then the app was opened in A2003 and compacted, decompiled and compacted.
Next I imported everything into a blank A2003 database. Then this db was...
|
by: ARC |
last post by:
Hello all,
I have one chance to get this right, as I'm nearing a release of a program.
I've looked at the database settings, and so far, have set the following:
* Unchecked 'Enable design changes for tables in datasheet view'
* Unchecked 'Check for truncated number fields' (I would prefer the user NOT
see #### in fields or columns that they shrink too far)
* Unchecked 'Track Name AutoCorrect Info'
* Set all Tables to 'SubDatasheet =...
|
by: johngault |
last post by:
I've been working with this PHP page for several days now and I'm stumped. The page is supposed to allow the user to upload up to six images for their profile. When the user adds an image it (the page coding) does verify file size, if correct it places it on the server in the users folder and with the correct names and extension, creates the thumbnail and adds the correlating file name. However, it only adds the first file name to the database....
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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: 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...
| |
