By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,948 Members | 1,857 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,948 IT Pros & Developers. It's quick & easy.

references

P: n/a
ken
Hi,
I'm using a reference dll file for my database. Its FEBE so the front
ends need to have the reference. How can I have the front end
automatically detect the reference if its in the same directory as the
database?

or can this be done?

Otherwise how do people work with references and front ends...

thanks

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
ken
people I need help...is there a way to permanantly embed a reference
file to the database? I use a dll file and when ever I put it on
another computer it freaks...and I'm pretty sure its the dll file. Its
like the reference link gets broken. The only way I know to manipulate
references is through the tools=>references menu in the VBA code
window. Is there a way I could check if a reference is assigned and if
its not reassign it with VBA code?

THanks

Nov 13 '05 #2

P: n/a
you could do something like

use this to get the full path (if you need it)
Application.CurrentProject.Path

and then you can do this:

Example
As it applies to the References object.

The following example adds a reference to the Microsoft Scripting
Runtime library.

References.AddFromFile "C:\WINNT\system32\scrrun.dll"

just use On Error Resume Next so that if the library is already
registered, the app will just keep gong. Stick that in your app's
startup routine and you should be good to go.

Nov 13 '05 #3

P: n/a
ken wrote:
people I need help...is there a way to permanantly embed a reference
file to the database? I use a dll file and when ever I put it on
another computer it freaks...and I'm pretty sure its the dll file. Its
like the reference link gets broken. The only way I know to manipulate
references is through the tools=>references menu in the VBA code
window. Is there a way I could check if a reference is assigned and if
its not reassign it with VBA code?

THanks


Are you putting the dll on the other computer and registering it?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #4

P: n/a

"ken" <ge****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
people I need help...is there a way to permanantly embed a reference
file to the database? I use a dll file and when ever I put it on
another computer it freaks...and I'm pretty sure its the dll file. Its
like the reference link gets broken. The only way I know to manipulate
references is through the tools=>references menu in the VBA code
window. Is there a way I could check if a reference is assigned and if
its not reassign it with VBA code?
As Rick said, you must install and register the DLL on the enduser machine.
You can do it via a batch file ... just copy the DLL to your program
directory, along with a batch file that does something like this;

@echo off
regsvr32 "c:\program files\somedir\somefile.dll"

This would register it .. you'd have to change the path to match that of the
enduser machine, of course.

An alternative would be to use an installer to do this ... Inno setup is
free and can install and register DLL files for you, along with installing
your db on the enduser machine, build shortcuts, etc etc ...
http://www.jrsoftware.org/isinfo.php

If you have properly installed and registered the DLL on the enduser machine
and you still have a problem with the reference, then that's another matter
....

THanks

Nov 13 '05 #5

P: n/a
ken
no I was not registering it...that's the problem then!

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.