Hi,



I created a tool that uses VBA to create a front-end (Gui) in Microsoft



access and after creating this tool I put it on my works intranet for people



to use....



My question is how can I make it a multi-user tool that is concurrent access



to the tool?...



Do I have to recreate this tool over again from scratch?



The tool extension is *.mdb.



Thanks



Tiger

The first most important thing is that whenever your tool touches a



database, it should do so in "non-exclusive" mode.  If it needs to touch a



database "exclusively", then you will need to have a more business-level



approach, such as calling up the receptionist and asking her to page the



whole building to say, "Everyone get out of the database" -- but that's



REALLY unprofessional.



So your only recourse is to make your tool "multiuser" by changing your code



so that it does not try to get exclusive access to the database(s)



I personnaly prefer to write any utilities in VB or .NET, but you should not



have to rewrite it simply to solve the multi-user issue.



--



Peace & happy computing,



Mike Labosh, MCSD MCT



Owner, vbSensei.Com