Multi user forms

[Albert]

Hi Guys,

I would like 10 users to access and view only the particular forms in a
survey, can you help?

Essentially, they should not be able to view any ACCESS options except see
the maximized view of the survey.

Is this possible?

Thanks
Albert

 

[Mr. B]

Hi, Albert,

In order to allow multiple users to access your application, be sure that
you utilize the "split" method for Access. By this I mean split the
front-end (forms, queries, reports and modules) from the backend (tables) and
link the front-end to that backend.

As for having your users to "not be able to view any Access options except
see the maximized view of the survey", use the startup options for your
application. If you are using Access 2007 then you may also need to do a few
more things to completely get your application to the point you want it, but
this should get you started.

 

[Albert]

Thanks for this.

Do you have any KB articles on this that you could share with me?

My skill level is moderate

 

[Mr. B]

Hi, Albert,

Here is a website that is a very good resource.
http://www.mvps.org/access/

Here is a couple of links relative to splitting an Access database
http://www.databasedev.co.uk/split_a_database.html
http://www.databasedev.co.uk/splitting-ms-access-database.html

Here is a knowledge base article:
http://support.microsoft.com/kb/304932

Do a Google on "ms access split database" for even more info.

Also do a Google on "ms access startup options".

Here is one link:
http://office.microsoft.com/en-us/ork2000/HA011381121033.aspx

One of the "other things" that I was thinking about was if you are using
Access 2007 then you may want to review this link:
http://office.microsoft.com/en-us/ork2000/HA011381121033.aspx

 

[Albert]

Thanks for this.

This will keep me going for a while.