Open Access files that have a huge volumes of information

M

mantis01

Do you know the name of a "freeware" type program that allows you to open
files that have a huge volumes of information (i.e., 250,000+ rows and 30+
columns?

I am having issues with linking in Access and need to check some of the data
by looking at the flat file.
 
M

mantis01

I am not quite sure what I s wrong that is why I want to look at the file
outside of Access
 
M

mantis01

Because it is acting flaky as so many Micro$oft products do so I want to
view the data outside of access
 
L

Lynn Trapp

J

John Vinson

Do you know the name of a "freeware" type program that allows you to open
files that have a huge volumes of information (i.e., 250,000+ rows and 30+
columns?

I am having issues with linking in Access and need to check some of the data
by looking at the flat file.
Click to expand...

If the "flat file" is a text file (.txt, .csv extension) you can use
Wordpad or any text editor, such as UltraEdit; if it's an Access
database table, you can link to it in Excel (and see the first 64K
rows). I don't know of non-Microsoft free programs which can explore
an Access database.

As others have asked - if you're having specific problems, please post
the specific problems, and a description of the structure and medium
of your "flat file". You haven't even said whether it's an Access
table, a text file, or something else - it's more than a bit difficult
to give good advice in the dark!

John W. Vinson[MVP]
 
A

Albert D.Kallal

mantis01 said:
Do you know the name of a "freeware" type program that allows you to open
files that have a huge volumes of information (i.e., 250,000+ rows and 30+
columns?
Click to expand...

Any of the visual studio products (be it VB, vb.net, c++ etc) do include the
libraries that let open and use a mdb file. Remember, ms-access is just a
tool that lets you CONNECT to your favorite database, be it a JET based mdb
file, sql server, Oracle, MySql etc. So, ms-access is NOT the database
system its self, as you can use ms-access with oracle if you wish.

If you don't want use ms-access, the you can use the tools and libraries
provided in VB, or vb.net to read mdb files.

It is not clear if you are having problems with ms-access, or the actual
database? I can't imagine that a freeware library exists that has been more
battle hardened then the DAO library's (they been around at least 10+
years...and are very battled hardened).

Many Many commercial products use the JET data engine (so does ms-access by
the way). So, products like CityDesk (a web content manager), Simply
Accounting (a popular accounting package), and even a version of JET was/is
used in Microsoft's Exchange server, and Directory services.

And, this means that ms-access can actually open CityDiesk, or even Simply
Accounting files.

If commercial products based on JET can be used for accounting and content
management, then I don't see why JET with a file of 250,000 records should
pose any problems for you (likely, it is the users of the tools, and the
designers that must take the blame here for problems).

A file of 250,000 reocrds + 30 rows is not that large for jet to handle at
all.........

So, virtually any developer tools from the MS stable include the JET
libraries for free, and they can be distributed for free also. There is
number of free tools that developers have released that read mdb files, but
they are ALL based on the JET libraries anyway. I just don't see where you
are going here.....
 
T

Tony Toews

mantis01 said:
Do you know the name of a "freeware" type program that allows you to open
files that have a huge volumes of information (i.e., 250,000+ rows and 30+
columns?
Click to expand...

That isn't huge. I have a few databases considerably larger with no
performance problems.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top