Worked in access...fails with runtime

E

Ed

I have created a app that works fine when running under "full access"

When I create a distributable package using the developer extensions,
(runtime, etc), I get an error ...
"function is not available in expressions in table level validation
expression"

Any guesses what caused this?
 
A

Albert D.Kallal

Hard to tell, but I would assume you "test" your application.

You can make a shortcut with the /runtime switch on your regular mdb, or mde
file.

This allows you to "test" what things will look, and run like BEFORE you go
to all that trouble to build a package just to test.

If the error don't occur on your machine..then possilbe broken ref here...
 
E

Ed

OK, tried it re shortcut with /runtime (neat to iknwo btw)...everything
worked fine.

Anything else to check that you can suggest..."broken ref" where...in the
build or in the other machine.

Thx for all the help!
 
A

Albert D.Kallal

The first trick in broken refs to make sure that you REMOVE any possible
reference you don't need.

So, any reference to outlook, excel, word etc. needs to be removed. You need
to use late binding..

Either setup a test mule box, or even better setup a virtual pc. You need to
be able to test a install, then wipe that install complete free as if your
install never happened...so you can test again and again. Either setup a
Norton ghost (the old way), or get your hands on virtual pc.

The Microsoft team has 80 FULL TIME people just to work on, and setup the
install for JUST excel.

My point here is that you really need to put together some SERIOUS resources
here to test your deployment of your application. If you don't, you will
spend MORE on support and troubleshoots then the cost of your software!!!

So, broken refs needs to be checked first....

Allen Browne
http://allenbrowne.com/ser-38.html

Doug Steele:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Peter Walker:
http://www.papwalker.com/dllhell/index-page2.html


MsKb Articles: 310803, 208218, 209849, 286300

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/default.aspx?scid=kb;en-us;248941

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;310803
 
Top