Recent content by arj446

My mistake : it's now corrected. Thanks !!

OK so... I went through the documentation and links you sent : it doesn't really apply to me. First, I'm the only user on this database (it's a local one). What's more all the tables are linked from the server. And the query I'm running is the simplest. In the example I gave on my first post ...

No issues during testing, I was even surprised some of the queries took so little time. I'm looking into the passthrough queries and it's pretty interesting : had no idea you could do that. I'll definitely give it a try as soon as my daily "ToDo" is cleared. As for the indexes... I'm not...

Hey Guus Thanks for your answer. I did compact the database, and the network speed is optimum : as I said, the "slowness" was not a problem with the former version of Access. You kind of lost me at...

Hi We used to work on Access 1997 until yesterday, when we switched to Access 2010. For some reason, some very simple queries that used to work perfectly fine are so slow in the new version of Access that it's not even funny... Here's the SQL code of one of those queries : Used to take 15...