473,324 Members | 2,214 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

I got this error "Errors were encountered during the save operation" !!?

115 100+
I got this error "Errors were encountered during the save operation" !!?
and when i click on help i got this:
This error can appear if:
You have exceeded the maximum number of columns allowed in a table or the maximum number of locks for a single file.
The indexed property of a field was changed from Yes (Duplicates OK) to Yes (No Duplicates) when duplicate data is already present in the table.

but i just have 14 columns!!
item(Article,stock,price,code_supp,st_q1,st_q2,... ,st_q10)

actually this error occurred when i was trying to put the default value of stock equal this
Expand|Select|Wrap|Line Numbers
  1. (st_q1+st_q2+st_q3+st_q4+st_q5+st_q6+st_q7+st_q8+st_q9+st_q10)
can any one help me please!!
Aug 3 '10 #1
6 5722
Steven Kogan
107 Expert 100+
I'll try to help.

Instead of changing the index and default value at the same time, try making those changes separately. Save after each change.

It seems you are trying to change the table design to index Yes (No Duplicates). Are there already too many duplicates? Perhaps that is causing the problem.

To check for duplicates construct a Find Duplicates query with the Query Wizard.

Setting the default value to the sum of other fields is problematic: you may want to consider using a calculated field in a query instead? Otherwise, the initial values of the fields would be zero, and your default value would end up being zero. So setting the default value in the table design doesn't make sense to me...
Aug 3 '10 #2
hannoudw
115 100+
ok thanks a lot
i'll try it
another question do you know this error?
cannot add records; join key of table 'item' not in recordset
Aug 3 '10 #3
Steven Kogan
107 Expert 100+
I don't recognize that error message. Is that the complete message?
Aug 3 '10 #4
hannoudw
115 100+
yes steven thx i solve it ...
but still i need help
can you help me ?
Aug 3 '10 #5
Steven Kogan
107 Expert 100+
Sure. How can I help you?
Aug 3 '10 #6
Steven Kogan
107 Expert 100+
Do you want to remove existing duplicates (for that field) in the table? That would be a good starting point.
Aug 4 '10 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Andrew McNab | last post by:
Hi folks, I have a problem with an MS Access SQL query which is being used in an Access Report, and am wondering if anyone can help. Basically, my query (shown below) gets some records from a...
0
by: RWC | last post by:
Hi, I'm running into a problem with Access XP (SP2) that's driving me up the wall. It's Error 2001 "You canceled the previous operation". There is no voodoo going on really when I get this...
2
by: Ronny Sigo | last post by:
Hello all, I already put the same question, only now I have more to tell ... Although I used this code before in the same routine (only the fieldname of the table differs) ___ at this point in the...
3
by: sklett | last post by:
This BUG that is so ridiculous I can't believe they shipped 05 is making my life hell. I have tried the various solutions found on the web and none of them have worked thus far. What's even more...
8
by: pukhton | last post by:
I am getting a yellowish block on Refresh statement under Medication_Name_AfterUpdate, and If i take it out it comes to the End sub... dont know what is goign on? This is what I have under Text52...
4
by: =?Utf-8?B?Um9iZXJ0IFN0eW1h?= | last post by:
Hello All, I am new to these forums and reasonably new to Visual Basic.net. I have been converting a couple of visual basic 6 programs to VB.NET. The programs began failing under windows Vista, so...
3
by: Larry Leonard | last post by:
Running MSDE 2000 SP2 on Windows XP SP3. I have a T-SQL script that is relatively simple (adding constraints, inserting rows, etc.) and short (maybe 300 lines, heavily commented). It's an...
5
by: mufc4life | last post by:
Hi, actually I'm creating a database for some coursework at school. It's basically about a booking system and how I book hardware in and out of the school for students who need the hardware. I've...
2
by: matt753 | last post by:
I have the following Dlookup statement: DLookup("", "", "=" & CStr(CRegion)) I get the error: "You cancelled the previous operation". The field is not null, it contains a 'Number' value...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.