"..Shifting to SQL Server is like climbing mount Everest.."
"..if you really want performance forget about that SQL server its just a story for kids.."
"..MYSQL in terms of performance it will always be superior.."
It doesn't seem like you've had good experiences with Sql Server, which I...
In reality it is not necessary to update a grid with the current recordset
In fact it is harmful because the operator could be in the middle of a modification
What I would do is simply 'display' the incoming call or in any case the change of state in the telephone pbx
Then it will be the...
When I wrote ".. over ten minutes.." I meant for a project with:
- 650 forms (the largest one 1,700 Mbyte, another ten over 400 Kbyte)
- 110 modules (the largest one 900 Kbyte, others 400 Kbyte..)
- 120 queries
- 300 reports
- 512 linked data tables
- 2 internal data tables
So I'd say we're...
Your hypothesis seems incorrect to me
If the Access code is executed only mono-core then why do we see several active and working cores?
What we see in the graph is only the activity of Microsoft Access because before starting I checked if everything was at zero or almost and the CPU commitment...
Sometimes it happens that an Access procedure is busy for a long time
For example, when I export a project of hundreds of forms and reports, using the Vcs procedures, the sequence of operations lasts over ten minutes
I'm talking about code that is executed and databases locally, and therefore...
Yes I know MzTools and the possibility of using its functions to create the start and end routines
I wanted to understand if it was possible to do it only from Vba code
And it seems not to be possible
In order to implement effective error handling, it would be useful if from code you could read the name of the sub/function inside which the code is running
A sort of Me.name for forms
Then the question is: how to read, via vba, the name of the function/sub inside which the code is running?
One of the most important features in the new version of Access is the Sql editor Monaco
I tried to use it, but I can't fully appreciate the improvements made
For those who have already had the opportunity to use it, I would like to ask: exactly, why use the new Sql editor?
How many data tables is the program connected to?
It seems to me that the limit for Access 2013 is 2048 tables OPEN AT THE SAME TIME
But simply for the connection, it does not seem to me that there is a limit imposed by the programming environment
I currently use Thunderbird, and it has been my local email and news client for over 10 years
Outlook is definitely more powerful and has better features
But where possible, I always prefer open source programs