Recent content by SuperShin

  1. S

    Main form flickers when opening a pop-up form

    I dont see how, the form that i made from scratch had the issue and it was made natively in O365. Also between 2000 and 2020 there have been several complete de compiles and re imports of all objects into new clean .accdb I'm here to say this bug isn't fixed. I tried it on a 3rd form i had a...
  2. S

    Main form flickers when opening a pop-up form

    I'm on O365 this project has been going since the 2000 version though but obviously i've migrated all the code base and objects to .accdb long ago, and I've had this issue in Access 2000, 2007, 2010 and 2016/365 I did skip 2003 and 2013 in my travels and RTE life. I will say the score is one...
  3. S

    Main form flickers when opening a pop-up form

    I hate to post on an old threads but honestly, screen flicker is something I've dealt with for, literally 15 years. I never could quite figure it out, I've read ALLLLLLL the articles and done ALLLLLL the code tricks, echo, paint, modal, disconnected text box labels, converting labels to text...
  4. S

    Solved Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

    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...
  5. S

    Solved Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

    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...
  6. S

    Solved Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

    I mean the access add in version vs the version 3 which is a sample .ACCDB with 1 table 1 form 1 report
  7. S

    Solved Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

    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...
  8. S

    Solved Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

    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...
  9. S

    Solved Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

    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...
  10. S

    Solved Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

    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...
  11. S

    Solved Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

    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
  12. S

    Solved Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

    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...
  13. S

    Solved Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

    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...
  14. S

    Solved Database Application constantly out of memory / system resources exceeded after migration to ODBC SQL

    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...
  15. S

    Integrated Security without joining the domain

    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...
Back
Top Bottom