Here's hoping that things have slowed down enough at the new job, the home is getting itself reorganized enough, and that the general craziness of the last two years has settled down enough that we get you back, at least on the weekends!
doesn't expect full-on 24/7, battery killing presence on chat/CR/etc.
Only have 3 monitors for the work laptop setup, but I've got 4 for home use! Just got a new desktop machine and was wondering if I could use the 3 video ports on the motherboard in addition to the 4 on the GPU. Sadly, no. I do have 2 1024x768 monitors gathering dust that I could have used for the purpose...
eh, yeah, one of the 4 in my current setup is 1024x768. It does nicely for some monitoring things (heh, get it? "monitoring things"...) like VPN and CPU utilization.
curious, how do you manage to to arrange windows on something so big? Does Win10/11 (or whatever Linux windows manager) allow for nice snapping of multiple windows within the screen size?
Of course it does... Not only does *nix offer 37 ways to skin each and every breed of cat, each method has its own religious following, complete with clergy structure.
Well, Access has me totally stumped. I have used DoCmd.CopyObject CurrentDb.Name, "localTable", acTable, "linkedTable" to copy a table from my backend in to the frontend. It makes an entry that appears to be a linked table with the localTable name. This seems odd. So I hover over it and it shows the path to the backend. Okay. So I close and open the backend and the table is not there. Reopen the front end and I see the linked table. I can open it. It has data. Where is it?
How could it be a linked table and also not exist in the backend? Wouldn't the link fail to open and show data?
yeah, I just exported my DB to source. When I open the tbldef it shows that it's a link to "linkedTable"... So it's just a shortcut. Another link with a different name.
wait a minute. DoCmd.CopyObject doesn't let you specify 1) the source database; only the source object and 2) whether to convert the pasted object as a local table or something.
When you do it interactively, you get a dialog asking whether to copy structure only, both structure and data or to append into an existing table.
because it does not give you such options, I would assume that it'd just copy a linked table
btw, if I interactively copy'n'paste a linked table, the dialog has 4th option which is also the default, to paste it as a linked table
so that'd explain why you end up with a localtable that's in fact a linked table. Not sure why your backend lost it, though.
I've asserted often that DoCmd really should be avoided - it's a poor way to programming because it depends so much on the context as if you were doing it interactively.