Guide on how to complie MS Access with Run-Time for Distribution 1

[1DMF]

Hi,

Does anyone have a link to a good step-by-step tutorial on how to use the SDK Access run-time for compiling MS Access applications into standalone applications that anyone can run without the need for having Office Professional and MS Access.

Thanks,

1DMF.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[jrbarnett]

There are a few threads on TT about this, but in summary:

1. Develop your application in full MS Access as you would normally.

2. Remember that in the Runtime access the following features are unavailable, so your code has to avoid needing these:
* Form & Report designers
* VBA editor/debugger/immediate window
* Database Window (up to Office 2003)/Navigation Pane (2007+)
* Macro editor

Therefore you have to have a full menu system set to open at database startup, that allows running of your database functionality.
In particular, you need strong error handling as an application crash can't drop you into the debug window when under the runtime.

John

 

[1DMF]

Hi John,

Thanks for the reply.

I currently compile it to an MDE before it gets pushed out to all the DB users, so I think I'm fine on the restricted access thingy.

Any other heads up I need to know?

I have the boss agreed to pay for someone to give me 1/2 day training, do you think this is not neded and the procedure will be pretty painless?



"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[jrbarnett]

What I suggest is that you do as much as you can and try it out on a test PC which only has the runtime installed (a VM is good enough), then if there are issues that you can't resolve, arrange your days training and use your application as an example, but treat it more as consultancy than training.

John

 

[1DMF]

Ok, thanks John.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts