Search results

yes, I've insert that code into a new vba module and restart the db many times, but shift key is always active. Maybe something to set into the code or something to change? Please note that my db has FE and BE, but I think It should do not interest this.

Hi, This thread is a bit aged….but I would need the same thing. I found this code on the post above, but it seems doesn’t works: Function sara_shift_open() Dim db As DAO.Database Dim prop As Property Const PropNotFound = 3270 Set db = CurrentDb() On Error GoTo CatturaErrore...

Hi, today I've added trusted location in my access options at my lan but unfortunately no upgrade performace noted. Now I have Access 2016 32bit; may be more speed if I install access 2016 64bit? I could also install access 2019 64 bit..... my db could run more speed than 2016 version? thanks

If really mysql has best performances (for my case) I could import BE into a Mysql server and use only FE Access. I've imported access BE into SQL server last week and it was very slow so I come back to access BE. But if MySQl is different (i don't know) I could try.... what do you think?

Thanks for reply Yes, we have added persistent connection to be.

Thanks, Running 4 FE on the server (where BE is placed) has been only a test I've made myself.

Thanks, unfortunately I don't know if my users are directly interacting with tables or queries ( I don't have the competence to understand this). I suppose and hope no :) Please note that the good speed performance with 4 FE open there are only if they are open into the server (no LAN required).

I didn't know that option in access..... tomorrow I will add trusted location at the folder where BE is placed. Maybe can help. Thanks Minty

Thanks Minty for reply, tomorrow I will test my LAN with iperf (I found this LAN test on web....I hope It is ok) How can I check this? Is the backend file in a trusted location for all the clients?

Thanks for your answer CJ_London about your helpful link "addressing performance issues" Access 17. Has name autocorrect been turned off? --->yes 18. has front end been compacted? ---> always when BE or FE is closed "auto" contrariwise for Tables, queries, Forms/reports, Modules, I...

FE copy is stored in each Hd client

I forgot: - I'm using Access 2016 - We have already implemented Persistent Conncetion

Hi at all, I use an access DB already splitted: 1 BE on server, n. 5 FE on clients on my LAN network. BE is 80 MB FE is 7 MB It works well when only one user is logged in; But it becomes slow when 2 or more user is logged in. I'm not a coder, (the db has been made by a friend), but now I would...

Hi All My name's is Luca....I'm trying to undestand something in this complicated access world :) Very soon I will open a thread to ask you something to improve access FE and Be perfomances on LAN. Thanks in advance at all :)