473,320 Members | 2,027 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Mscomctl.ocx in runtime app

Hi

I have a large access application, it registers information on
funerals. And this is sold on as runtime apps to other customers. One
of my customers got new pcs recently, and now certain errors occured -
i.e. the time() function doesn't work. I think the problem is with the
ocx-file, even though the customer has the correct version and all.

I can provoke the error on my machine by copying the application (mdb-
file) to another computer, then the same errors occur, the errors are
for instance that the time() function won't work, also problems with
the format-function. I guess it's part of the mscomctl.ocx library.
What I need to do on my machine to get it to work is unregister the
file in references (visual basic - unhook and click ok), then go in
again and browse, select the same file so it gets added under
references again. Now everything works fine.

But I can't do the same at the customer, because he has the runtime
app without access. Any ideas what is wrong and how I can fix it? I've
developed it in access 2003, using VB6.3. I've tried unregister the
file with regsvr32.ocx, then register it again, but that doesn't work.
And I've tried using the old comctl32.ocx-file.

thank you

Vegard

Jun 2 '07 #1
2 4701
On Sat, 02 Jun 2007 06:31:40 -0700, Veggis <ve******@gmail.comwrote:

Your symptoms are classic broken reference. See
http://www.mvps.org/access/bugs/bugs0001.htm, and bookmark that site.

Don't guess. At startup time iterate over the References collection,
looking for IsBroken. Use fully qualified function names (e.g.
VBA.Left$ rather than Left$) so your code will work even if there is a
broken reference. Then report which one is missing, and exit
application.

-Tom.

>Hi

I have a large access application, it registers information on
funerals. And this is sold on as runtime apps to other customers. One
of my customers got new pcs recently, and now certain errors occured -
i.e. the time() function doesn't work. I think the problem is with the
ocx-file, even though the customer has the correct version and all.

I can provoke the error on my machine by copying the application (mdb-
file) to another computer, then the same errors occur, the errors are
for instance that the time() function won't work, also problems with
the format-function. I guess it's part of the mscomctl.ocx library.
What I need to do on my machine to get it to work is unregister the
file in references (visual basic - unhook and click ok), then go in
again and browse, select the same file so it gets added under
references again. Now everything works fine.

But I can't do the same at the customer, because he has the runtime
app without access. Any ideas what is wrong and how I can fix it? I've
developed it in access 2003, using VB6.3. I've tried unregister the
file with regsvr32.ocx, then register it again, but that doesn't work.
And I've tried using the old comctl32.ocx-file.

thank you

Vegard
Jun 2 '07 #2
I will try that. Thanks a lot for the effort!
On 2 Jun, 22:34, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Sat, 02 Jun 2007 06:31:40 -0700, Veggis <vegar...@gmail.comwrote:

Your symptoms are classic broken reference. Seehttp://www.mvps.org/access/bugs/bugs0001.htm, and bookmark that site.

Don't guess. At startup time iterate over the References collection,
looking for IsBroken. Use fully qualified function names (e.g.
VBA.Left$ rather than Left$) so your code will work even if there is a
broken reference. Then report which one is missing, and exit
application.

-Tom.
Hi
I have a large access application, it registers information on
funerals. And this is sold on as runtime apps to other customers. One
of my customers got new pcs recently, and now certain errors occured -
i.e. the time() function doesn't work. I think the problem is with the
ocx-file, even though the customer has the correct version and all.
I can provoke the error on my machine by copying the application (mdb-
file) to another computer, then the same errors occur, the errors are
for instance that the time() function won't work, also problems with
the format-function. I guess it's part of the mscomctl.ocx library.
What I need to do on my machine to get it to work is unregister the
file in references (visual basic - unhook and click ok), then go in
again and browse, select the same file so it gets added under
references again. Now everything works fine.
But I can't do the same at the customer, because he has the runtime
app without access. Any ideas what is wrong and how I can fix it? I've
developed it in access 2003, using VB6.3. I've tried unregister the
file with regsvr32.ocx, then register it again, but that doesn't work.
And I've tried using the old comctl32.ocx-file.
thank you
Vegard

Jun 6 '07 #3

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

Similar topics

0
by: Randy Birch | last post by:
re: MSComCtl Listview control cashes after installing VB6/VS6 SP6 I have been advised that this problem has been reproduced and a hotfix has been prepared. The supporting KB article and hotfix...
2
by: Randy Birch | last post by:
Reposted as the original is reported as deleted from the server. re: MSComCtl Listview control cashes after installing VB6/VS6 SP6 I have been advised that this problem has been reproduced...
10
by: Lauren Wilson | last post by:
Ok I have searched the MS website for info on this. I am totally confused. If I want to deploy an Access 2003 app and allow my users to run it using Access 2003 Runtime, where do I get the...
10
by: MLH | last post by:
I am concerned. I have recently moved to A97 from Access 2.0 where I rolled out runtime apps with the ADT. Now, the Office Pro Developer's Edition with Access 97 is what I'm using. I find some...
17
by: Owen Jenkins | last post by:
I have an Access application that is being used by 150+ clients. I develop in 97, convert to 2000 and distribute as a 97 or 2000 mde, or 97 runtime. This limits me to 97 functions. My clients may...
8
by: Subra Mallampalli | last post by:
Hi, I am trying to use <runtime> section within the web.config file. However, the contents of the <runtime> section seem to be ignored. What am i missing here? Is <runtime> section not used by...
16
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???
3
by: =?Utf-8?B?R3JhaGFt?= | last post by:
I've added 2 tracking services to the wf runtime; one is the standard SqlTrackingService: trackingService = new SqlTrackingService(<trackingConnectionString>); <workflow...
6
by: SMcK | last post by:
I have a PDA-based (Syware Visual CE) database which I need to sync to an Access database. The Access database contains three tables: 1 is the data itself, 2 is a linked table that prefills...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.