Form display

[Seamus Ruane]

Hi,

I have created a little Access database, which includes a
data entry form. I would like it if my operators could
load and use the form only to enter data, without being
able to see the Microsoft Access screen.

Is is possible to configure Access to allow this?

Thanks in advance

Seamus

 

[Frank Stone]

no. you need to look into security.
on the access menu bar >tools>security. lot of options here
also see tools>startup. you can hide the database window.
You can also create a frontend/backend relation with 2 or
more access database where you have control of the tables
and the users only have access to forms through linked
tables.

 

[Frank Stone]

no. you need to look into security.
on the access menu bar >tools>security. lot of options here
also see tools>startup. you can hide the database window.
You can also create a frontend/backend relation with 2 or
more access database where you have control of the tables
and the users only have access to forms through linked
tables.

 

[grep]

Hey Seamus,

Just a thought, and I'm prefacing this with the words, "I've never
actually done this myself", but maybe you could create a Data Access
page, and run a webserver on the server with your Access app. Then your
application would be web-based, and all the users would see is the form
you've created in their browser.

Like I said, just a thought...

grep

 

[Albert D. Kallal]

You don't need to use security at all of hide the ms-access interface. You
can certainly use security to restrict what forms and reports users see, but
you don't need to use security to hide the ms-access interface.

All of the settings you need to setup ms-access for you user are in
tools->startup.

If you want to see an example database with all of the ms-access interface
hidden (and no code or security was used to do this), then download and try
the 3rd example of mine here:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

 

[Seamus RUane]

-----Original Message-----

You don't need to use security at all of hide the ms- access interface. You
can certainly use security to restrict what forms and reports users see, but
you don't need to use security to hide the ms-access interface.

All of the settings you need to setup ms-access for you user are in
tools->startup.

If you want to see an example database with all of the ms-access interface
hidden (and no code or security was used to do this), then download and try
the 3rd example of mine here:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.ht m

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


.
Thanks Albert, I think this'll do the trick

Seamus

 

[Seamus Ruane]

-----Original Message-----
Hey Seamus,

Just a thought, and I'm prefacing this with the words, "I've never
actually done this myself", but maybe you could create a Data Access
page, and run a webserver on the server with your Access app. Then your
application would be web-based, and all the users would see is the form
you've created in their browser.

Like I said, just a thought...

grep


.
Thanks Grep

Seamus

 

[Seamus Ruane]

-----Original Message-----
Hey Seamus,

Just a thought, and I'm prefacing this with the words, "I've never
actually done this myself", but maybe you could create a Data Access
page, and run a webserver on the server with your Access app. Then your
application would be web-based, and all the users would see is the form
you've created in their browser.

Like I said, just a thought...

grep


.
Thanks Frank

Seamus