Solved MS Access file with VBA macros


Firstly, like I already tried to point out in my post, Sandboxie-Plus is not a VM. Rather, it is called isolation software, and FOSS (free open source software), published on GitHub.

Secondly, the real world comes bundled with real problems like hackers who break into college network infrastructures and lazy professors, the latter often will assume they know everything about everything. Mainly as a consequence of these two real problems, the concerns that were raised by @garlin are all 100% valid, and are valid for reasons that shoud be trivial for someone who, like me, has been programming computers for 38 years, but even after 38 years of knowing Microsoft you won't hear me say that I'm an expert. Knowledge is always important I mean, but since we were talking about the real world, I'll argue for something different. So, I'll argue for things like, "Once bitten, twice shy" and "Better safe than sorry".
There is nothing wrong with being cautious but you can't be paranoid about everything. If you told your college classmates you needed to to use Sandboxie-Plus for your class assignments they would think you were strange. I wrote my first computer program in my second year of college in 1971. College IT departments are very cautious about what is put on their networks. You mostly have to worry about media shared outside that network. For example, sharing things on flash drives. BTW, back in the 1990's I got a Word macro virus from a floppy disk that was shared by a classmate. I have been using computers for more than 50 years but I wouldn't call myself an expert either but at least I know what makes sense and what doesn't.
 

My Computers

System One System Two

  • OS
    Windows 11 Pro 23H2
    Computer type
    Laptop
    Manufacturer/Model
    ASUS TUF Gaming A15 (2022)
    CPU
    AMD Ryzen 7 6800H with Radeon 680M GPU (486MB RAM)
    Memory
    Micron DDR5-4800 (2400MHz) 16GB (2 x 8GB)
    Graphics Card(s)
    NVIDIA RTX 3060 Laptop (6GB RAM)
    Sound Card
    n/a
    Monitor(s) Displays
    15.6-inch
    Screen Resolution
    1920x1080 300Hz
    Hard Drives
    2 x Samsung 980 (1TB M.2 NVME SSD)
    PSU
    n/a
    Mouse
    Wireless Mouse M510
    Internet Speed
    1200Mbps/250Mbps
    Browser
    Firefox
    Antivirus
    Malwarebytes
  • Operating System
    Windows 11 Pro 23H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    Custom build
    CPU
    AMD Ryzen 7 3700X
    Motherboard
    ASUS PRIME X370-PRO
    Memory
    G.SKILL Flare X 32GB (2x16GB) DDR4
    Graphics card(s)
    ASUS ROG-STRIX-RTX3060TI-08G-V2-GAMING (RTX 3060-Ti, 8GB RAM)
    Monitor(s) Displays
    Samsung S23A300B (23-in LED)
    Screen Resolution
    1080p 60Hz
    Hard Drives
    2TB XPG SX8200 Pro (M2. PCIe SSD) || 2TB Intel 660P (M2. PCIe SSD) ||
    PSU
    Corsair RM750x (750 watts)
    Case
    Cooler Master MasterCase 5
    Cooling
    Corsair H60 AIO water cooler
    Mouse
    Logitech K350 (wireless)
    Keyboard
    Logitech M510 (wireless)
    Internet Speed
    1200 Mbps down / 200 Mbps up
    Browser
    Firefox, Edge, Chrome
    Antivirus
    Malwarebytes (Premium)
    Other Info
    ASUS Blu-ray Burner BW-16D1HT (SATA) || Western Digital Elements 12TB USB 3.0 external hard drive used with Acronis True Image backup software || HP OfficeJet Pro 6975 Printer/Scanner
But this is a college class! Access will be run in either Windows 10 or 11. People taking these classes are training for the real world. You're not going to use a VM or similar at a regular job.

The class syllabus determines what software is used. If it says Microsoft Access then that is what will be used. I don't understand why people are arguing for something different.
Many people do actually use a VM without knowing it however the point is taken as they won't be installing or configuring the VM -- -- a lot of corporate servers are often based on a "Virtual Desktop Infrastructure" which usually runs as an application over a standard Windows laptop.

One of the worst ever bits of corporate junk is the CITRIX system -- always amazes me that usually in choice of sensible software corporates often choose the worst possible (and it's often not the cheapest by any manner of means). Perhaps a few "Backhanders" at the Golf Course -- who knows.

However if the syllabus requires MS ACCESS then so be it -- but do be aware that it's particularly weak and using a load of VBA macros on an intrinsically weak piece of software comes with additional risks.

cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
"Better safe than sorry".
That was my initial thought when I initially posted this :) Thank you all for the help.
 

My Computers

System One System Two

  • OS
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Acer
    CPU
    i7-11800H
    Memory
    16 GB
    Graphics Card(s)
    Nvidia RTX 3060
    Screen Resolution
    1920 x 1080
    Hard Drives
    Samsung 980 EVO SSD
    Mouse
    Corsair Harpoon
    Internet Speed
    1 Gbps
    Browser
    Microsoft Edge/ Google Chrome
    Antivirus
    Microsoft Defender
    Other Info
    Acer Helios Predator
  • Operating System
    Windows 10 Pro
    Computer type
    PC/Desktop
    Manufacturer/Model
    Built
    CPU
    i5-7600K
    Motherboard
    GIGABYTE Z270HD
    Memory
    16 GB Crucial Ballistix
    Graphics card(s)
    Nvidia GTX 1060 OC 6GB
    Hard Drives
    Western Digital Black Edition SSD

Latest Support Threads

Back
Top Bottom