Multiuser one database

[Guest]

Hi
Can anyone please tell me how to make a DB accessible by multiusers with
several users being able to update different sections at one time?

Thanks

SJL

 

[Guest]

Can anyone please tell me how to make a DB accessible by multiusers with
several users being able to update different sections at one time?

I would be interested in that too. Can you make an executable Access
database interface using Macromedia Flash MX (first edition) or HTML/Intranet
in FrontPage 2003?

 

[Albert D.Kallal]

Hi
Can anyone please tell me how to make a DB accessible by multiusers with
several users being able to update different sections at one time?

As a normal course of action, ms-access is multi-user out of the box, and no
actual changes need to be made to anything.

However, to ensure reliability, and to avoid conflicts, you should split the
database. I explain this concept here

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[Brian Bastl]

SJL,

while I'm not qualified enough to give you specific guidance, I can tell you
that you need to split your database, although you should do it even if were
just for you. You'll need a back-end stored on a server which contains only
the tables, and a front-end copy on each computer consisting of your
queries, forms, reports, and modules. It is my understanding that Macros
don't work well, if at all, in this environment, so they will have to be
changed to VBA coding.

Hopefully someone more qualified will chime in.

Hope that helps a little,
Brian

 

[Albert D.Kallal]

I would be interested in that too. Can you make an executable Access
database interface using Macromedia Flash MX (first edition) or
HTML/Intranet
in FrontPage 2003?

Building a multi user appcation in ms-access has not relation to flash, or
html, or front page. No more so then a duck is different then a airplane.

ms-access is multi-user ready, and no changes need to be made to the code or
application to allow more then one user to work on the database at the same
time. However, the issue of ms-access being multi-user, and working with
flash are very different questions and concepts.

As for building a executable, no you can't. However, you can purchase the
developers edition of ms-access, and this will package your application + a
runtime version of ms-access. The result is a standard windows install, and
one that can be used on computers where ms-access was not purchased.

So, you do have a royally free option to package and distribute your
applicaton as a install.

However, it is certainly nothing like a small .exe. In previous versions,
that runtime was 150 megs. For a2003, the runtime is about 33 megs (so,
certainly downloadable over high speed internet, but certainly not a little
exe file).

OF course, most development platforms today, be it VB6, the new vb.net, or
in the case of ms-access all require some runtime support libraries
anyway....again, nothing new to our industry...