Discussion Locked

MsAccess97-Distributing Databases

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am using MsAccess 97 Professional on Windows 95/98 PCs.

I have created a Microsoft Access 97 database with a form that contains an ActiveX control on it and when I tried to distribute it to a colleague, the form gave an error as the ActiveX control did not exist on his PC.
1. What can I do to transfer the ActiveX control to his PC; and
2. In the future, how can I see what other files apart from the MDB I would need to transfer to get the database to work properly on another PC?

Thanks

7 replies

by amwalsh

You need to install and register the ActiveX control on your colleagues system. You need to determine the file name of the control, not sure how to do this in Access. In VB when you select the control from the components list the file name is displayed at the bottom. Once you know the file name, copy it to the System32 directory. Go to the start menu and type regsvr32 c:/windows/system32/filename.ext. Make sure you type the correct path for the system32 directory (on 2000 and NT it is c:/Winnt/systeme32 for new intalls). If you receive a dialog with "Succeeded" in the message you should be good. If not there may be dependencies for the control. You may contact me if it doesn't work - mike@countdev.com (make sure to use this address).

Normally I use an installation program for this. I use Wise InstallManager, but I don't think it has the ability to determine what dependencies you need to include for an Access db. You shold search Microsoft's knowledge base at http://msdn.microsoft.com. One of their instllers probably will support Access.

This discussion is closed to new replies.