SweetingA
asked on
Multi-User Database Environments
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
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?
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.