Search results

Hi everyone, So I have this tracker type database with an SQL server backend, and I just noticed that using Ctrl-f to find some record or using DoCmd.FindRecord doesn't seem to work unless the records are already loaded. It simply loads and loads indefinitely or until pressing Ctrl + Break. I...

I just did some testing with 5000 records and 1000 records using DoCmd.RunSQL "INSERT INTO [SQL SERVER TABLE] SELECT * FROM [ACCESS TABLE]" and these are my results: 5000 records took 208 seconds and 10000 records 411 seconds, so it seems to be proceeding at a constant pace. While much slower...

So the whole story goes something like this: We have used an Access database used by perhaps 50 employees in total, on average maybe 5-10 concurrent users with a back-end on a local shared drive for years. And then Covid 19 came, and home office and VPNs were a thing. The shared drive has...

I was also thinking that maybe the reason why it's gradually slower is the composite primary key, so I tried dropping all keys, index, etc, but it seemed to have little impact on performance. First 1000 lines take around 22, sec, and then for every 1000 rows added it just keeps climbing until...

Hello everyone, What's the best way to use VBA to transfer the contents of an Access table to a Microsoft Cloud SQL server (Azure) on a daily basis? I have a table with around 60-70 rows, and it takes hours when for example linking the SQL Server table and using INSERT INTO takes many hours...

Hi everyone, We have a table with around 60-70k records that needs to be inserted from an Access table into an SQL Server Azure table. Doing this with regular inserts takes several hours. So my idea was to make a stored procedure and submit many lines at the same time. This worked just fine...

The error described in this post is a very big problem in my office for certain users. Whenever these users try to create a data connection From Excel to Access, or if somebody is attempting to refresh an existing connection to Access, the "Unexpected Error, something went wrong" pops up for...

Thanks, that was the reason.

I have a form that doesn't really fit fully on the screen with scaling set to 125% or more in Windows 10 in Full HD resolution, so I want another form to be loaded instead if users have scaling over 100%. I already have code which checks if users have lower screen resolution, but I haven't been...

As it turns out, the problem was caused by the decryption function. On certain computers, while compiled, the function generated one of the password characters incorrectly for some strange reason. We replaced the function with another, and now it seems to work fine. :)

Right, it doesn't matter what reference is removed or added as long as you make a change. Maybe just because it makes Access go from compiled to non-compiled. Other things that we have tried is changing the bindings from early to late, but no difference. We also tried creating a brand new...

So it seems the problem has nothing to do with Windows 7 vs Windows 10. We have been able to narrow the problem down to VBA compilation. The problem occurs when the VBA is compiled. To fix it, one can go to the references and remove a library and readd it and it will work again. Anyone has any...

They are both SP1. Today there was even a Windows 10 computer which had this problem. One interesting thing, it seems that if we open one of these "broken" files, and go to the VBA References, and unclick or click on some random libraries, it seems to work after that.

Hi everyone, An Access database that we have developed doesn't work properly on a few computers in the company which use Windows 7, and we haven't been able to find any difference between the installed related software on those computers with Windows 7 where it works and those where it doesn't...

The combo information shouldn't change often at all, so making them persist in client side tables is probably a good idea actually. I guess I will have to implement some kind of back-end table with latest version timestamps for each source, so updates are only carried out when there has actually...

I thought I had tried it, but I must have used the wrong syntax, because I got errors. Your version kind of worked once now when I tried, but when I click on the combobox the options appear very slowly every time, and it tends to crash my Access almost every time for some reason.

I have a database using querydefs for connection to the MS SQL Server back-end, but I want to replace all these with ADODB-connections for security reasons (the database uses a service account with credentials in the connection string, and creating querydefs exposes the passwords so you can...

Hi, In the end we managed to solve the problem with the updates. It turned out the sub that's adding all the connection strings didn't update all the queries plus some other minor issues, so it turned out it was not the kind of error I thought. Thanks though. The data is not really sensitive...

How can I do that? I don't see any Refresh method. QueryDefs.Refresh Method (DAO) Office 2013 and later Other Versions Last modified: June 29, 2011 Applies to: Access 2013 | Office 2013 Not supported for this object. Syntax expression .Refresh expression A variable that represents a...

I have tried the methods here: https://www.access-programmers.co.uk/forums/showthread.php?t=167470