Search results

Yeah, if I get an opportunity to test it, I will and post back. But, I was hoping someone more knowledgable of the underbelly of things might illuminate matters! :) For now, my copying is so trivially fast that a very small (milliseconds) delay should be all that is required to avoid errors...

I mean, I've read that file already and I couldn't find any information on whether it's methods were synchronous or not or what is going on under the hood that might help me understand when it considers it to be complete for moving to the next line of code.

Sorry I don't have a direct solution for you. Perhaps this article on VBA wrapper for powershell commands might be useful for you? https://www.devhut.net/vba-run-powershell-command/ As @The_Doc_Man says, you need a return value to check from your indepenedent thread. I believe you should be...

Sorry that I don't understand what you mean by this?

I will explain the real world scenario as well. In a few different sample scripts copying FE files there was code added to "wait/sleep" until the file copy was complete before executing a run command to launch the db. The reason given was to ensure that Access wasn't trying to launch a file...

I can't seem to find a definitive answer. Related to this would be if anyone has a list of blocking/non-blocking calls. You might also describe it as synchronous/asynchronous. For example, a shell object method is fired off as an asynchrounous call, passing along its info the the shell and...

@NauticalGent - That's some pretty good references. Thanks!

@Isaac - Find out anything interesting? I have my DB launch script in VBscript currently. But, with the IE deprecation invalidating VB splash screen code, I'm looking into using powershell to handle the splash screen and launch the app while running the vbscript in betweeen. Still learning...

Security is not that much of an issue. However, this seems like a simple thing that doesn't make my life much more difficult but adds another layer of knowledge on the end users part to mess something up intentionally or otherwise. And, yes, I do plan on managing the navigation pane visibility...

@Pat Hartman - Yes, that makes sense. That is what I intend. I realize my first sentence in #9 was phrased ambiguously. I didn't mean I expected users to browse the network to search for a BE. I meant, IF a user already knew how to browse server shares that could potentially be an issue given...

@The_Doc_Man - True. Thankfully it give me time for my neophyte development skills to grow. :)

Thanks for the info @Pat Hartman and @The_Doc_Man. Right now, a user would have to know how to browse to the server domain and find the share the BE would be stored in. Currently, I'm the only employee that knows how to do that. That could change in the future (we're a small company). We...

@Pat Hartman - :ROFLMAO: @The_Doc_Man - I believe the "overwrite doesn't happen until the code exits" is what is going on. It is a VBScript running locally that will be my DB launch script. So, one thing it does is copy all the files in the production FE directory to the local install...

I'll keep that in mind. Just trying to firm up all the various locations, permissions, etc.

Not intentionally I ended up using a script to copy all files in a server location to a local location. One of those files happened to be the same script I was running. The local script file DOES get updated by the "old" script. Is this due the the script engine quickly reading in the entire...

Which is enough permissions to do anything really. But, thanks for clarifying for me.

I assume that all database users will need full permissions to the local network share that contains the backend, else Access couldn't write to the database. Split Database; Backend on network share; Fronend on local computers Is this correct?

Thanks Colin. I forgot you referenced the installer earlier. I'm pleased that my script seems to work and since the directory is a user folder and the registry keys are user keys I don't think I'll run into any permission issues despite our Active Directory setup.

I wanted to clarify I wasn't giving directions. I realized my choice of words could be interpreted as such. What I was saying is that Access is doing exactly what you are telling it to do. First, you tell it to "Don't Run Any Macros". It agrees. Then, you tell it to "Enable Content". It...

Others who know the inner workings of Access better than I can chime in....but.... I believe a macro is just an added layer on top of Visual Basic for Applications (VBA) code that makes automation easier for non-programmers. So, you first "stop all macros" (stop code from running) and then...