Search results

Hey guys I just didnt find time to do further testing. I have another weird similar problem, with a different query and tables involved tho. A query with 2 subqueries in it and one table. FROM (qryPocStanjeAll RIGHT JOIN Konto ON qryPocStanjeAll.Konto = Konto.Konto) LEFT JOIN qryPrometAll ON...

Awesome, I will see to implement that. Thanks

Alright, I found it out. After closing all the class objects, I just had to do a compile :banghead: After that when I relaunch the .accdb the class objects dont open

Nope, I cant find any difference in settings. In fact earlier I achieved this on one of my .accde and then I wanted to do it on the same one just with different linked tables and I couldn't.

A quick question... Im opening my .accdb with the shift key and after that when I launch the VBA the VBA opens all my class objects and it takes some time. I tried closing all of them and then close the .accdb and open it again. After that I opened the VBA again but again all the class objects...

So every field which is Number is by default indexed? These OR are still confusing me in the criteria when there are multiple. Galaxiom Thanks that speeded up my query, and one other had the same field before I changed it, needed time to execute was a little more than 6 seconds, after changing...

Alright, I made a new table from the above query a bit modified (table in attachment) SQL for the create table query: SELECT CLng(Right(CStr([ItemDatabase].[Konto]),5)) AS CustomerId, ItemDatabase.Konto, ItemDatabase.ItemDate, 0 AS StartingBalance, ItemDatabase.CustomerDebts...

To reach the last record happens within a second, pretty fast. Now I actually saw that the number of records dont match for the 2 different Group By fields. But I could fix that by creating a new table where I will export all records from ItemDatabase WHERE Date would be from 2012 and above with...

I saw that indexing is quite recommended, and it should be especially useful to this table because nothing will be added to it for a long time and definitely nothing will be updated? Im just not quite sure which fields to index, I tried the date field but somehow the time to finish the query was...

Nope, its not split probably should be but for the time being I have to leave it like this. Indeed, its over 1GB. I was reading your link today I saw it on my other thread and thats when I moved the Group By from Clng to just Konto but obviously I should read it few times more. Thanks, I will...

Hmm but the Date criteria changes often, the user puts it through a form. Wouldnt that create a problem?

No they wont be changed at all for at least a year, it stays as it is. Maybe yearly some will be added after new year or so. But that would be done manually, not from code or anything

I have a query with just one table in it but with a lot of data in it, more than 6 million. The table contains data from 2006 up to 2018 (no new records are added to it or removed) but I only need from 2012 and above. So I was thinking to make a new table which wont contain anything under 2012...

Indeed, update queries are awesome but I'm still a beginner and struggling to create them in some conditions :D Currently I'm busy with something else and this is on hold :/

Thanks, I will read that and if I find extra time post my code to explain it in more details. The loop i was talking about is actually reduced from about 9min and 40 seconds to about 8 seconds now and the whole code on the button click is taking 42 seconds. In short the code has 2 loops (While...

I modified the code a little and now its from 10min down to 42 seconds, hopefully without any new errors :) In the loop there was a Set VariableName = MyDb.OpenRecordset("SQL..."). In the query was another query joined to some other tables and that line of code needed a little under a second to...

I wasn't clear enough, sorry. On the second server there is a similar database which is being used on a daily basis. That database isn't important, I just mentioned it because RDP. I copied the database from server 1 to server 2 by overwriting the server 2 database, so it's the database from...

Very possible any thoughts how I could close it down, is it the SQL Server not running as it should, maybe something with the Windows OS or even hardware related?

No, unfortunately Im not in the position to do it so right now. I connect to the servers remotely with a 3rd party app. Right now I dont have access to the PCs which access the servers over RDP. On the other server which works faster users also connect with RDP but the database and accde is...

Hey guys, Im not sure if this is the right place for this but here is whats making me troubles. Im keeping queries, reports, some temporary tables and forms in my .accde and the big tables with data are on the local SQL Server databases so the tables are linked to the .accde. The users use a...