queying large data base

[GinnyP]

Hi,
Can access handle queries that select from tables contain more than 2 gigs in each table? What is the limit that access can handle and how long do it take?

Thanks
GinnyP

[PEB]

Hi Virginia,

As I've read in the documentation it seems that as fron end application Access can treat a large amount of data!

But in fact it doesn't do it...

This is done from the database to which Access send the respective SQL and obtain the results...

In few cases Access attempts to treat the data with his proper engine... When there is a user specified function in the query or built in function proper to Access!

However u have to try it but not with all the data coz your computer will explode if your system isn't NTFS!

Simply do a link to the respective database and connect the tables... Maybe you can open them from Access, maybe this will give you a good results...

I'm afraid but I don't have answer to this questions... When U try it U will say and inform us :) I hope!

Take care my frien :)

Vladimir

[GinnyP]

Hi,

I did try and it did explode, but I have not given up yet.I am rewriting SQL query and will let you know if it works.

Thanks for your support

GinnyP

[NS3687]

GinnyP,

I had experience this, when data table is around 1,000,000 rows with 40-50 columns, MS Access performance drops drastically. Larger than that it is running at a slow snail pace. Often, it exploded.

Suggest you use real SQL or Oracle for that kind of heavy duty job

NS3687

[PEB]

And to connect to Oracle U use an ODBC?

Is there any special fault that appears or it doesn't responding?

10x

:)

[GinnyP]

it just stop repsonding, sometimes I get a ODBC error message.

[PEB]

So

In this case it's strange how can be Access a front end application for Oracle???

Maybe for smaller data???

It's true that for things smaller than 2 gigs in some cases it's better than the heavy solutions and offers more ability to threat the data...


But for scalability its better to use sth bigger than the capacity of Access...

:(

[GinnyP]

I have linked to tables in DB2 with more than 2 gigs. Very large

So

In this case it's strange how can be Access a front end application for Oracle???

Maybe for smaller data???

It's true that for things smaller than 2 gigs in some cases it's better than the heavy solutions and offers more ability to threat the data...


But for scalability its better to use sth bigger than the capacity of Access...

:(