access 2007 runtime errors 1

[Grem3]

Hi,

I have developed an app in Access 2007 (which works fine) and have for the first time tried running it using access runtime software.

I am getting many errors - firstly error 3320 "Function is not available in expressions in table-level validation expression.".

Can anybody tell me what the primary differences are between the full version and runtime versions?

Could this be an error related to reference libraries (and if so how do I select them on the runtime version)?

Does anyone know of any useful information on distributing access apps on the runtime version?

Sorry to be such a bore, but I have no idea where to start!

Grem3

 

[lameid]

I have only briefly used Access 2007. I only had a GB of Ram at the time and Office 2007 dogged my system.

However in general...

Can anybody tell me what the primary differences are between the full version and runtime versions?

You can not make design changes through the user interface with the runtime version. You should be able to test by starting Access with the runtime command line switch...

<Path To Access>MSAccess.exe /runtime <path and file name of database>

Could this be an error related to reference libraries (and if so how do I select them on the runtime version)?

Yes. If you set a reference to something that is not an Access component then it could be missing on the target machine. You may be able to inlcude the missing pieces depending on the product you are referencing and licensing limitations (if it is office I SUSPECT it may be allowed with the office developer extensions). In any case do research. To fix a reference problem on a runtime machine, you have to handle it programmatically. I read about it once in the Access Developer's Handbook.

Does anyone know of any useful information on distributing access apps on the runtime version?

Once you have your runtime packaged, you just select a distribution medium... CD, FTP, HTP or whatever makes sense for you.

 

[Grem3]

Thank you for your very useful information!

G3

 

[jmgaddis]

You could also test it on your production machine.

Make a copy of your database, rename it extension to .accdr so would end up something like mydatabasename.accdr

Then launch the file like normal, it will launch in Runtime Mode... this might tell you if the issues you are having are with the other machine or not.

Regarding Runtime in general:

Beware that if update your Production Machine with the latest Office Service Pack 1, then it will not be compatible with the latest Runtime Version... it will not launch at all... My workaround, I have updated my production machine with Service Pack 1... but also have another machine with Access 2007 that hasn't been updated to the Service Pack 1... I open it with that machine and then make my .accde file and copy it out for the others to run with just the Access Runtime on them.

Last I read is that the 2007 Runtime update will not be out until March or later.

Hope this helps.

Thanks,
John

 

[Grem3]

Thanks for the info, John!

G3.

 

[Remou]

You may be interested in:

http://allenbrowne.com/Access2007.html