The problem with access is that it cannot stand the all the increasing data we are putting anymore. I need something that I can rely on for huge database considering my experience in access & VB programming. Any suggestions?
2006-11-21 04:23:00 · 6 answers · asked by Weaam 4 in Computers & Internet ➔ Programming & Design
mySQL, is it easy to learn for someone familiar with access & vb?
2006-11-21 04:25:54 · update #1
what about exe & distribution in mySQL?
2006-11-21 04:28:41 · update #2
The department where I work have had a home-made access database for long time now. It's a simple db that was created by a former employee. Since I came, I have been working on this db. I improved it & add more functions. Since the codes, the tables, and everything are accessbale in access.. it's not really secure or something that you can trust, that's why I'm thinking to work on something else. I'm not a programmer, I'm pharmacist, but it happened that I'm interrested and trying to use my skills to make our life easier.
Waiting for your answers & thanks for the prompt replies.
2006-11-21 04:41:02 · update #3
You need to identify your database requirements. Simply moving to a proper relational database is likely the right move, but you might want to identify the restrictions around your choice:
- operating system
- programming environment (what will apps be written in)
- price
- volume of data
- amount of concurrent users
- level of database administration required
- synchronization/replication
- availability of help (online communities, etc...)
For my money, I would start of trying either:
- Postgres
- MySQL
- SQL Anywhere Studio - Developer Edition
The latter is a great commercial-product choice because of the low cost of both licensing and of support, plus it has one of the best online communities going (the newsgroup "sybase.public.sqlanywhere.general" and other "sybase.public.sqlanywhere.*" newsgroups)
Links below should help.
2006-11-21 04:35:03 · answer #1 · answered by RGB_Mars 3 · 0⤊ 0⤋
Are you responsible for buying a database product for a company? If so my suggestion would be Informix Dynamic Server.
The queries are SQL standard, Informix offers easy setup of databases, good performance, and can handle really large databases.
You can write a VB front end that can be designed to query the database and display records. All depends on what you are using the database for and how much you are willing to spend.
2006-11-21 04:31:20 · answer #2 · answered by SteveN 7 · 0⤊ 0⤋
I must say accsess is good but only for linear data base handeling
(something like connecting sets, you probably know this) AND if somebody didn't know it uses SQL to do those tables.
SQL server is a good and profesional program but the top of the class data base program is Oracle (version 10g)
For HUGE (GBytes) batabase I sugest Oracle, for anything smaller than 200 MB i sugest My SQL and Accsess.
Carefull 200 MB are not that much of a space. It is OK for small companyes (lets say 10 shops).
2006-11-21 04:35:10 · answer #3 · answered by SaSe 2 · 0⤊ 0⤋
php/mysql
php is really like vb and you can learn it very fast. It's free and you can download tones of sample code for you to start with.
2006-11-21 04:29:29 · answer #4 · answered by Anonymous · 0⤊ 0⤋
create an SQL database. mySQL is freeware
2006-11-21 04:25:23 · answer #5 · answered by Shadow Hawk 2 · 0⤊ 0⤋
SQL Server (not free) or mySQL (free)
2006-11-21 04:24:31 · answer #6 · answered by CSharper 1 · 0⤊ 0⤋