microsoft access vs.MySQL?
153544
Microsoft offers a full family of database tools for the desktop, the server, and for open connectivity. For the desktop Microsoft offers Microsoft Access 97/2000.\nThe Microsoft Access 97/2000 is a full-featured multiuser relational database management system that designed for the Microsoft Windows operating systems (such as Windows 9x, Windows NT, Windows 2000). Access 97/2000 is extremely visually oriented and easy to use. It makes extensive use of drag-and-drop and visual design for queries, forms, and reports.\n\nAccess 97/2000 comes with an integrated development environment (IDE), including incremental compilation, a fully interactive visual debugger, breakpoints, and single step-through. These capabilities combine to make Microsoft Access an extremely powerful platform for developing client-server database solutions.\n\nThere are general Access 97/2000 characteristics:\n\nObject Maximum sizes/numbers \nDatabase size 1 Gb \nNumber of characters in an object name 64 \nNumber of characters in a password 14 \nNumber of characters in a user name or group name 20 \nNumber of concurrent users 255 \nNumber of characters in a table name 64 \nNumber of characters in a field name 64 \nNumber of fields in a table 255 \nNumber of characters in a Text field 255 \nNumber of characters in a Memo field 65,535 / 1 Gb \n\nThough the maximum database size is 1 Gb, but your database can include linked tables in other files, and its total size is limited only by available storage capacity.\n\nNumber of characters in a Memo field can be up to 65,535 characters when entering data through the user interface or can be up to 1 Gb when entering data programmatically.\n\nAccess 2000 can lock on the row level in comparison with Access 97 page level's lock.\n\nWHILE IN SQL SERVER 2000\n\nThere are no many differences in the internal architecture between SQL Server 7.0 and SQL Server 2000. SQL Server 2000 has the same features as SQL Server 7.0: autogrow features, new storage engine, complete row level locking and so on. So, the general characteristics of these versions are the same.\n\nThere are general SQL Server 97/2000 characteristics:\n\nObject Maximum sizes/numbers \nBatch size 65,536 * Network Packet Size \nBytes per short string column 8,000 \nBytes per text, ntext,or image column 2 GB-2 \nBytes per index 900 \nBytes per foreign key 900 \nBytes per primary key 900 \nBytes per row 8,060 \nBytes in source text of a stored procedure Lesser of batch size or 250 MB \nClustered indexes per table 1 \nColumns per index 16 \nColumns per foreign key 16 \nColumns per primary key 16 \nColumns per base table 1,024 \nColumns per SELECT statement 4,096 \nColumns per INSERT statement 1,024 \nConnections per client Maximum value of configured connections \nDatabase size 1,048,516 TB \nDatabases per instance of SQL Server 32,767 \nFilegroups per database 256 \nFiles per database 32,767 \nFile size (data) 32 TB \nIdentifier length (in characters) 128 \nLocks per connection Max. locks per server \nNested stored procedure levels 32 \nNested subqueries 32 \nNested trigger levels 32 \nNonclustered indexes per table 249 \nObjects in a database 2,147,483,6474 \nParameters per stored procedure 1,024 \nREFERENCES per table 253 \nRows per table Limited by available storage \nTables per database Limited by number of objects in a database \nTables per SELECT statement 256 \nTriggers per table Limited by number of objects in a database \nUNIQUE indexes or constraints per table 249 nonclustered and 1 clustered \n\nSQL Server 2000 Enterprise Edition on the Windows 2000 DataCenter can support up to 32 CPU and up to 64GB physical memory (RAM) on a computer!
743627
I would use Microsoft office Access package, it is a date base.  Just take time to organise which titles you need, it is fairly simple to operate, and can be updated very easily.
206160
My guess is MySQL from looking at the front page of mysql.com.  I doubt they have only 1 solution for their entire company though.
325354
MySQL is the easiest to install and use which uses a client-server architecture.  It runs on windows and Unix-derivitives such as Linux.  It is also extremely fast and blows the pants off of SQL Server.\n\nMicrosoft SQL Server is a good choice for an enterprise-level windows database.  You will need very good hardware to get good performance from SQL Server.\n\nOracle is overpriced and very complex.  It's powerful, but convoluted and takes a lot of skill to manage properly.\n\nOthers to look at include Postgres (like MySQL but not as widely used),  IBM DB2, Sybase, Interbase (Borland)
1029483
Check out Microsoft\n\nOr just Google database design or database normalization.
549789
OK as long as what we are talking about is simple presentation needs all you need to know is HTML and CSS in today's world you do not even need to know that as you can graphically design your site using graphic design interfaces like macromedia MX or Front-Page. If you are talking about a more complex site one that is dynamic I.E. changes its content based on a programming language that runs in the background and usually involves a data base to store data. \nPHP and MySQL like any other tool in the world has its advantages and disadvantages.\nPHP and MySQL are open source platform just like Linux. Usually runs on a Linux machine with Apache or tomcat servers (can be run on windows servers but not recommended). Some of the main advantages of such a setup are:\n*It is completely free almost no investment in software.\n*Very fast and easy to develop and is universal.\n*Very versatile as to its capabilities.\nMain disadvantages: \n*MySQL does not support triggering. I.E needs a lot of compensation on the PHP side of things to achieve the same things MSSQL can do by itself.\n*PHP is not completely object oriented and is incapable of doing certain client side tasks like java script can.\n*MySQL is limited in the size of the data base it supports and is relatively smaller then MS SQL servers (it still supports enormous amount of data and I find it well sufficient for most applications).\n\nYour other options include Microsoft solutions which are more expensive software wise slower in development and maintenance. But in the long run have much more capabilities then PHP and MySQL. \nAgain as the lady before me said it all depends on your specific needs and what you want to achieve with your website.
196385
to run all the above in windows you hav a s/w called\nWAMP(Windows, Apache, MySQL, PHP) ... its free available over the net.. install that and its ready to use.
297617
I'm not sure what youm mean by electronic database, but why not use Microsoft Access?
83897
try this out:\n\nhttp://dev.mysql.com/doc/
643171
This forum will probably lack the comprehensive information you need.  The materials provided with the Access program can get you started, however I suggest visiting a book store for a "How TO" instructional book.\n\nDo a search for "Microsoft Access" on amazon.com as a starting point.\n\nOn the web, research these sites:\n\nAccess Database Design and Programming \nO'Reilly's Access Database Design and Programming offers Access users the knowledge needed to begin the transition to Access developers.\nhttp://databases.about.com/library/weekly/aapr051202.htm (About Databases)\nAccess Database Too Big! \nAccess Database Too Big!\nhttp://databases.about.com/b/a/222380.htm (About Databases)\nAccess Database Design and Programming \nO'Reilly's Access Database Design and Programming offers Access users the knowledge needed to begin the transition to Access developers.\nhttp://databases.about.com/library/weekly/aapr060902.htm (About Databases)\nNew...Access Database from Delphi - DB Course/Chapter 13 - Page 2/2 \nChapter thirteen of the free Delphi Database Course for beginners. How to create an MS Access database without the MS Access. How to create a table, add an index to an existing table, how to join two tables and set up referential integrity. No MS Acc\nhttp://delphi.about.com/od/database/l/aa072401b.htm (About Delphi Programming)\nNew...Access Database from Delphi - DB Course/Chapter 13 - Page 1/2 \nChapter thirteen of the free Delphi Database Course for beginners. How to create an MS Access database without the MS Access. How to create a table, add an index to an existing table, how to join two tables and set up referential integrity. No MS Acc\nhttp://delphi.about.com/od/database/l/aa072401a.htm (About Delphi Programming)\nBuilding an Access Database From the Ground Up \nIn this series of ten Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.\nhttp://databases.about.com/od/buildinganaccessdatabase/index.htm (About Databases)\nMicrosoft Access Database Fundamentals \nMicrosoft Access Database Fundamentals \nhttp://databases.about.com/b/a/139756.htm (About Databases)\nMicrosoft Access Database Fundamentals \nMicrosoft Access Database Fundamentals\nhttp://databases.about.com/b/a/243511.htm (About Databases)\nBuilding an Access Database From the Ground Up \nIn this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.\nhttp://databases.about.com/cs/tutorials/a/widgetmenu.htm (About Databases)
1077460
The SQL used by MS Access by default is called TransactSQL (sometimes shortened to t-SQL) \n\nSQL is an ANSI (American National Standards Institute) standard computer language for accessing and manipulating database systems. SQL statements are used to retrieve and update data in a database. SQL works with database programs like MS Access, DB2, Informix, MS SQL Server, Oracle, Sybase, etc.\n\nUnfortunately, there are many different versions of the SQL language, but to be in compliance with the ANSI standard, they must support the same major keywords in a similar manner (such as SELECT, UPDATE, DELETE, INSERT, WHERE, and others).\n\nNote: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!
887001
Oracle - and Microsoft's SQL Server - are good for large scale (think web based or Wide-Area-Network) database applications.  Access is good for SMALL scale - single computer, or very small, local area network database applications.  Also, an Access database can't have very many users logged in at the same time.  SQL Server and Oracle can have lots of users logged in at once.
3349
You can set up a database with word, but how depends on what kind of database you are making. You will need another program like Access, SQL Server, PHP, etc., to call the database and retrieve the info in a useful manner. It is easier to use databse program like Access or SQL to input the data, but you can simply write the database using commas and semicolons depending on what form of simple database you are creating.
485900
The MS Access database size limit is 2GB.  You can't change that, but putting your forms, reports, queries, etc. in a separate database and then using linked table will help.  That will let you have a 2GB database for just data.\n\nYou CAN have multiple databases of 2GB all linked in a single application, but you'll run into a brick wall if you need referential integrity, cascading updates and deletes, etc.\n\nIf you haven't already designed your database, it would be eaiser to use MS SQL or MySQL for a database.  The MySQL route is nice because it's FREE, but I'm sure some of my competitors would disagree with the use of MySQL.  \n\nI've developed a large Access/VBA application that has linked ODBC tables to a MySQL database.  The database is around 8GB right now and it runs flawlessly.  And when there IS a problem it's always been an MS Access problem, NOT the database.\n\nMySQL running on Linux is rock solid.  MS-SQL is good, too, but there's a price to pay (licenses).\n\nGood luck!
125494
Lot's of people do it.  Personally, if other considerations were roughly equal, I'd go with a non-proprietary SQL database rather than MS Access to keep open source as an option to being locked into MS.
998469
I'm afraid that Dirty D is right.  Developing a database in MS Access isn't like firing up MS Word and cranking out a document.  You really need to begin with the basics of database design and go from there.  I located a pretty comprehensive tutorial website at:  http://www.functionx.com/access/.\n\nThe short answer to your question is that you click on "New" to create a new database.  I've never used Database Wizard, but I presume that it helps you structure a simple database.  That said, I'd still recommend that you at least check the above link to give you a better understanding of how Access works.
902750
Are you using .NET?\nIf so, I've done it in C#.\nI don't expect there will be all too big of a difference between the two. Also, if you're doing this for a website, I'd highly recommend MySQL over Access. Acess will bomb out on you -- especially if there are multiple concurrent connections. Send me an email if you need more help on it.\n\nusing System.Data.OleDb; //This might be different in C++\n\npublic void ConnectToDatabase()\n{\n  OleDbConnection dbConn;\n  string strConnection;\n\n  strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&#92;somepath&#92;mydb.mdb;User Id=admin;Password=;";\n/*go to www.connectionstrings.com for more info on connection strings*/\n\n  dbConn = new OleDbConnection(strConnection);\n  dbConn.Open();\n\n  //woot, the database is open!\n  OleDbCommand cmdCommand;\n\n  cmdCommand = new OleDbCommand();\n  cmdCommand.Connection = dbConn;\n  cmdCommand.CommandText = "SELECT * FROM tblItem";\n\n  OleDbDataReader rdReader;\n\n  rdReader = cmdCommand.ExecuteQuery();\n\n/*\nThe read function advances to the next row and returns true upon success\n*/\n  while(rdReader.Read())\n  {\n     //This command shows a pop-up of the string\n     //In Row #1 of the results (#0 is the first row)\n     MessageBox.Show(rdReader.GetString(1));\n  }\n\n  rdReader.Close(); //always close your reader or it gets mad\n  dbConn.Close();\n}