Hi Frothingslosh
Sorry I didn't get it. As I have never used Batch file and access database together, just can't understand what do I need to do?
Do I need to make any changes in Access database?
What changes need to be made in the batch file if my actual accdb is stored in the following shared folder:
L:\Access Databases\Group Manufacturing\MDB
The users will be using a local copy stored in U:\
Sorry to be a pain but can you please help me in this?
Sorry I didn't get it. As I have never used Batch file and access database together, just can't understand what do I need to do?
Do I need to make any changes in Access database?
What changes need to be made in the batch file if my actual accdb is stored in the following shared folder:
L:\Access Databases\Group Manufacturing\MDB
The users will be using a local copy stored in U:\
Sorry to be a pain but can you please help me in this?
Honestly, man, it's easier to just write up the batch file like I suggested in the first place. I'll even attach an example.
I'd help with the Access version, but I just got handed something this morning with a seriously short deadline and don't really have the time to troubleshoot. Just from the sound of it, though, if you're executing it and getting no result at all, it sounds like it's determining that the front end is current.
My suggestion would be to place a Stop command as the first line in the CheckFrontEnd procedure, and then step through the code as it executes so you can see what's going on. Another option is to use the immediate window to print the value being returned by the procedure so you can see what it's reporting.
I'll try to check the thread when my phone tells me it has replies, but I doubt I'll be able to help much until this evening.
Edit: Helps if I attach the batch file! :banghead: