Working in Access RunTime

  • Thread starter Thread starter Mota
  • Start date Start date
M

Mota

Hi;
I packaged my DB including Access Run time files to open it in a RunTime
mode.However,if the target computer has the Access program,my installed DB
will open in a normal mode and all codes and design views will be available
to the user(its shortcut in Star>Programs points to and opens the DB in a
normal way).Do anyone knows in this cases how to by pass the main Access
from the user computer and be sure that my program will be opened in Run
Time mode of Access,and all my codes and form designs will be protected?
Thank you in advance.
 
Well, likely if you reached the point of distr ution your application, then
you no doubt long ago built your own custom menus, and hid the ms-access
interface. Thus..usually by the time you get around to using the
runtime..you have already proved your own menu bars etc. Thus, when you
launch your application, using runtime, or full will NOT change how your
application runs, or looks.

However, you can provide a shortcut to your application..and use the
/runtime switch in the start-up options.
 
Thank you;
I want just to know how to set /RunTime switch in startup options.Where is
it and how to do that?
Can u pleasew guide me?
THX.
 
Hi Mota,

check the knowledge base article 205151 - How to
Distribute a Secured Database
http://support.microsoft.com/default.aspx?scid=kb;en-
us;205151&Product=acc

article 254372 - Overview of How to Help Protect a
Microsoft Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-
us;254372&Product=acc

article 209207 - How to Use Command-Line Switches in
Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en-
us;209207&Product=acc

Be aware that just using command-line switches only does
not stop someone by-passing them to open your database
in 'full' mode.

Also use online help for information on creating mde
database files.

Luck
Jonathan
 
Mota said:
Thank you;
I want just to know how to set /RunTime switch in startup options.Where is
it and how to do that?
Can u pleasew guide me?
THX.
Click to expand...

What you do is make a shortcut to the application. In fact, you should as a
general rule supply a shortcut..since then you can set things like the
security file. (you are setting up,and supplying a security file with your
runtime system..right? Even if you are NOT using security..you should
distribute a workgroup file..and use that for startup options...just to
reduce support calls and hassles from your users).

So, you right click on the database..and select short cut...

You then open up that short cut..and replace the shortcut text with your
own.

For example, here is what a typical short cut looks like:

"C:\Program Files\Office97\Office\msaccess.exe"
"c:\program files\Rides\Rides.mdb"
/wrkgrp "c:\Program Files\Rides\Rides.mdw"
/User "RidesAdmin" /pwd "mypassword"

So, to the above you would add the runtime switch like:

/runtime

The above of course goes on one line ...each line has a space...so..in fact
you get:

"C:\Program Files\Office97\Office\msaccess.exe" "c:\program
files\Rides\Rides.mdb" /wrkgrp "c:\Program Files\Rides\Rides.mdw" /User
"RidesAdmin" /pwd "mypassword" /runtime

As mentioned..if you had setup custom menus..then users should not notice
the difference between running your application with the full version..your
runtime version...

I of course have in the windows explorer set the "address bar" to show the
full path name. So, I can usually just browse to wherever I have to..and
then use cut and paste in place of tying to type such a huge ugly thing as
above..(I don't type the above..I cut and past it in).

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn
 
Back
Top