ActiveX problem

[SDS100UK]

Hi,
I have created a form using a Crystal reports ActiveX control. I tried to open the form on another PC and the activeX is not there!"
What is the procedure to make sure anyone who opens the DB can use the ActiveX control??

TIA

Steven

 

[mvdmeij]

1. Locate the file containing the ActiveX control (filename.ocx, I guess).
2. Create a batch file which:
- Copy the ActiveX component to C:\WINDOWS\SYSTEM of the PC
- Register the ActiveX component
(regsvr32 -s c:\windows\system\<file.ext>
this sets the necessary registry settings, the -s means silent so you will so no notification.
3. Start the database

 

[SDS100UK]

Ok,

Now all I need to kow is how to create a batch file in MS Access

Any clues??

Thanks

Steven

 

[mvdmeij]

I didn't mean you should create a batch file in Access, but just a DOS batch file, something like this

example activex.bat
copy filename.ext c:\windows\system\*.*
regsvr32 -s c:\windows\system\<file.ext>
<path>\msaccess.exe <path>\<database filename>

Hope this helps....