Problems with 2007 Runtime Version

[CEH]

I'm trying to use a few 07 apps at work and having some problems while testing. I loaded the 2007 runtime on my machine, it currently has 2003. I started one app and it was shutting down due to runtime error. Well, it seems to be a very generic error statement, so it doesn't give you a clue as to what is causing the problem!
The first problem was in GetUser function... Found some code on here...changed it from GetUserName =Environ("UserName") to GetUserName = VBA.Environ("UserName") That stopped THAT runtime error..... Now I'm looking at a second app that I posted here
http://www.access-programmers.co.uk/forums/showthread.php?t=181273
Again..... generic.... "Execution of the application has stopped due to runtime error" This app has a lot of code, I have no idea where the error might be... it works perfect in full version of 2007, but runtime error when using the "2007 runtime"
Any ideas what causes these problems?
Thanks

 

[HiTechCoach]

What Access version format are the databases you are running with the 2007 Runtime? Are the complied into mde/accde?

 

[CEH]

No they are not complied. One is in mdb then another....same db just converted to accdb. So by your reply...would converting to accde make a difference?
This is really my first experience at using the runtime version. Would love to get em to work.... Or its rather useless.



Tried converting to mde.... Did the same thing

 

[CEH]

Another edit, and another problem. I was looking around the net and found that not having error handling might cause a problem.... added it to all.. So we'll see.
Second problem. This is a split DB, I add the link to table manager...BUT, when opened in Runtime it is greyed out...

 

[Galaxiom]

... not having error handling might cause a problem.

Yes. Without error hanndling the Runtime simply closes where the full version of Access would report the error.

Second problem. This is a split DB, I add the link to table manager...BUT, when opened in Runtime it is greyed out

In Runtime nothing of the design can be changed by the normal interface techniques since there is no design interface. This includes the linked table management. Changes have to all be done through VBA and cannot be saved.

Incidentally. Make sure you keep an mdb or accdb version of the database. The compiled versions (mde and accde) cannot be modified, as a considerable number of users have discovered the hard way.