Database programs - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 4 (permalink) Old 03-19-2010, 11:09 AM Thread Starter
AHMO!
 
Join Date: Apr 2004
Location: the original let me google that for ya guy
Posts: 16,810
Database programs

Ok, we were talking at work about wanting/needing a new DB program (NOT ACCESS) because well Access sucks/doesn't need it to do what we want it to do.

We are looking for a Multi User DB (maybe up to 10 users) with record locking so when one user is on a table/record it locks that so no one can modify it at the time. In access you can modify a record while someone else is using it and that user will be unaware of this at the time if they continue with that table.

I've only used MS Access and IDEA and neither quite fit what we are looking for. Anyone have any other programs/suggestions we might look into?
Nate is offline  
Sponsored Links
Advertisement
 
post #2 of 4 (permalink) Old 03-20-2010, 05:06 AM
KJ94GT
Guest
 
Posts: n/a
MySQL for a cheap solution.
post #3 of 4 (permalink) Old 03-20-2010, 12:39 PM
Lifer
 
Join Date: Apr 2006
Location: Fate, TX
Posts: 1,014
Access can work the way you need it to. I had a system in place at a company with over 65 users modifying files. It just depends on how you set up the queries / permissions and how the data is being retrieved. (ie - a form from within Access or using a separate program such as Excel to grab the data - which is what I was doing)
Mach1Nut is offline  
 
post #4 of 4 (permalink) Old 03-20-2010, 04:21 PM
#4 Best QB Ever
 
That_Is_My_El_Camino's Avatar
 
Join Date: Apr 2004
Location: Land of the Free
Posts: 29,339
SQL Server, MySQL


Quote:
Originally Posted by DON SVO View Post
Women: vaginal life support.
That_Is_My_El_Camino is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome