Have had a runtime installation up for 4 months. Upgraded
today with new ver 0.07 from 0.06. On launch, error reported...
Err in fn Initialize, module AutoExec, function isnt available in
query expression ... 'UCase([SerialNum])
This expression has been in all rev's of the app for 4 months.
I did not touch the runtime executable today. I merely copied
a new mde to the app dir. Got this error launching twice (am
launching remotely, not sitting at the console). Suspicions? 12 3888
If the version of any referenced library on either machine has changed,
sometimes a database created on one machine won't work on the other. Usually,
you can fix this by installing windows updates on the failing machine or by
removing and recreating the reference on the failing machine, then using that
as the new master copy.
More than half the time when this happens, if you open the VB Editor on the
failing machine, and go to Tools -> References, one of them will say MISSING.
You need to remove that reference, close the References window, reopen the
window, and re-add the reference that was removed.
One really counterintuitive aspect to all of this is that if -any- reference
is broken, -none- of the references work.
On Wed, 14 Sep 2005 02:01:22 -0400, MLH <CR**@NorthState.net> wrote: Have had a runtime installation up for 4 months. Upgraded today with new ver 0.07 from 0.06. On launch, error reported...
Err in fn Initialize, module AutoExec, function isnt available in query expression ... 'UCase([SerialNum])
This expression has been in all rev's of the app for 4 months. I did not touch the runtime executable today. I merely copied a new mde to the app dir. Got this error launching twice (am launching remotely, not sitting at the console). Suspicions?
Thx, Steve. I'll have to go to the client's business, install Access
and open the VB Editor, giving your theory a test. Last night, I
remotely logged in, copied the most recent earlier app rev (0.06)
back into the app dir and launched - the problem does NOT occur
when it is run. I cannot think of anything I added during build of
rev 0.07 that resulted in the inclusion of an additional reference,
but you never know. I have been having some super strange
problems in my dev copy of 0.07 here - that's for sure. Have a look
at my recent post entitled...
"A97 closes down each time I open a particular report"
....and you'll see what I mean. If the version of any referenced library on either machine has changed, sometimes a database created on one machine won't work on the other.
That's a bummer, huh? Users can cause this to happen without realizing
that it may cause something else on their machine not to work (IE, my
app!%$*&!!!). In your experience, is this a common occurrence?
Usually, you can fix this by installing windows updates on the failing machine or by removing and recreating the reference on the failing machine, then using that as the new master copy.
More than half the time when this happens, if you open the VB Editor on the failing machine, and go to Tools -> References, one of them will say MISSING. You need to remove that reference, close the References window, reopen the window, and re-add the reference that was removed.
One really counterintuitive aspect to all of this is that if -any- reference is broken, -none- of the references work.
On Wed, 14 Sep 2005 02:01:22 -0400, MLH <CR**@NorthState.net> wrote:
Have had a runtime installation up for 4 months. Upgraded today with new ver 0.07 from 0.06. On launch, error reported...
Err in fn Initialize, module AutoExec, function isnt available in query expression ... 'UCase([SerialNum])
This expression has been in all rev's of the app for 4 months. I did not touch the runtime executable today. I merely copied a new mde to the app dir. Got this error launching twice (am launching remotely, not sitting at the console). Suspicions?
I did this on my development box. Here are the available references
I found there...
Visual Basic For Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library
Microsoft Calendar Control 8.0
driveList ActiveX Control module
Microsoft Windows Common Controls-2...
MMFWCtrl ActiveX Control module
The first 4, I believe I need. Am unsure about the next 2. But the
last one - honestly, I have no idea how it got there. Apparently its
located in c:\program files\musicmatch\musicmatch jukebox\mmfwctrl.ocx
Directory of c:\program files\musicmatch\musicmatch jukebox
02/10/2003 12:38 AM 81,920 MMFWCtrl.ocx
1 File(s) 81,920 bytes
0 Dir(s) 8,335,253,504 bytes free
Is it trash? I should uncheck it from my references, right?
Oh, and BTW...
The girl got in this morning and started running the app - UCase is
not the only built-in command that's failing. Others are occurring it
seems.
On Wed, 14 Sep 2005 09:31:22 -0400, MLH <CR**@NorthState.net> wrote: I did this on my development box. Here are the available references I found there...
Visual Basic For Applications Microsoft Access 8.0 Object Library Microsoft DAO 3.51 Object Library Microsoft Calendar Control 8.0 driveList ActiveX Control module Microsoft Windows Common Controls-2... MMFWCtrl ActiveX Control module
The first 4, I believe I need. Am unsure about the next 2. But the last one - honestly, I have no idea how it got there. Apparently its located in c:\program files\musicmatch\musicmatch jukebox\mmfwctrl.ocx Directory of c:\program files\musicmatch\musicmatch jukebox
02/10/2003 12:38 AM 81,920 MMFWCtrl.ocx 1 File(s) 81,920 bytes 0 Dir(s) 8,335,253,504 bytes free
Is it trash? I should uncheck it from my references, right?
Yup. It's a safe bet that's your problem reference.
On Wed, 14 Sep 2005 09:33:11 -0400, MLH <CR**@NorthState.net> wrote: Oh, and BTW...
The girl got in this morning and started running the app - UCase is not the only built-in command that's failing. Others are occurring it seems.
That's normal. As I said, if one reference is broken, all references fail to
work. When that happens, your app is basically useless until you fix the
broken reference.
MLH <CR**@NorthState.net> wrote in
news:f4********************************@4ax.com: I did this on my development box. Here are the available references I found there...
Visual Basic For Applications Microsoft Access 8.0 Object Library Microsoft DAO 3.51 Object Library Microsoft Calendar Control 8.0 driveList ActiveX Control module Microsoft Windows Common Controls-2... MMFWCtrl ActiveX Control module
The first 4, I believe I need. Am unsure about the next 2. But the last one - honestly, I have no idea how it got there. Apparently its located in c:\program files\musicmatch\musicmatch jukebox\mmfwctrl.ocx Directory of c:\program files\musicmatch\musicmatch jukebox
02/10/2003 12:38 AM 81,920 MMFWCtrl.ocx 1 File(s) 81,920 bytes 0 Dir(s) 8,335,253,504 bytes free
Is it trash? I should uncheck it from my references, right?
Well, uncheck it and see if your application works.
If it doesn't, you need it.
The only three that every Access 97 MDB should have are the first
three. Everything else you should have *only* if you are using that
library.
I would definitely recommend getting rid of any dependencies on the
Windows Common Controls, because MS dicks around with that library
so much that it is not cross-compatible between many versions, and
you have little control over which version will be installed on a
target machine. It also provides nothing that can't be done through
plain old Windows API calls, which never fail (and require no
references).
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Good. Hopefully getting to the bottom of this. I have the
8 references listed below that are checked on my development
box. The target client machine has ONLY the first three. David
Fenton indicated that I need the first three. I do use the MS calendar
control in the app, so I think it too is needed. I'll uncheck the
others on my DEV box and see if the app still runs on the DEV
box. On the target client box (where the app is SUPPOSED to
run), is it necessary that I open the app itself, then the VBA editor
on one of the modules to look at the references? Or, can I simply
start A97 on the client PC, open ANY mdb and check them there?
The reason I ask is because I normally deliver only MDE to client
and I'm unable, of course, to open the VBA editor on the MDE file.
Visual Basic For Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library
Microsoft Calendar Control 8.0
driveList ActiveX Control module
Microsoft Windows Common Controls-2...
MMFWCtrl ActiveX Control module
You were EXACTLY right. Problem went away. Yup. It's a safe bet that's your problem reference.
>Well, uncheck it and see if your application works.
Did so. App worked. Left 'em unchecked. If it doesn't, you need it.
The only three that every Access 97 MDB should have are the first three. Everything else you should have *only* if you are using that library.
I trashed 'em all but the Calender OCX I would definitely recommend getting rid of any dependencies on the Windows Common Controls, because MS dicks around with that library so much that it is not cross-compatible between many versions, and you have little control over which version will be installed on a target machine. It also provides nothing that can't be done through plain old Windows API calls, which never fail (and require no references).
Done. Couldn't agree more.
MLH <CR**@NorthState.net> wrote in
news:cd********************************@4ax.com: The reason I ask is because I normally deliver only MDE to client and I'm unable, of course, to open the VBA editor on the MDE file.
If I'm not mistaken, you can't change references in an MDE at all.
That might be the source of your problem, actually.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
All is well now. Did the trick. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: George W. Jackson |
last post by:
Hi to all.
We have a Microsoft Access 2002 database that is referencing the
ADO 2.5 library (as well as the DAO 3.6 library). On the development
machine, the database works exactly as planned...
|
by: wolftor |
last post by:
1) Is there a free runtime version of Access available that is more recent
than the one for Access 2000?
2) If I create an application (MDE) in A2K, will it run on all later
versions of Access?...
|
by: MLH |
last post by:
I have little or no knowledge as to how a runtime Access database
application might be distributed from a website. I am sure that I'm
about to find out. I do have one question for you wizards...
|
by: Philippe PERON |
last post by:
Hello,
An ACCESS application (mde) is installed on a computer looking at an
mdb file on the same machine.
As far as I know the application is installed thru a Wise Installer
script. The...
|
by: Aliza Klein |
last post by:
Apologies in advance as I am SURE this has been asked 100 times - but I
haven't got a simple answer:
I have MS Office XP Developer and have created an installation package (with
the runtime) for...
|
by: MLH |
last post by:
If I give someone a runtime app,
they can open the database
window by pressing the F-11
key. How to prevent???
|
by: shawno |
last post by:
I'm relatively new to DB2 and have noticed a problem with my queries
when doing a like with ucase.
Since queries need to be case insensitive, I have to do a ucase on the
column(s) being searched...
|
by: Norman Diamond |
last post by:
A project depends on VC runtime from Visual Studio 2005 SP1, and DotNet
Framework 2. Options are set in the setup project properties, so if these
two dependencies are not already installed then...
|
by: Peter Van Peborgh |
last post by:
I have an app that is built in Access 2002 and packaged with its runtime. When installing it in a Vista PC/laptop, several dialog boxes pop up that require specific answers for the app to install and...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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,...
|
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...
|
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...
| |