> Thanks! I think the best option for me is to enable that setting. I have a few projects that cause parser errors so clearly my code needs some work :)
Everyone's favorite: NEW PROBLEMS! I just opened an Access project and I started getting "File not found" errors. I opened the VBE to find that one of my modules is there but can't be seen. I double clicked through some modules and they all appear except for one. This one contains code that is called on open so it makes sense that the error was seen at startup.
Question: How is it possible to get "File not found" when viewing a module in the VBE? It's not really a file, is it?
yeah, I've only seen huge problems when people started working from home and complaining that my DB thing wasn't working. I learned that you can't access a backend across a VPN for no fucking reason other than "don't do that".
well, when you share an Access backend, you are basically doing something like this:
you're home. Tom's home. Tim's home. You want to read something, so you go to the library, get a book but instead of checking it out, you rip the page out from the book, go to the home. Tim does the same thing to different pages on the book. Ditto for Tom.
Tim makes some edit to the page, return and paste the page into the book back at library, and you later rip it out, and make your own edit to that page at your home, return to library and paste it back in.
but sometime on the way to library, you all drop pages in puddle of water, mud, whatever, you try to clean it the best you can but oh well. glue it back anyway.
In contrast, with a server-RDBMS, it's more like that you are not even allowed to touch the book. Instead you must request a page from the strict librarian who will birch your hands off if you as much look at the book, and she will dutifully xerox the page and hand that copy to you. You can then make edits and give to her but she and only she can actually make changes to the book.
I know there have been issues with how Windows server handles file locking on SMB shares. Maybe it closes the file locks inappropriately when the VPN drops packets.
and yes there are two types of locking going on. One file level lock upon every write operation. The other being table and record locking inside access.
AIUI, the write can be locked only for a page.... hence my page-ripping analogy
were it file level, then the analogy would necessitate you taking the whole book, not a page.
mind you, a page can contain several records so even if your edit only changed only one record, you still have to lcok the entire page and htus block others attempt to edit records that happens to be on the same page.
Oh, I'm talking about what the server sees. When you go to glue a page in the book you have to pick up the whole book. At this point the file is locked for writing by the SMB server. Other people can't glue the page in while you are holding it but they can read over your shoulder.
So when Access writes, it has to interact with the SMB server, which has it's own file level locking system.
I'm not sure about that - that's beyond my meager networking knowledge.
You might be right that only one person can glue the page into the book, but it certainly does give the appearance of allowing multiple people to glue pages; only not the same page at same time.
Either way, it sounds very very messy and you are going to end up with a sticky book
Yeah, we are talking about writing a few kb or less. The write-lock is very short to update a record so it would appear to be samletimeyously to the user.
VBA Rubberducking
VBA Rubberducking