Search results

After short testing it seems this is working pretty nice. I just made a small change for my app. Instead ' grab the text from the control strText = ctl.Value & "" I have put ' grab the text from the control If ctl.Format = "Standard" Then strText = Format(ctl.Value & ""...

That's true, it probably could be the reason Thanks I will try it out

I run the same report on 2 different machines (one is windows 10 with access 2007 12.0.4518, and the other one is Windows 7 with Access 2007 12.0.6735). Regional settings are the same. There is a number field which has the standard format #,###.##. On the Windows 10 machine the 4 digit number...

Yes, all the tables are on the SQL Server. I just re-opened Access and now its working, driving me nuts lately heh Before closing Access I added the tables again, who knows did it mean anything. Anyway, works now

Ah yeah, sorry 😅 ODBC--connection to "ServerName" failed.

Set Radnik = MyDb.OpenRecordset("SELECT LDRadnik.JMBG,Radnik.ImePrezime, Raspored.Koeficijent, Radnik.BrojGod, LDRadnik.IznosNe1, LDRadnik.IznosNe2, _ & " LDRadnik.PorManji, LDRadnik.DSPO, LDRadnik.IznosIsp FROM ((Radnik INNER JOIN LDRadnik ON Radnik.JMBG = LDRadnik.JMBG) _ & " INNER...

Alright, I think I found the real culprit. There is a query which one of my Recordset variables uses in the transaction. The RecordSet (query) uses the same table RacUpl, as does the UPDATE query which fails. Somehow because both the RecordsSet and the UPDATE query have the same table in it...

Run-time error 3157: ODBC--update on a linked table "RacUpl" failed. @The_Doc_Man

The transaction is causing the problem as it seems (I hate it, it really doesnt like SQL Server as it seems :rolleyes:) Looks like the first time when I removed it from the code I forgot to save or I have no idea. Anyway, it works without it but I need that cursed thing. I moved my query at the...

I tried it now but same. I made a new command button on which I execute only that query and it works, so I suspect some code before that query. I will check the transaction again a bit later.

The exact same error.

Hi @theDBguy, no the query is not a passthrough one, its a "regular" one in VBA (I dont know the right expression for it): MyDB.Execute "UPDATE tmpRacuniZaEksport INNER JOIN RacUpl ON tmpRacuniZaEksport.IdRacUpl = RacUpl.IdRacUpl SET RacUpl.Eksportovan = True;", dbSeeChanges I didnt use...

I had a similar problem to this one in another thread I started, however this one is slightly different so Im writing a new one. Well, my UPDATE query fails in VBA with the error "ODBC - update on a linked table "table name" failed" The query is pretty simple: "UPDATE tmpRacuniZaEksport INNER...

- No, only me - No - Only Access The issue didnt appear again after removing that index. I did put it back to check the activity and I put in the attachment what I got

Unfortunately I dont have the time now to tweak with the query, but if I find some extra time I will post the details in a new thread. The table doesnt even have 32 fields, so no I didnt hit the limit of indexes. The index was a foreign key

Thanks Colin, I checked that link before when you suggested it once. Im trying to use the suggestions mentioned there as much as possible, but the thing is the query includes 14 tables and one other query. One of the tables has about 340k records, so Im kinda satisfied with the current speed of...

Alright, I found the culprit, it was just one of the new added indexes. Luckily it doesnt affect the performance too much but it still does when removing it. One important query without it needs about 8 seconds now, while with it, it needed about 4. Without all the indexes it needed over a...

Indeed, but from 1min to 3-4 seconds improvement is huge and I need it. Will do now, the speed without the indexes is killing me. Makes my testing a nightmare

When I remove all my newly added indexes the UPDATE query/code works but that slows down my queries a lot. Darn, Im lost here.

Sorry guys, have been a little busy today. Well I guess its right because it works when Im trying to update a smaller number of records. Im using Access 2010. Thanks. I have never used it, but will try to google more about it and find out how to. I would say one of my new added indexed is...