Tricky to explain,
I have 4 or 5 front ends connected to a BE on the same LAN.
They have the same name.
I might be over complicating this but ideally would like to be able to identify each front end.
FrontEnds are on C:\Documents etc. etc. not the same location Pc to PC
e.g. pressing a button on ..
FrontEndA will copy a file to D:\MainPC\AccessBackups
FrontEndB will copy a file to D:\OfficePC\Backups
Also stuff like what printer to use.
As FrontEndA & B have the same name, cannot see, in VBA, a way to know which PC & FrontEnd is being used.
Now, I could give them all a different name, have a table with all the information I manually enter, not too keen for some reason.
Although don't do often, I might add another FE PC into the system & perhaps take one out.
Each FE will always have a shared folder on a local drive that I backup & store other data into. I do have this recorded in a table.
My first thoughts were, if I can see what the local share is I could use that but not sure there is a way to find out what the local share/PC is?
As above
\\MainPC\AccessBackups
\\OfficePC\Backups
Any idea's?
I think I might be over engineering this
I have 4 or 5 front ends connected to a BE on the same LAN.
They have the same name.
I might be over complicating this but ideally would like to be able to identify each front end.
FrontEnds are on C:\Documents etc. etc. not the same location Pc to PC
e.g. pressing a button on ..
FrontEndA will copy a file to D:\MainPC\AccessBackups
FrontEndB will copy a file to D:\OfficePC\Backups
Also stuff like what printer to use.
As FrontEndA & B have the same name, cannot see, in VBA, a way to know which PC & FrontEnd is being used.
Now, I could give them all a different name, have a table with all the information I manually enter, not too keen for some reason.
Although don't do often, I might add another FE PC into the system & perhaps take one out.
Each FE will always have a shared folder on a local drive that I backup & store other data into. I do have this recorded in a table.
My first thoughts were, if I can see what the local share is I could use that but not sure there is a way to find out what the local share/PC is?
As above
\\MainPC\AccessBackups
\\OfficePC\Backups
Any idea's?
I think I might be over engineering this