473,804 Members | 3,855 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Nov 13 '05 #1
5 1544
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=>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

Nov 13 '05 #2
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.

Nov 13 '05 #3
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=>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


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

"ken" <ge****@gmail.c om> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.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=>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?
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
....

THanks

Nov 13 '05 #5
ken
no I was not registering it...that's the problem then!

Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
3084
by: Tom | last post by:
The motivation for references seems clear: stop people from using nasty pointers when all they really want is a reference to an object. But C++ references are so inadequate that I'm still using pointers for my references to objects. There are 3 reasons why I find them inadequate: 1 - Can't be null. 2 - Can't be reseated. Now I'm sure there are good reasons for these first 2, but it's #3 that I
22
2251
by: xmp333 | last post by:
Hi All, I am trying to hide my JavaScript source. The method I chose was to keep all the important source in a password protected folder, and then use a SRC="folder/script.js" to include it in my code. This way, the script will run, but the user will be unable to view the included code. Or so I think :). I have tried this method, and it seems to work. However, I would like
33
2406
by: JKop | last post by:
I understand variables/objects and pointer variables perfectly: int X = 5; int* pX = &X; *pX = 4; int** ppX = &pX:
2
22298
by: S. van Beek | last post by:
Dear reader, For removing a reference in the VBA reference form I receive from Doug Steele the following code: ........... References.Remove refCurr
11
1994
by: codebloatation | last post by:
I know how to use references but i DO not get WHY they exist other than to add to the language. Are they actually needed for anything?
14
2966
by: el_sid | last post by:
Our developers have experienced a problem with updating Web References in Visual Studio.NET 2003. Normally, when a web service class (.asmx) is created, updating the Web Reference will utilise the disco file to update the Corresponding proxy file and reflect the changes made to the web service. However, the results of doing this with out params is that the results seem
30
2498
by: jeremygetsmail | last post by:
I've got an adp (Metrix.adp) with a reference to another adp (InteractSQL.adp). InteractSQL sits on a server, and is refered to by all of the clients (Metrix), which sit on the client machines (There's also a SQL Server that sits on the server, but that's besides the point here.). Both adp files have references to ADOX. I've got to check Metrix has an older version of ADOX, and react appropriately. I've written code to do this, and it...
3
2117
by: DonJefe | last post by:
Does anyone have experience using project->project references in large solutions? What are the plus/minuses that you have found? Currently, we are using the binary assembly references for our code, but this becomes problematic when you want to build from multiple branches/working directories. Any thoughts on this would be appreciated. Thanks
9
2476
by: igor.kulkin | last post by:
References is a relatively basic feature of C++ language. It might be a good thing to think of references as aliases to the variables. However it's good to think of references this way when you deal with references which are local variables. But references can also be function arguments (in fact they are more useful this way) in which case it has to have the in-memory representation.
3
3866
by: CenturionX | last post by:
Hello everybody: I'd like to know what references in my vba code are used or not. I work in a code made by another person previously, i founded to many references and i believe that someones are not used. I'd like to optimize the application ereasing the useless references. Thanks a lot.
0
9577
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10569
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10075
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9140
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7615
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6847
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5519
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
3815
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2990
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.