CPGDeveloper
Board Regular
- Joined
- Oct 8, 2008
- Messages
- 189
I have an MS Access Based DB, which has a dozen or so users. The database is split, each user has an executable .accde front end on their respective desktops. The Back End is on a shared Network drive.
I've written a function that searches several pre-determined folders for text files, and then uploads the data in those files into the db. It does this on a timer -- every hour during business hours.
For this to work, I have to choose a user where this function executes. Using a 'getusername' function (getUserName = Environ("USERNAME")), the db determines the windows login id of the user, and I have my upload function kick off only for a specific user.
I do this because if I don't, the upload will potentially kick off for all dozen users, causing duplication and/or multiple errors.
The problem is if this user isn't in the office one day, this process will obviously not run.
Is there a way to determine , at the moment of upload, the windows login of everyone using the db, so then I can choose which user? Or perhaps there's another way to accomplish a data upload on a timer?
I've written a function that searches several pre-determined folders for text files, and then uploads the data in those files into the db. It does this on a timer -- every hour during business hours.
For this to work, I have to choose a user where this function executes. Using a 'getusername' function (getUserName = Environ("USERNAME")), the db determines the windows login id of the user, and I have my upload function kick off only for a specific user.
I do this because if I don't, the upload will potentially kick off for all dozen users, causing duplication and/or multiple errors.
The problem is if this user isn't in the office one day, this process will obviously not run.
Is there a way to determine , at the moment of upload, the windows login of everyone using the db, so then I can choose which user? Or perhaps there's another way to accomplish a data upload on a timer?