Solved

Multi-User Database Environments

Posted on 2011-03-19
3
284 Views
Last Modified: 2012-05-11
I have lots of access databases which i would like share on user on a multi user level but appear to have problems on the company server with file locking - first user can open but no other users can (no errors just does nothing when link is clicked).

Can anyone recommend another dbase product which is very easy to learn given that i only know how to program access (basic coding) - ideally without spending a fortune on software.

Perfect would be to still use access in some way as we have that on all pcs at work.
0
Comment
Question by:SweetingA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

Accepted Solution

by:
ErezMor earned 500 total points
ID: 35171242
access can perform very well for multi user environments. but consider the following:
to share an access application in local network you need to split the application to 1 center ("back-end") mdb file that holds ONLY THE TABLES,
then create a "front end" mdb file with all other objects (forms, queries, reports, modules...) and give EACH USER his own copy of this mdb (usually on his LOCAL machine)
this way the center file only handles the data sharing and nothing else.
this structure can work quite good as long as: there arent too many concurrent users (i have business experience with 20-30 without a problem, but 50+ can "feel" the burden and even crash every once in a while
you HAVE TO compact-and-repair your back-end file as frequently as possible (and ALWAYS save a back up version of it) - cause access will eventually crash and sometimes it wont repair anymore and youll have to revert to a back up. REMEMBER: if you're using access for mutli-user env. IT WILL CRASH sometime
0
 
LVL 58
ID: 35171275
<<first user can open but no other users can (no errors just does nothing when link is clicked).>>

  Well something is not right as Access when developed well can support approx 30 users in a typical read/write application without too much difficulty.

  First thing to check is basic security; all users need full read, write, and delete privs for the directory where the DB resides.  Second is that no one is opening it in exclusive mode.

JimD.
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 35171405
you possible next "database" could be the express version of sql server...
which is free...

however you would still need "use" Access to provide your front end to the users...

i feel that your problem currently is in not developing an access solution which
supports multi user processing... as mentioned previously .. you need to at a minimum start developing in a local/server database manner for access to function...

can you expand on how your access databases are structured at present, and what if any multi-user startegies you are currently using?

0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question