I have a split database and am running into a problem. One of my forms has a date picker activex control on it, and on my computer everything works fine. But, i copied the front end from the server to the user's desktop, and when he tried to open it gave me an error saying that there was a broken reference. The reference was to Microsoft common controls 2 6.0 (SP4). After doing some research I tried to copy and paste new mscomct2.ocx and mscomct2.inf files into the system32 folder. It seemed to work.
The problem is that this is in an office and you need admin access to be able to copy files into the system32 folder.
I have a batch file that runs on startup so that whenever the user logs in, it deletes the copy of the database that the user has on their desktop, copies the front end from the server, and pastes it to the desktop again. This way, whatever changes I may make throughout the day, by the next day they will have access to the newest version.
This has worked fine up until now.
It would be asenine to have to go in every day and have out IT guy copy those files every day. I don't understand why simply copying the database off of the server onto the desktop would reset it in this way.
For example. One user had the database working fine. I just made an update to the database so I had him delete the copy on his desktop and copy the file from the server to his desktop. All of a sudden he started getting the broken reference error again.
And now if I try to run regsvr32 mscomc2.ocx, that gives me an error as well.
I would like to find a solution to this problem but more and more it's looking like I'm going to just have to replace that activex control with a common textbox. It's not how I would want the form to be made, but if I can't get some sort of a solution to this weird problem then that is going to be what I have to do.
Any help would be greatly appreciated.
Thanks