what is the main difference between oracle and access databases?
349386
The main difference between oracle and MS access is that oracle is a database server and MS Access is on a single user database not a server.   Oracle is a true production database and can handle many concurrent users.  \n\nI would also say that Oracle supports Procedural Language SQL (stored procedures and triggers) [PLSQL] whereas Access can only call them via macros.\n\nAccess tends to reside only on Windows systems wheras Oracle can reside on unix, windows, solaris.
123133
Microsoft Access is a great prototyping tool.  If you are building an Enterprise level system for thousands of users, you are going to run SQL Server or Oracle.  But, during the design, you can design the tables and relationships in Access and throw together a few forms in minutes and show the customer "what/when/where/how" very easily.  Then, when they say, "no, I want it to do this", you modify it quickly and show them the next idea.\n\nGenerating a visual "working" sample application is all about what prototyping is - and Access is a great tool...
492576
Can u elaborate the problem, The MS-Access has it own built in SQL building routine, if this is not solving your problem, then please explian the kind of connectivity or query u are passing so that i can understand it better..!
917348
Hi buddy,\n\nDatabase Management System is not a software or some kind of application. Its just a concept, It says how data are to be stored, maintained, modified or retrieved, etc.\n\nMs Access, Oracle, etc  are the softwares that come with the implementation of the Database Management System Concepts, where u can store ur data, retrieve it, delete it, etc. These softwares are bought by companies and are used for their database management.
296338
Both Oracle 9i Database and IBM DB2 Universal Database v8.1 support the ANSI SQL-92 entry level and do not support the ANSI SQL-92 intermediate level.\n\nThe dialect of SQL supported by Oracle 9i Database is called PL/SQL. The dialect of SQL supported by IBM DB2 v8.1 is called DB2 SQL dialect. \n\nFollowing is a brief comparison of PL/SQL and DB2 SQL dialect:\n\nIndexes  \n\nPL/SQL:\n\nB-Tree indexes,\nBitmap indexes,\nPartitioned indexes,\nFunction-based indexes,\nDomain indexes  \n\nDB2 SQL dialect:\n\nB-Tree indexes,\nBitmap indexes,\nPartitioned indexes,\nblock indexes,\ndimension block indexes  \n\nTables  \n\nPL/SQL:\n\nRelational tables,\nObject tables,\nTemporary tables  \n\nDB2 SQL dialect:\n\nRelational tables,\nObject tables,\nTemporary tables  \n\n\nTriggers  \n\nPL/SQL:\n\nBEFORE triggers,\nAFTER triggers,\nINSTEAD OF triggers  \n\nDB2 SQL dialect:\n\nBEFORE triggers,\nAFTER triggers,\nINSTEAD OF triggers  \n\nProcedures  \n\nPL/SQL:\n\nPL/SQL statements,\nJava methods,\nthird-generation language\n(3GL) routines  \n\nDB2 SQL dialect:\n\nDB2 SQL dialect statements,\nJava methods,\nthird-generation language\n(3GL) routines  \n\nMultiple Triggers  \n\nPL/SQL:\n\nSupported  \n\nDB2 SQL dialect:\n\nSupported  \n\nArrays  \n\nPL/SQL:\n\nSupported  \n\nDB2 SQL dialect:\n\nSupported  \n\nIt is not true that Oracle Database is better than DB2 Universal Database or vice versa. \n\nBoth products can be used to build stable and efficient system and the stability and effectiveness of your applications and databases depend rather from the experience of the database developers and database administrator than from the database's provider.\n\nSince both of them support ANSI SQL-92 which means all your SQL commands can work on Oracle which you used on DB2.\n\nWorking knowledge of both the products will be more or less the same however the architecture will be different.\n\nBut I recommend you apply for the programming job that requires your knowing Oracle. Refer to some Oracle books before going for interviews. Visit http://www.sharanamshah.com for book details.
396944
Access 97 supports only limited SQL queries. Most of these can be generated with the query designer functionality in Access, but if you want to access the database using more advance SQL commands, try writing a VB program to do it and use an OLEDB jet connection. Then you get whatever functionatily you want on it.\nGood luck!
959154
Standard Query Language is a datbase. Database is used for storing data. This data is inturn accessed by a front-end tool.
414886
VB,C++ and JAVA are programming langauages, of which VB is an event driven programming language, depending on version you are using. Because VB.net is more object oriented. And C++ and JAVA are more object oriented programming languages.\nMicrosoft Access and Oracle are Database Management Systems they are used as a link between the Application program and Operating System.
525806
database is like a huge table with information or entries.  Like information of similar groups of different records.  Dbms is basically, mananing all of those records.  Also database is storing as well as retreiving.
717198
A collection of tables and other objects that support an application is called a schema.\nA database is a collection of system and schema data stored in files.  The files are organized into tablespaces for ease of reference.\nAn instance is the collection of processes that open the database and provide services to other programs and users by communicating with user sessions.\n\n- If you select a tablespace of an existing database for your application, you need to know what other applications are using that database instance.  Your performance will depend on how much resources of that database are already tied up by the other application schemas and sessions.  Your application will also have to shut down when those other applications need downtime for maintenance.  When the other users of that database upgrade to another version of oracle, you will have to upgrade with them.\n- If you select another database, the server that your database will run on needs to have enough resources to support two SGA memory structures.  You would be able to have that database tuned specifically for your database and to keep it running when the other database is down.  However, if the server is not large enough for two databases, your performance will suffer.
39144
It's been a number of years since I worked with Access, but the answer above will work if the database is on another machine and you ONLY want to access the data over the network.  If, on the other hand, you need to download the .mdb to a laptop and take it on a plane, for example, I seem to recall there was an Access 'run time' option.  In that case, you'll probably want to compile your .mdb into a .mde file.  See the source(s) link.
511517
Does this help:\n\nhttp://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm\n\nhttp://www.quest-pipelines.com/newsletter-v7/0406_C.htm
1153856
You can't, you can only build a spreadsheet, or a single table database.  You can use Access to build DB's.\n\nIf you need tuturiols on how to create/manage a Access Database.  See the links below.
81
Define "best". Oracle is like a BMW. Expensive but has all the fixings. But not everyone needs a BMW. MySQL is like a VW Beetle (the old model). Its cheap, and gets you where you need to go. But you have to tweak it to suit your needs.
950967
Basically MS-Access is for small scale industries/businesses - thats what microsoft itself is claiming. MS Access cannot handle records more than say a few thousands. I myself have experienced it - after 80000 records - MS Access really struggles. However MS SQL Server is quite capable of handling large number of records/data - so does ORACLE.\n\nFor your requirement, MS Access will be just fine.
591587
Tatzug is quite right that you should link directly to the tables in the database on the server, and then Access will be able to see and use the correct data type for each field.  You do this as follows:\n\n1.  Set up an ODBC link to the SQL Server\n\nYou do this using the "DataSources (ODBC)" control panel, which is found under Administrative Tools.  This is actually a "wizard" which will lead you through the process of creating the ODBC link.\n\n2.  Inside Access, go to the File menu and select Get External Data, then Link Tables.\n\nWhen the file dialog opens, switch the File Type at the bottom to "ODBC Databases ()" and select the ODBC link you created in step 1.\n\nThen you'll get a dialog box which will allow you to select the database tables on the server you want to link to.\n\nGood luck!
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!