The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.
|
 |
|
Dev Shed Forums
> Databases
> Database Management
|
multi-user database
Discuss multi-user database in the Database Management forum on Dev Shed. multi-user database Database Management forum discussing non-database specific SQL. Structured Query Language was designed to be a robust and standardized language for manipulating relational databases.
|
|
 |
|
|
|
|

Dev Shed Forums Sponsor:
|
|
|

October 21st, 2002, 08:30 PM
|
|
Junior Member
|
|
Join Date: Jun 2002
Posts: 3
Time spent in forums: 3 m 21 sec
Reputation Power: 0
|
|
multi-user database
This is a newbie question. I'm trying to figure out what to use for a multi-user database (non-web), for about 10-20 users, where I can customize the front end appearance.
I've done database apps with vb and access as backend although i think it may get slow as the user number and data gets larger.
What software(s) is good for this type of apps? is there one software to do it or do i need to use a front end/backend?
I've heard of so many db's like oracle, sybase, etc., and with no experience at them, I dont really know what will work/ or be good for this.
Thanks.
|

October 22nd, 2002, 02:47 AM
|
 |
Modding: Oracle MsSQL Firebird
|
|
Join Date: Jun 2001
Location: Outside US
|
|
If you'll be working on Ms platform try MySQL or Firebird. Otherwise MySQL or PostgreSQL are excellent choices.
Another good db (opensource, free and crossplatform) is SAPDB.
|

October 22nd, 2002, 03:42 AM
|
|
Junior Member
|
|
Join Date: Jun 2002
Posts: 3
Time spent in forums: 3 m 21 sec
Reputation Power: 0
|
|
|
Thanks Pablo.
I'll try it out. Some silly questions however, do I need a front end to go with mysql? and I'll be using windows, so I should be downloading the zip file under windows right?
Lastly, when installing a 'finished app' on another pc, what do i need to install (aside from the app), do i need to put mysql and some other files?
Thanks again.
zoo
|

October 22nd, 2002, 04:01 AM
|
 |
Modding: Oracle MsSQL Firebird
|
|
Join Date: Jun 2001
Location: Outside US
|
|
You can go with the command line or use a front end tool like those described here.
For Firebird you can use IbAccess or Marathon (from sourceforge.net) and don't forget to check www.ibphoenix.com.
For your app, I think you'll need at least a driver (or the client part of the db, if any), for MySQL read this super interesting thread.
Hope this helps
|

October 22nd, 2002, 04:02 AM
|
 |
Second highest poster :p
|
|
|
|
|
MySQL is a server based database, it should never be installed on each machine. What i would reccomend is setting up a webserver with MySQL and creating the user interface using PHP or ASP. that way to dont need to install anything on the users machines, they just need their web browser.
|

October 22nd, 2002, 04:29 AM
|
 |
Modding: Oracle MsSQL Firebird
|
|
Join Date: Jun 2001
Location: Outside US
|
|
a.koepke please read before posting, arzoo400 specified
|

October 22nd, 2002, 12:04 PM
|
 |
Contributing User
|
|
Join Date: May 2002
Location: NJ, USA
Posts: 91
Time spent in forums: 1 h 1 m 8 sec
Reputation Power: 11
|
|
|
Arzoo,
Use MySQL as suggested. If you're comfortable using VB, use it. You can connect to MySQL by using ODBC, the same way you did using VB. You'll just have to install MyODBC.
Access is definately not the answer if you're expecting concurrent users. I've been forced to use Access for some applications at work and in my experience it's unpredictable with anything more than 2 users.
__________________
- Walt
Will code for food.
|
Developer Shed Advertisers and Affiliates
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Rate This Thread |
Linear Mode
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|