Search results

  1. S

    this thread has been started for Richard.

    I just realized that there is an ignore button that allows you to ignore specific posters. What a relief. It should make this forum easy to read again
  2. S

    Automating FE updates

    Using the vbscript to call the .bat means that the user just double clicks a desktop shortcut and in a few seconds the app launches. The don't need to know that the script calls a .bat that connects to the drive, and transfers the file. Nothing launches other than the app itself.
  3. S

    Automating FE updates

    Indeed! I never realized you can set a shortcut that way now I see you can. Thanks for the tip :) I still prefer to not have it show altogether but cool idea...
  4. S

    Automating FE updates

    I use a .bat as well to map the drive to the folder on the server containing the BE, transfer a new copy of the FE from the location on the server to the client workstation, then launch the app. I didn't like the black window so the desktop icon points to a simple .vbs file that says this...
  5. S

    Access Memory Leak patched after only 17 years!

    What I really don't understand is this part: So Access database #1 is writing data to memory and not cleaning up, so someone who's hacked the computer can grab that data and write it to Access database #2? I can't understand any other interpretation of this, which leaves me with my question...
  6. S

    Access Memory Leak patched after only 17 years!

    I read the release and I may not be understanding this correctly: What type of data are we talking about that would be compromised? Data in the Access database? If so, then the leaked memory isn't any less secure than the Access database. Most of us Access users know that Access databases...
  7. S

    What's your feeling about churches and Christianity?

    It's post 15 I don't want to get into this discussion - I come to the forum to talk about Access - but my own views very closely match those of Doc_man
  8. S

    What's your feeling about churches and Christianity?

    While you're in correction mode, the quote in Matthew: "Behold, your king is coming to you, humble, and mounted on a donkey, and on a colt, the foal of a beast of burden" Is actually from Zechariah 9, not Isaiah.
  9. S

    Database growing hugely

    Ok, how about the most obvious: do you have any temporary tables in the front end? Including any that get created dynamically when doing some processing?
  10. S

    Access error -query is corrupt

    Perfect! Thanks so much! :)
  11. S

    Access error -query is corrupt

    In my case it's Access 2010. My question is if I will have to go to every computer using my application (there are over 1000) and download and install or if it will deploy itself eventually. In addition, many computers are locked down by IT departments who don't let outsiders tinker with...
  12. S

    Access error -query is corrupt

    I see that there are fixes available. Does that mean that you have to download and install them on every computer rather than the problem being solved as automatically as it was created?
  13. S

    Set focus to popup form doesn't work

    I know this is an old thread but I ran into this problem and it's now solved with your help. Thank you!
  14. S

    Access error -query is corrupt

    I use Access 2003 (still) and a query in my application that updates a table has been working flawlessly on my computer (Win 7 and Win 10) but failing on the computers of 7 clients today who have been using the same application on Access 2010 runtime.
  15. S

    Sending out emails from outlook via access

    Daniel Pineault has some good information about this topic. Here's a link: https://www.devhut.net/2013/03/26/ms-access-bypassing-outlook-e-mail-security-warning/
  16. S

    To archive, or not?

    Along the same lines as what others have said, my experience is that the performance will depend much more on good table structure (proper normalization and indexing) and efficient retrieval of records (good form design and efficient queries) than the number of records. Obviously this rule of...
  17. S

    Anybody used Access app with "Remote Access" software like Team Viewer

    Just to complicate things here: I use AnyDesk and I'm pretty happy with it. Not perfect but it does have a phone app, copy and paste file transfer between computers, and I find that overall it has good performance.
  18. S

    Front End Deployment of Split Database in a small enviornment

    To simplify the answer: Having multiple users in an FE over the network isn't really much better than not splitting the application in the first place. What I do is write a small batch file that updates the local copy of the front end when the user logs into Windows, or if I suspect that...
  19. S

    Zipping folders with vba

    Agreed but you can always zip it into a .zip
  20. S

    Zipping folders with vba

    Ok, that's really cool! I've been using 7Zip for years to extract .rar files but I never knew you can use it with command line command! Awesome!
Back
Top Bottom