This is solved obviously but I came back to do just a little more loop closure on how i setup a solution for our company moving forward because the LAA bit gets unset CONSTANTLY
I added to the batch file that is used to start our access application:
copy...
No I was mistaken I think I just assumed LAA was on by default -- its not for sure, but on another note that seems to be the main issue with my front end i have that one 800mb heavy form which I can optimize with late binding of sub forms but as of now simply enabling the LAA flag (by whichever...
At its core I'm sure its a multi varied problem but LAA seems to really be making a difference but when I have one form that chews up 800mb that is to be expected, what are the key differences between your add in version and the version 3 of your table monitor, I will use those tool also...
I read that it became the default in June 2023 - whether you have that version would be dependent upon what update channel you are on -- I know we are quarterly with P1, that delcaration came from this website:
https://www.accessforever.org/post/now-you-can-open-more-tables-and-databases
Two...
LOL well then....one time to start optimizing this main form.
I couldn't find the sample database Karl used for the logging but i was able to find the stack overflow article and recreate my own and what can I say the form does a lot -- late binding of subforms is probably going to help this one...
I do use 32 bit access for sure due to some ActiveX and the API modules are written for 32 bit (more so the activeX), I just deployed the Large Adddress Aware modified .exe and I read that Microsoft just enabled large address aware for access 32 bit in the June update for 2023 however I'm not...
This seems very promising and I intend to try many of these tricks out tomorrow.
https://codekabinett.com/rdumps.php?Lang=2&targetDoc=largeaddressaware-msaccess-exe
I mean I open 20 or less but i always close them and set them to nothing when done. I can also make the system crap out by just opening 10 or so forms in quick succession not just the beefy ones. Eventually it will complain or combo boxes will just be blank. Thats one wierd thing I've noticed...
I highly doubt its the backend since it happend on the origional server that ran the .adp (ran on that SQL backend server for 10 years with no issues) and then i stood up a brand new VM that is not taxed on resources at all. It has to be the front end in my opinion, its standard SQL. The new...
I have a front end database that I've used since about 2002 (in .adp format back in those days)
We recently migrated it from 2010 to Office 365 so of course that meant migrating from .ADP to an .ACCDB via Linked tables so we migrated to ODBC linked tables.
The SQL backend was 2008 at the time...
Well Thanks for everyone's input Ill just make a batch file for myself and my dev machine that does a runas and all the other users won't need to deal with the issue, its just annoying to me when things work and then an update breaks something....have i talked to you yet about not being able to...
I dont think thats accurate because I can still run if I simply authenticate the domain in a runas without joining the domain. Joining the domain is clearly not required.
runas /user:domain\myusername/netonly "C:\Program Files (x86)\Microsoft Office\root\Office16\MSACCESS.EXE"
I have an Outlook 365 .accdb that i link tables to an old 2008 R2 Windows 2008 SQL machine using Trusted authentication via our Active Directory
Connection string was DRIVER=SQL Server;SERVER=10.10.10.50;Trusted_Connection=Yes;APP=Microsoft Office;Network=DBMSSOCN
We are in the process of...
More information on the new Microsoft "FEATURE"
Is there no way to hack the registery to allow this vs using a hostname, ip works all the time hostname only works sometimes for some machines.
https://mangolassi.it/topic/24610/unable-to-mark-nas-location-trusted-in-office/12