Read this and you will see questions

Z

ZOCOR

Hi

Questions:

1. Is MS Access a relational database?
2. How many table rows and columns can MS Access handle before it gets too
slow?
3. Is SQL the query language people still using? are newer query languages
available that work with MS Acess?

Thanks you

ZOCOR
 
D

Douglas J. Steele

Sounds like this is homework related...

1) Pretty much, yes. It all depends on your definition of relational
database. I don't believe any DBMS actually meets all of the requirements
for a relational database.

2) 255 columns. There's no row limit per se, although an MDB file cannot
exceed 2 Gb (1 Gb for Access 97 and earlier), and a table cannot span
multiple MDBs.

3) Yes. I'm not aware of any "newer query languages"
 
Z

ZOCOR

1) Pretty much, yes. It all depends on your definition of relational
database. I don't believe any DBMS actually meets all of the requirements
for a relational database.

2) 255 columns. There's no row limit per se, although an MDB file cannot
exceed 2 Gb (1 Gb for Access 97 and earlier), and a table cannot span
multiple MDBs.
Click to expand...

Well there must be some limitation or otherwise MS would not come up with MS
SQL server

Whats MDBs by the way?
3) Yes. I'm not aware of any "newer query languages"
Click to expand...

i think pl-sql is newer
 
D

Douglas J. Steele

ZOCOR said:
Well there must be some limitation or otherwise MS would not come up with MS
SQL server
Click to expand...

Not really. You can't compare Access and SQL Server. Access is a development
environment that happens to include a DBMS (actually, two now, since you can
use a Jet database or MSDE, which is a stripped down version of SQL Server).
SQL Server is strictly a DBMS: you don't get any user interface with it at
all. Besides, Access is a file-based application, whereas SQL Server is
server-based. SQL Server offers extensive security, logging, backup, and so
on. While Access offers security, no file-based application is truly secure.

In any case, there is not any limit in terms of number of rows, strictly in
terms of file size.
Whats MDBs by the way?
Click to expand...

Jet databases (i.e.: the database stored by an Access application) have an
extension of .MDB
i think pl-sql is newer
Click to expand...

I believe PL-SQL is specific to Oracle (just as T-SQL is specific to SQL
Server).

While we're on the subject, recognize that there are many different dialects
of SQL. SQL that works with Oracle may not work with SQL Server may not work
with Access.
 
Z

ZOCOR

with

Not really. You can't compare Access and SQL Server. Access is a development
environment that happens to include a DBMS (actually, two now, since you can
use a Jet database or MSDE, which is a stripped down version of SQL
Click to expand...
Server).


1. What do you mean by a development environment? I gather you mean Access
creates programs in the form of access forms and reports?

2. What is Jet database? and how does that relate to Access? same questions
with regard to MSDE.

I believe PL-SQL is specific to Oracle (just as T-SQL is specific to SQL
Server).

While we're on the subject, recognize that there are many different dialects
of SQL. SQL that works with Oracle may not work with SQL Server may not work
with Access.
Click to expand...

I will assume your right because I can't be bothered to check. In all cases,
it's interesting comments you have made.

I believe O-SQL is a new query language that is object based.


ZOCOR
 
Top