Is it this easy?

[67flyer]

Is this correct?

microsoft DAO 3.6 object library and other references go with the database?

I thought they were machine specific. thats why I have never coded using them. I though I would have to setup each machines access program that wanted to use the db with them.

But I have a sample db that i dl that has them listed and it works. When i copy and paste some of the code into my db it don't work because i don't have the DAO selected in the references.

Is it so?

Thanks,

 

[Bodisathva]

The references selected in your database will still be there when you open that database on another PC. Whether or not PC2 will be able to use them depends upon the existing .dlls on that machine. For example, if you use the Animation control in one of your forms, you must not only make reference to the Common Controls library but you must also have the MSComCtl2.OCX file located on the machine (and registered).

 

[67flyer]

How would you know which common controls require the files? Can it be assumed that if you didn't add any special files to your machine, it should work on pc2, and if pc2 is assumed to have a standard load of office. I don't want to use anything extra that would require administrative rights on pc2 to install. Would having to register the files need administrative rights?

 

[Bodisathva]

You don't need administrative rights to add the references or copy the files, but you do need administrative rights to register the files. You can get around this by using the API calls to register the files, though.

For the most part, you can assume that if your company uses a standard installation that the PCs should all have the same libraries. Where you have trouble (at least we do) is when you have a mixture of Win 2K & XP, Office Pro with and without the developer extensions, with and without Visual Studio .NET. In that type of scenario you basically hope for the best and handle the errors when they occur.

 

[67flyer]

Thanks for the info! Should help some now.