Access Database

I am no software designer either, but I like to build my own databases using Microsoft Access. To answer your question, Is Microsoft access a database? I would say no, it has all the tools so a user can build his/her own database. It does contain templates but I would not call it a stand alone database. I am sorry I am unable to comment on your second question as I have not developed my skills far enough to use the MySQL workbench. Hopefully this helps a little. J. Hart

one way to look at Access is a database manager

you can use access for a single or multiple data bases

here are some resources to help you learn about access

http://www.functionx.com/access/index.htm

http://www.gpcdata.com/

http://techrepublic.com.com/

thanks for your kind answer. Actually im an advanced user of Mic access. I have made many of them. even for industrial needs. but im electromechanical engeenier and i would like to learn more about other system stronger than access. even as easy to use as access is. Does it exist?

thanks for your advises. You are right in many ways. Certainly in my case the databasis im making is just for one user. But The problem i have is that when the design become complex, the file works very slow also. I dont know the reasons for that. But i have being reading about different databasis software and I made this following assumptions:some systems like MySQL are able to deal with many net users at the same time. So it means it is less affected by the traffic of information. So it is more strong and using this i can avoid some problems i have being suffering with access. (Sorry for my english it is not my native languaje, hehe) actually i have no experience about programing. I will take your commentaries into account because what you said have a lot of sense for me. thanks a lot

Some good info in this thread, but I feel compelled to add a bit.

MS Access is a relational database management system (RDBMS) that is based on an ancient db engine called Jet. It's starting to show its age, but it is quite good for small standalone and limited networked database applications. It does not require a client/server configuration to perform its tasks as the db can be located on a network accessible computer and a desktop shortcut can point to it from any computer on the network. It can handle about 10 concurrent users and have several megabytes of data stored before it starts to get cranky (speed and access problems). It has password access capabilities but is fairly easily cracked, and doesn't really have levels of access protection. It's pretty much all or nothing.

IMO, Mysql is a highly superior RDBMS based off of true SQL. If configured behind a web server (either Apache for Linux or Windows, or IIS for Windows) and augmented with PHP, it is the next best thing to full SQL or Cold Fusion (both top of the line RDBMS). Mysql has robust network protection far beyond Access.

Using Mysql behind a web server allows one to design all input forms and output reports using HTML, and several web design applications, ala DreamWeaver, allow direct access to Mysql during the design and testing processes.

I've built several online applications (both internet and intranet) and far prefer the Mysql approach.

And, did I mention that Mysql, PHP, Apache and Linux are all free? And there are a gazillion free add-ons available, too, that can save hours of design and programming time.

Hooker

thank you very much. actually i dont understand the logic of the procedure when you connect the mysql db . i would like to learn more about it if you can give some good links.im not a software designer but im working in a company and we had a program for lubrication routines with actually is an advisor. but it doesnt tight into owr needs. Thats way I decided to buid a databasis wich actually works very well, but sometimes become slow and im looking for something stronger than access. thanks a lot. What i need to undersand (its something conceptual apparently) is how the databasis is connected to a server and why do i need that. why i can not just connect to the file like access does. Thanks a lot

thanks for the links im going the examine them. thanks a lot