Need help with a complex database, VBA and form

  • Thread starter Thread starter nxqviet
  • Start date Start date
N

nxqviet

Hi,

I'm currently working on a fairly complex database that has a large
number of forms, VBA and SQL coding. And this database will have to
have the ability to allow about 50 users to use, add and edit data all
simutaniously.

I complete the majority of the database, but now, I have great
difficulties modifying it so that it support multiple users, as
mentioned above. I would love to be able to talk to someone with great
knowledge regarding this to help me compete the modification. If you
can help, please email me and I'll contact you directly for advices. my
email is n*x*q*v*i*e*t*$y*a*h*o*o*.*c*o*m, appropriately without the
"*" and replacing the $ with "at".

i do this because the problems are conceptual ones that make it hard to
write up here as a post. please understand.

Thanks very much,

V_
 
You might find this article helpful:

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

I think it would be beneficial if you make an attempt to explain the
conceptual issues you mention. By putting them in writing, it forces you to
really think about the issues, and try to explain them in a clear manner.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
I'm currently working on a fairly complex database that has a large
number of forms, VBA and SQL coding. And this database will have to
have the ability to allow about 50 users to use, add and edit data all
simutaniously.
Click to expand...

Just to check - are all 50 users connecting to a single unitary
database?

If so - your very FIRST step is to use the Database Splitter Wizard to
split the database into a "backend", a shared database containing only
Tables, and a "frontend" with everything else, linked to the tables in
the backend. Each user should get their own copy of the frontend.

See the discussion at

http://www.granite.ab.ca/access/splitapp

for suggestions, cautions, and examples.

John W. Vinson[MVP]
 
Back
Top