Hi.
I need to run a function from another database, using:
Dim App as Access.Applicat ion
Set App = CreateObject("C :\LibDB.mde")
App.Run "MyFunc", ...
I use Access2K database format, and I install Access Runtime 2000 or
2002 to the users, along with my application.
The problem can arise when a user already has another Access version
installed on his computer, say Access97. In that case, CreateObject
may attempt to start Access97 and, since the database format is 2000,
will fail.
I've seen some workarounds to this problem, all of them are not very
elegant.
Any help will be appreciated.
2  2582  au************* *@gmail.com wrote:
>I need to run a function from another database, using:
Dim App as Access.Applicat ion
Set App = CreateObject("C :\LibDB.mde")
App.Run "MyFunc", ...
I haven't found a solution to this problem. But I haven't look very hard either.
>I've seen some workarounds to this problem, all of them are not very
elegant.
What work arounds did you find?
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
On Aug 6, 9:15 pm, "Tony Toews [MVP]" <tto...@teluspl anet.netwrote:
auditor.softw.. .@gmail.com wrote:
I need to run a function from another database, using:
Dim App as Access.Applicat ion
Set App = CreateObject("C :\LibDB.mde")
App.Run "MyFunc", ...
I haven't found a solution to this problem. But I haven't look very hard either.
I've seen some workarounds to this problem, all of them are not very
elegant.
What work arounds did you find?
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab. ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/
I found the workaround here: http://www.everythingaccess.com/tuto...OLE-automation
However, the solution there doesn't seem to be 100% robust , as
explained here: http://support.microsoft.com/kb/q238610/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Si |
last post by:
Hi Guys
I am using this code to execute an Access VBA function from ASP:
strDbName = strDataSource & "data\webjobs.mdb"
Set objAccess = Server.CreateObject("Access.Application")
objAccess.Visible = False
objAccess.OpenCurrentDatabase strDbName
objAccess.Run "ASP_SkillSearch", strTable, oUpload.Form("firstname"),
oUpload.Form("surname")
|
by: Jason Burr |
last post by:
I keep getting an Access is denied error using msxml4.dll I have seen a
number of posts on other sites mention it and say they fixed it but not one
says how they did.
Here is the code that I am trying to execute (in jscript).
var objSrvHTTP;
var objXMLSend;
var objXMLReceive;
objSrvHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP.4.0");
|
by: Jenni |
last post by:
Hi, A quick question. I have been battling with this code all morning,
please help.
Here is the code
Dim fPath1 As String
Dim fPath2 As String
fPath1 = "C:\Program Files\Microsoft Office\Office\EXCEL.EXE"
fPath2 = "C:\Documents and Settings\jenniferr\My Documents\Generic
|
by: Ecohouse |
last post by:
I have a computer with XP on it. I loaded Office 97 first because I
needed Access 97 for some work. I then loaded Office 2000.
Everything seemed to be running fine. But I have come across a few
problems.
1) I have hyperlinks in some tables and when I try to access the
hyperlinks I get an error message "An unexpected error has occurred.
2) I've been trying to do some automation through Access for MS Word
using VBA code. I've been...
|
by: Aharon Koss |
last post by:
I wrote a program in microsoft access to send a report via e-mail. The
e-mail works great when I run the computer from a session on my
server. However, when I auto schedule the job to run the access
program fails to send the e-mail. When I check the logs of the server
I get DCOM errors. Does anybody know how to fix this problem? Here's a
copy of the program.
Private Sub YouveGotMail()
Dim TheMessage As String
| | |
by: James |
last post by:
I have a VB windows forms application that accesses a Microsoft Access
database that has been secured using user-level security. The
application is being deployed using No-Touch deployment. The objective
in utilizing this new deployment method is to reduce the maintenance
overhead as well as making it easier for my users to setup and run the
application initially. I have VS 2002, Windows XP, Access XP(2000
format).
He is my problem....
|
by: dkurtz |
last post by:
D. Lesandrini published an article some time ago about exporting Access
reports as XML, and then updating those XML reports dynamically in
..NET.
See->http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnhcvs03/html/vs03g9.asp.
I'm not getting it to work. If I use the XML and XSL file as generated
by Access, it works OK, but if I generate the XML file myself and try
to transform that with the XSL file, I just end up with a...
|
by: venmore |
last post by:
Hi
Can someone please point in the right direction.
I have an XML file that gets updated every 4 hours on a web server.
I can check the XML modification time in ASP and compare to the
databse.
If it is newer, I need some ASP code to then import the XML into
Access.
Been trawling the net for an answer for a while - no joy
thanks
|
by: dima69 |
last post by:
Hi all.
I use a following code to run a procedure in another application:
Dim App as Access.Application
set App = CreateObject("C:\MyApp.mde")
App.Run "MyProc"
...
The problem is that when using CreateObject I cannot determine which version of Access will be started for App.
So if my main application supports Access2K2, and the user has Access2K installed (in addition to Access2K2), CreateObject may return Access2K application - even if...
|
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...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
