Search results

I don't want to change a back end that is in use. This is a development issue only.

@Pat Hartman - I don't know that I'm doing wrong (or misinterpreting in what I'm seeing). If I have the devFE open and then do File > Open > devBE the devBE opens (I see the tables in the nav pane) and the devFE is not there anymore. I don't see any open instances in my windows taskbar and I...

@GPGeorge - I deliberately did not put the question into context because I did not want to muddy the waters. Perhaps that was a mistake. Colin answered my question just fine and I was trying to get some elaboration from him. By the time he resonded to my question in post #3 the thread had...

Somewhere in here we seem to be having a bit of a disconnect. I am NOT asking how to handle deploying a development database through testing and release to the production environment. I've read in this thread and others some very fine examples of this process from @The_Doc_Man, @Pat Hartman...

So, what I'm hearing is that, in general, all of you experienced developers when adding functionality to an existing database (within a development setup, NOT production): 1. Directly open your development BE and create any new table structures and relationships. 2. Close the development BE 3...

Whew! Stirred the pot again ;) This is likely a case of me just being inexperienced, literally ignorant, of the functionality in Access I'm looking for. Some clarifications: 1. This question is within the purview of working on development versions of the FE and BE. 2. The only reason this is an...

@gemma-the-husky Yes, that was at you ;) Depending on how often "occasional error" occurs, that seems like a relatively time efficient way to test if your suspicion is correct. I would guess without a much more deep dive into the specifics of your code, which API calls are made and everything...

So, what is your methodology if you are adding a table or two to an existing db that is already split.

There are some older posts that imply that functionality MIGHT exist.

I'm sure theDoc will have a lot more technical detail, but, a couple of questions of my own: 1. Can you wait until the previous API call is completed to initiate your 2nd API call? Is there a way to assure that programatically? 2. Some calls have returns. Is there a way to monitor the return...

That makes more sense to me. Thanks! I think your logging and my logging might be talking about different things? I have user logging code in a module. One routine writes using an SQL statement to a table of users that changes the user status. It also writes a record in a related session...

Can you elaborate a bit? The destination is a local folders on each user's computer. The source is a network share hidden using the "$" switch. So, theoretically someone could be in there but it is unlikely. The file exists check makes sense but I guess I'm missing the VBScript knowledge to...

I actually agree with you about VB...too inspecific. Not sure why I abbreviated it that way. :) It looks like right now there is no appreciable delay in deleting/copying the FE over and launching into Access. So, no splash screen seems to be needed at this time. At some point in the future I...

@The_Doc_Man , @CJ_London - Thanks for the replies! I've moved away from rolling my own user login form. I'm letting Active Directory handle user authentication and then I'm just grabbing the username when they connect to the database. There eventually will be some additional database...

Thanks for the info @The_Doc_Man, I figured you would have some knowledge of the underpinnings of everything! Even though the real world timing is trivially small, I ended up setting up check code to count the number of files in the source and destination folders and make sure they match. That...

I bumped this thread because I couldn't find anything to go with this quote: It might be helpful to explain exactly what the "done right" would be, no? Especially for us dummies! ;) I've seen a few experienced users talk about using their user logging/session logging tables as the persistent...

I copy more than one file, so this seems better than individually testing if each file is copied.

Well, I kind of answered my own question! To workaround the whole sync vs async question it is easiest to count the number of files in a directory to check if the files match. If I'm overwriting, the counts will always match. If I delete and then copy, then a count will be a good test of...

@Isaac - Since you are wandering around here at the moment ;) I was going to resurrect another thread but I'll just ask you here as its tangentially related. In another thread about FE updating, you described your process as: Deleting Existing Files Copying New Files in Place of Existing...

Just posted today, no worries. Internet Explorer is EOL (replaced by Edge for better or worse). Most VB code for a splash screen uses IE objects to display a splash screen picture. Microsoft made some changes to what a script could access (for security reasons). I don't do much scripting so I...