Concurrent Acess into MS Access

[tiger]

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

 

[Mike Labosh]

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?...

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)

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

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

"Escriba coda ergo sum." -- vbSensei