By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,167 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

Help with converting to 2007

100+
P: 443
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
Share this Question
Share on Google+
7 Replies


100+
P: 443
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
Expert 100+
P: 1,356
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

100+
P: 443
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
Expert 100+
P: 1,356
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

100+
P: 443
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
Expert 100+
P: 1,356
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

100+
P: 443
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

Post your reply

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