Mdb vs Project

[Guest]

Have created application on mdb. Kindly clarify can :

Application be hosted on network and used by user.
How much users can share this.

How should i host this on network and define rights which passes on to users
on their pc's.

Thanks

 

[TC]

To let multiple people use your database, you'll have to split it into
a so-called "front end/back end" or FE/BE structure. Google the Access
groups for those terms, to find out what they mean, and why you should
do that.

To "define rights" for users, you could use Access user-level security.
This is quite a complex topic, there's no way to explain it in a
newsgroup post. Look for & read the "Access Security FAQ", often
referenced in this newsgroup.

HTH,
TC [MVP Access]

 

[Guest]

To add to TC's answer, you might want to check out this document:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Have created application on mdb. Kindly clarify can :

Application be hosted on network and used by user.
How much users can share this.

How should i host this on network and define rights which passes on to users
on their pc's.

Thanks

 

[Tony Toews]

Application be hosted on network and used by user.
How much users can share this.

How many users? Somewhere between 5 and 100 depending on how well
your app is built and the stability of the network infrastructure.

How should i host this on network

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm