references

[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

[ken]

Re: references

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=>referenc es 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

[pietlinden@hotmail.com]

Re: references

you could do something like

use this to get the full path (if you need it)
Application.Cur rentProject.Pat h

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.AddF romFile "C:\WINNT\syste m32\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.

[Rick Brandt]

Re: references

ken wrote:[color=blue]
> 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=>referenc es 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[/color]

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

[Scott McDaniel]

Re: references


"ken" <gevayl@gmail.c om> wrote in message
news:1121962500 .793808.246010@ f14g2000cwb.goo glegroups.com.. .[color=blue]
> 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=>referenc es 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?[/color]

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\s omefile.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
....
[color=blue]
>
> THanks
>[/color]

[ken]

Re: references

no I was not registering it...that's the problem then!