473,289 Members | 1,842 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,289 software developers and data experts.

Help with converting to 2007

489 256MB
I'm trying to port my application to 2007 and am having a problem with the runtime. Here's what I've done and what's happening. I can open and run my .mdb with out any problem even without converting to 2007. I've made some changes to a couple of forms and everything works fine on the developement machine. I've compiled the application and the .mde works great on the developement machine. I then use the 2007 package wizard and add all components that go with the program. Burn the package to a CD and install it along with the 2007 runtime onto a test machine. When I run the program it gives me this error "Activex Component can't create Object" and the program closes. I've doubled checked all components and can't find what's missing. I've tried adding conponents that I think might be needed but nothing works. I've been working on this for three days and it's driving me crazy, I'm pulling my hair out and there isn't much left. Is there any way to find out what's missing? I've copied the .mdb onto the test machine and have tried running it with the runtime and get the same results. Please if anyone has some suggestions I would greatly appreciate it.

Thanks
Oct 15 '09 #1
7 1550
CD Tom
489 256MB
I've installed Access onto the test machine and now I open the .mdb application and get this error "The Expression on open you entered as the event property settings product the following error. Object or Class does not support the set of events". I've gone into the program and have set a stop on the open event, the activate, the load but the program will not stop at any of these places so I can find out what event the error is talking about. What else can I try???
Oct 15 '09 #2
Denburt
1,356 Expert 1GB
The first thing that comes to my mind would be to check the references in VBA to ensure that nothing checked in there is marked as missing. Then I would compile the project and see if that causes an error.
Oct 15 '09 #3
CD Tom
489 256MB
I've looked at the references and everything is ok, I've also ran the compile and don't get any errors. What else would you suggest.
Oct 15 '09 #4
Denburt
1,356 Expert 1GB
Here is a Microsoft article on some of the possible reasons for receiving the following error "Activex Component can't create Object"

http://support.microsoft.com/kb/319844
Oct 15 '09 #5
CD Tom
489 256MB
I've checked everything that the article says and can find not problems. I'm at a complete loss. The only machine that the application runs on is the development machine which is Windows 7 and everything works great. My test machines are Vista and Windows 7. I've set the UAC off on both machines thinking that maybe there was a premissions problem. I have an XP machine that I might try it on and see what happens.
Oct 15 '09 #6
Denburt
1,356 Expert 1GB
The only other thing I can think it might be is possibly the arrangements of the references. I am not sure why but it has happened on an occasion where I had to change the order of the references to correct an issue or two. Beyond that I am at a loss. Is this a large database you are working with? Maybe you can take the startUp form and import that into a new database and see if it runs...
Oct 16 '09 #7
CD Tom
489 256MB
I've just found out the problem. I've been using a program called lslook.dll, it is used to prevent the program from being loaded onto other computers. Each computer requires a seperate subscription key. The lslook.dll has always worked but for some reason it didn't work in access 2007. I'm going to have to find another way to protect the program from copied.
The way this worked was at startup it would check the registry and see if the codes were correct and if not the program wouldn't run.
Do you know any copywrite program that doesn't cost a arm and a leg? Thanks for your help.
Oct 16 '09 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

32
by: robert d via AccessMonster.com | last post by:
I'm looking at converting DAO to ADO in my app. All of my DAO connections are of the following structure: Dim wsName As DAO.Workspace Dim dbName As DAO.Database Dim rsName As DAO.Recordset ...
0
by: rickcross | last post by:
I am converting a 2002-2003 program over to 2007.In looking up the idmso value for the Home Tab I have so far come up with a blank. All the commands I can change and access but the example leads...
11
by: Dirntknow | last post by:
Further to my recent post in this newsgroup i've got to admit i'm struggling. I've no experience with javascript or it's workings. What i'd like is a simple converter to allow a user to input the...
4
by: Yasin Cepeci | last post by:
I ve get float data from serial port. I ve taken it in the form of hex by modbus protocol. I know it is float but I couldnt convert it there is a few sample data below; B3 33 43 34 = 180.699997...
8
by: saladinator | last post by:
I have created an Excel spreadsheet that has a lot of data. What I want to do is import the spreedsheet to Access and create a form so that I can print each row per page in a proffessional manner....
2
by: =?Utf-8?B?Vmlua2k=?= | last post by:
Is it possible to convert a microsoft word document to pdf in .net code. If anyone has done this before, please let me know.
3
by: VUNETdotUS | last post by:
How can I parse RFC822 date format Sat, 13 Oct 2007 22:09:03 PDT to MM/ DD/YYYY? Any reference you can recommend? Thanks
3
by: Shivakumar | last post by:
Dear Friends, I want to show columns into rows. For example, I have a table, TIMESHEET, with the following structure: CREATE TABLE TIMESHEET ( EMPNO CHAR(3), WEEKEND_DATE DATE,...
1
by: jrod11 | last post by:
Hi everyone, I am currently working on a project that pulls data from sql and displays it in an html file. This is working fine, but I am trying to make it a little more fancy using this cool source...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
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: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
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)...

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.