multi-user

[tiger]

Hi,

I created a access base tool using VBA form for the front-end GUI, and I
put the tool in my work's intranet, why question is how do I make the tool a
multi-user tool.

The extension of the my tool's file is *.mdb.

Thanks
Tiger

 

[Guest]

Hi Tiger,

Please see the following article:

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

Pay particular attention to:
1.) Splitting the database, and distributing a copy of the FE to each user
2.) Disabling NameAutocorrect
3.) Setting all subdatasheets to [None] and
4.) Establishing a permanent connection for each user

In addition, this article includes lots of useful tips such as using indexes
to help prevent table scans, and using an unbound search form to help locate
records that the user may want to edit.



Tom Wickerath, Microsoft Access MVP

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