Acces runtime

[Guest]

Hello

As a newbie in database i would like to get som help, I have made a database
that I would like to use on a PC with Access runtime.
Access runtime asks if I would open the database but nithing happens after i
have clicked yes.
What am I doing wrong ??
Kind Regards
JP Sørensen

 

[Rick Brandt]

Hello

As a newbie in database i would like to get som help, I have made a
database that I would like to use on a PC with Access runtime.
Access runtime asks if I would open the database but nithing happens
after i have clicked yes.
What am I doing wrong ??
Kind Regards
JP Sørensen

What do you think should happen? Have you defined a startup form or created a
custom main menu? The Runtime provides none of the default Access interface so
unless you provide something yourself you will just get a gray screen when you
open a file.

 

[Guest]

As I wrote this is new stuff to me, no I have done nothing of the things you
asked me about.
Do you know where I can find any help regarding how to make a database ready
for access runtime ?

"Rick Brandt" skrev:

 

[Rick Brandt]

As I wrote this is new stuff to me, no I have done nothing of the
things you asked me about.
Do you know where I can find any help regarding how to make a
database ready for access runtime ?

If you own the developer's tools that allow you to create and distribute runtime
packages then you have the help files that explain all this stuff. In the
developer's tools for Access 97 there was an entire help topic or paper included
that described all of the differences between the runtime environment and the
normal environment. I assume the newer versions still have this. Otherwise you
could search on Micorsoft's web site.

For starters, open your file in a licensed copy of Access and look at "Tools -
Startup". Those options allow you to specify a main menu and a form to
automatically be displayed when the file is opened. You have to basically
provide methods to get at all of the objects in the file without using the db
window.

You also need very robust error handling which means macros should be avoided.
In the runtime non-handled errors will generally just cause the app to
terminate.

 

[Albert D.Kallal]

As I wrote this is new stuff to me, no I have done nothing of the things
you
asked me about.
Do you know where I can find any help regarding how to make a database
ready
for access runtime ?

I have a example application that would work well with the runtime. Grab a
copy to play with here:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

(grab the 3rd one ..."ms-access interface hidden")

The above example hides all of the ms-access interface (you just have to use
the tools->startup to hide ms-access). Since you are using the runtime, then
your users will not have had ms-access training, and likely not know a lot
about ms-access (so, as a general rule, you kind of need to hide the
ms-access stuff anyway). It turns out that the a2003 runtime does provide
some default menus...so if you have a startup form set, then that might be
all you need.

In addition to playing with my above example, there is two good articles on
the runtime and use here:

http://msdn.microsoft.com/library/d.../odc_ac2003_ta/html/odc_acbasicsofruntime.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;842004