Hello, I have DB located on network, and network cable was cut off
accidently few days ago... now its fixed, but I can't add new records
to the DB with forms...
The error I get is this (when trying to add new record):
"The changes you requested to the table were not successful because
they would create duplicate values in the index primary key or
relationship. Change the data in the field or fields that contation
duplicate data, remove the index or redefine the index to permit
duplicate entries and try again."
I tried to change the data, first it didn't let me to, then, I removed
relations to table I suspect is causing problems, removed all indexes
on that table, changed "AutoNumber " on one column to "Number", and then
was able to change one last row of data with wierd characters -
replaced them manualy with meaningful data that should be there...
After that, I opened application and was able to insert only one
records, without problems, but then, when tried to insert next new
record - it failed again, with the same message...
Any advice for me what to do, what is the problem here, how to fix it? 3 1511
Your database is likely corrupted. Try to do a Compact/Repair.
Tools --> Database Utilities --> Compact and Repair Database
if that doesnt work you may have to create a new database and import
everything from the old one, which may or may not fix the corruption.
Hope this helps
Colin
*** Sent via Developersdex http://www.developersdex.com ***
ColinWard wrote: Your database is likely corrupted. Try to do a Compact/Repair.
Tools --> Database Utilities --> Compact and Repair Database
if that doesnt work you may have to create a new database and import everything from the old one, which may or may not fix the corruption.
Hope this helps
With either method, make a backup copy first. Colin
*** Sent via Developersdex http://www.developersdex.com ***
Salad wrote: ColinWard wrote:
Your database is likely corrupted. Try to do a Compact/Repair.
Tools --> Database Utilities --> Compact and Repair Database
if that doesnt work you may have to create a new database and
import everything from the old one, which may or may not fix the
corruption. Hope this helps
With either method, make a backup copy first.
Compact/Repair didn't fix the corrupted data...
But what I found out is that after I deleted all the relationship
between tables I was able to also delete AutoNumber field,
specifically the very last row which was corrupted...
That AutoNumber was messed up also, so, I after I deleted the row
and after I inserted manually new record, with normal values,
I recreated primary keys, indexes, and relationships,
and now database functions normaly... Colin
*** Sent via Developersdex http://www.developersdex.com ***
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Pandis Ippokratis |
last post by:
Hi,
I have the following problem: I am implementing a server in Java and
I use jdbc to connect to an Oracle 9.0.2 db. All seem to work fine,
but when I intensionally cause a network failure (i.e. I remove the
network cable) I get the following exception:
java.sql.SQLException: Io exception: Connection reset by peer: socket
write error
|
by: Vani |
last post by:
Hi All,
Is it possible to save a file on a network folder from a web application which is developed in ASP.Net.
I tried mapping a network folder on the server and tried to save a file on that mapped folder. I am getting error as :
"Logon failure: unknown user name or bad password. "
Please help me to resolve this problem.
Thanks,
|
by: Roman Troshkov |
last post by:
Hello,
I Hope to see any opinions on this problem:
After installing Net framework 2 on one of our Win2003 Web server I have
experiencing trouble accessing MS SQL 2000 database.
Configuration is:
ASP.NET application is running on WEB server with application pool security
account set to “Network Service”.
This application accessing MS...
|
by: Daniel |
last post by:
How to access a network file path \\foo\bar.txt from an .aspx and from a
custom IHttpHandler?
How to specify which account that aspx application should use when doing
file IO from network paths?
When I try to open the file from .aspx the file read throws: Logon failure:
Logon failure: unknown user name or bad password.
When I try to open...
|
by: titojermaine |
last post by:
The problem is that after reducing MSDTC security to "No Authentication", it mostly seems to work correctly, except that after a brief period of inactivity (a few minutes), the first attempt to use DTC fails, but subsequent attempts are successful, until inactivity again.
The original environment was a single machine with SQL Server installed...
| |
by: =?Utf-8?B?RXZlcnQ=?= |
last post by:
After cloning a SATA hard drive with Ghost I cannot login to it. I placed it
in a new PC (exactly the same as the one being cloned) but when I start the
login screen appears, i give my username and password, windows logs on and
the message "network connection are being made" is shown, a few second after
that the message "network connections...
|
by: sreejithp |
last post by:
Hello,
I am new to python. I have been trying to connect to telnet and feed some data from a server. Its working properly. I used the connectionObj.read_until() method to read the data from the server and made the connection as
self.conn = telnetlib.Telnet(so.telnetHost, so.telnetPort)
thats too fine.
|
by: marshmallowww |
last post by:
I have an Access 2000 mde application which uses ADO and pass through
queries to communicate with SQL Server 7, 2000 or 2005.
Some of my customers, especially those with SQL Server 2005, have had
pass-through queries fail due to intermittent connection failures.
I can easily restablish a connection for ADO.
My problem is with...
|
by: AAaron123 |
last post by:
I downloaded the personal website starter kit and when I run it I get the
error shown below.
I found a way of using Launch Surface Area Configuration that is supposed
to fix the remote setting but I tried it and still get the error.
I do not have SQL Server 2005 installed (thought I did once). I do have SQL
Server 2008 installed.
I...
|
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: 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. ...
| |
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...
|
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 projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
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: 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.
| |