By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,261 Members | 1,674 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,261 IT Pros & Developers. It's quick & easy.

queying large data base

P: 17
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
Sep 27 '06 #1
Share this Question
Share on Google+
7 Replies


PEB
Expert 100+
P: 1,418
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
Sep 30 '06 #2

P: 17
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
Oct 3 '06 #3

P: 4
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
Oct 5 '06 #4

PEB
Expert 100+
P: 1,418
PEB
And to connect to Oracle U use an ODBC?

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

10x

:)
Oct 8 '06 #5

P: 17
it just stop repsonding, sometimes I get a ODBC error message.
Oct 10 '06 #6

PEB
Expert 100+
P: 1,418
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...

:(
Oct 14 '06 #7

P: 17
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...

:(
Nov 29 '06 #8

Post your reply

Sign in to post your reply or Sign up for a free account.