?
Solved

Multi-User Database Environments

Posted on 2011-03-19
3
Medium Priority
?
290 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
3 Comments
 
LVL 12

Accepted Solution

by:
ErezMor earned 2000 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 59
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 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