question

Runner-2178 avatar image
0 Votes"
Runner-2178 asked thedbguy answered

MS access speed problem

Hello ,
I have a problem with a speed of more than 1000 transactions will slow down the program very much, the query is displayed relatively quickly, but converting to a table takes a long time, how can I quickly transfer a query to a table, I tried everything but the program is very slow. I do not understand how it shows quickly, but it cannot create with such speed.

I see the query screen, but I cannot copy what I see, it starts calculating and it takes a long time, can I copy the screen like a screen without secondary calculating.

office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thedbguy avatar image
0 Votes"
thedbguy answered

Hi. As I said in the beginning, I am not sure what happens in the background when Access converts calculated data into a table. Using the same data you provided, I tried to run three different methods of creating the xp0 table. They all came out to take about the same amount of time. So, I guess I am not sure how to make that process any faster. Good luck!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Runner-2178 avatar image
0 Votes"
Runner-2178 answered

i dont need export to excel i want create table from xp2

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Runner-2178 avatar image
0 Votes"
Runner-2178 answered

I am looking for a faster model, this is very slow for my project

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Runner-2178 avatar image
0 Votes"
Runner-2178 answered

this is only 1500 records, 60 000 are almost impossible, can you somehow increase the speed or this is the limit
I am looking for a faster way

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thedbguy avatar image
0 Votes"
thedbguy answered

Hi. What is too slow for you? I was able to create a table in about a minute.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Runner-2178 avatar image
0 Votes"
Runner-2178 answered

thank you i send file

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thedbguy avatar image
0 Votes"
thedbguy answered

No promises but here it is: thedbguy (at) gmail (dot) com

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Runner-2178 avatar image
0 Votes"
Runner-2178 answered

if you give me email i send access file

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Runner-2178 avatar image
0 Votes"
Runner-2178 answered

no i cant send access file

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Runner-2178 avatar image
0 Votes"
Runner-2178 answered

yes very slow i can send file for you

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.