Hi
I've got an Access database split front-end and back-end over a network, with potentially 50 users though the max at one time doesn't exceed about 5.
I want to distribute the front-end locally as an MDE file, to prevent user modifications and cut down on network traffic. I am, however, making updates and adding new functionality to it on a daily basis.
So what I want is for users to automatically copy the latest front-end version as an MDE locally and run that.
I think I need to create a dummy database with an autoexec that makes an MDE of the latest version of the front-end on the network onto a local drive, then run the new MDE file and finally close itself down.
The MS knowldegebase example uses SendKeys which terribly reliable apparently and as it stands currently doesn't work for me...
Does anyone have a good solution to this?
Thanx in advance
I've got an Access database split front-end and back-end over a network, with potentially 50 users though the max at one time doesn't exceed about 5.
I want to distribute the front-end locally as an MDE file, to prevent user modifications and cut down on network traffic. I am, however, making updates and adding new functionality to it on a daily basis.
So what I want is for users to automatically copy the latest front-end version as an MDE locally and run that.
I think I need to create a dummy database with an autoexec that makes an MDE of the latest version of the front-end on the network onto a local drive, then run the new MDE file and finally close itself down.
The MS knowldegebase example uses SendKeys which terribly reliable apparently and as it stands currently doesn't work for me...
Does anyone have a good solution to this?
Thanx in advance