MS Access 2003 Database Application

[Hitesh Joshi]

Hi,

I have ODBC database link in Access 2003 and back end as SQL 2k.
Is there a way I can open my front end Access application without all
the Access menus?

So if I distribute my database front end to end users and if they open
it, they should not see "access overhead" i.e. file menu, tool menu
and all those "stuff".

Thannk u,
hj

 

[Jeff Boyce]

Convert your .MDB file to an .MDE file (Tools | Database... | Make .MDE).

The MDE removes the user-interface tools, so users cannot modify your
application.

NOTE: preserve a copy of the .MDB file ... because YOU won't be able to
modify the .MDE either!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Hitesh Joshi]

Convert your .MDB file to an .MDE file (Tools | Database... | Make .MDE).

The MDE removes the user-interface tools, so users cannot modify your
application.

NOTE: preserve a copy of the .MDB file ... because YOU won't be able to
modify the .MDE either!

Regards

Jeff Boyce
Microsoft Office/Access MVP

How long this process should take? I am trying to do this and Access
says "Not responding" with high CPU usage. It is still trying to
convert and running after 20 mins.

hj

 

[Hitesh Joshi]

How long this process should take? I am trying to do this and Access
says "Not responding" with high CPU usage. It is still trying to
convert and running after 20 mins.

hj

All right I figured that part out so I created MDe but I still see
tool bars and stuff...

I thought MDE would just show just stand-alone application with my
forms and whatever else I have in application database.

hj

 

[Jeff Boyce]

While you might see them, they are not functional.

If you'd like, though, you could hide those in your copy of the MDB, then
make an MDE from that version.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Hitesh Joshi]

While you might see them, they are not functional.

If you'd like, though, you could hide those in your copy of the MDB, then
make an MDE from that version.

Regards

Jeff Boyce
Microsoft Office/Access MVP








- Show quoted text -

Thank you. I will research tomorrow, that would be great.. then users
can click an MDE application and it would look like a stand alone
apps. do u know any links on how to hide frames/toolbars in MDB?

cool.

Thanks a lot.

hj

 

[Hitesh Joshi]

Thank you. I will research tomorrow, that would be great.. then users
can click an MDE application and it would look like a stand alone
apps. do u know any links on how to hide frames/toolbars in MDB?

cool.

Thanks a lot.

hj- Hide quoted text -

- Show quoted text -

Ok, got it. I can hide the toolbars and 'ms-access interface'. tools -

options.

I wonder if I can get rid of that 'grey' back-ground and frame. I have
heard I need Developer's edition to do that to compile as stand-alone
EXE application. I do not care for exe or stand alone app. All my
users are going to have MS Access 2003 installed.
can I do it without Developer's edition?

hj

 

[Albert D. Kallal]

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

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

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

So, if you do the above + make a mde...you lock up your appcation quite
nice...and users will not even have to know it is in ms-acccess...