MS Access 2000

  • Thread starter Thread starter KLINK
  • Start date Start date
K

KLINK

I need a program that will import a MS Access 2000 file. It is a 76 MB .mdb
file from the USDA website. This is what the USDA site says about this file:

This file contains the SR16 data imported into a MS Access database. It
includes relationships between files and a few sample queries and reports.
You need MS Access 2000 to use this file.
 
* KLINK Wrote in alt.comp.freeware, on Mon, 13 Oct 2003 14:39:47 -0500:
I need a program that will import a MS Access 2000 file. It is a 76 MB .mdb
file from the USDA website. This is what the USDA site says about this file:
Click to expand...
This file contains the SR16 data imported into a MS Access database. It
includes relationships between files and a few sample queries and reports.
You need MS Access 2000 to use this file.
Click to expand...

Open Office?

http://dba.openoffice.org/FAQ/FAQ.html#msaccess
 
You may download MS Access Viewer form Microsoft. It is free as all viewer.

Rejean
 
KLINK said:
I need a program that will import a MS Access 2000 file. It is a 76 MB .mdb
file from the USDA website. This is what the USDA site says about this file:
Click to expand...

I don't believe you're going to find anything other than Access that will read
an mdb file, KLINK.
 
I don't have MS Access, but I have read
a few .MDB files on my system using
ADO Desk ....

http://www.delphi-source.de/projekte/adodesk/

Version listed on the page is 0.7,
but the About box on the version I have
is listed as 0.94, so I'm not 100% sure
the above site is where I got it ...

Web site in German ....

No Documentation with the Program ....

Decent GUI DB browser ....

I connected to the MDB data bases
using MS Jet OLE DB Provider
from the Make Connection/Build option ...

Requires Microsoft Data Access Components ....
http://www.microsoft.com/data
 
Cousin said:
I don't have MS Access, but I have read a few .MDB files on my
system using ADO Desk ....
Click to expand...

Does it just read the tables (for that, you can just export them from
Access to [whatever]-delimited text files), or does it also handle
Access queries, forms and macros?
 
| I don't have MS Access, but I have read
| a few .MDB files on my system using ADO Desk
| ....

|| Does it just read the tables

Allows browsing various tables in the DB,
but one can also add/change/delete records ....

|| (for that, you can just export them from Access
|| to [whatever]-delimited text files),

Kind of tough to do if you DON'T have Access,
as neither I, nor apparently Cousin KLINK, do ....

Maybe the USDA would be so kind
as to do the export on individual request ....

|| or does it also handle Access queries, forms and macros?

One can write SQL queries against the data base ....

I'm not familar with Access Forms or Macros,
but there seems to be provisions for stored procedures,
but I haven't experimented with them yet ....

Files or data sets resulting from queries
can be exported in either binary or XML format ....

ADO Desk seems to be a good general purpose
data base browser/editor, but I'm sure
it's not a 1_to_1 functional replacement
for Access or any other full-blown DB manager ....
 
Cousin said:
| I don't have MS Access, but I have read
| a few .MDB files on my system using ADO Desk
| ....
Click to expand...
|| Does it just read the tables
Click to expand...
Allows browsing various tables in the DB,
but one can also add/change/delete records ....
Click to expand...
|| (for that, you can just export them from Access
|| to [whatever]-delimited text files),
Click to expand...
Kind of tough to do if you DON'T have Access,
as neither I, nor apparently Cousin KLINK, do ....
Click to expand...

Of course. I should've said "an Access owner can just export..."
Maybe the USDA would be so kind
as to do the export on individual request ....
Click to expand...
|| or does it also handle Access queries, forms and macros?
Click to expand...
One can write SQL queries against the data base ....
Click to expand...
I'm not familar with Access Forms or Macros,
but there seems to be provisions for stored procedures,
but I haven't experimented with them yet ....
Click to expand...
Files or data sets resulting from queries
can be exported in either binary or XML format ....
Click to expand...
ADO Desk seems to be a good general purpose
data base browser/editor, but I'm sure
it's not a 1_to_1 functional replacement
for Access or any other full-blown DB manager ....
Click to expand...

Thanks, Cuz.
 
SINNER said:
* WebWalker Wrote in alt.comp.freeware, on Tue, 14 Oct 2003 23:02:05 +0800:
Click to expand...
Yes.
Click to expand...

Only to the extent, I believe, of retrieving the raw data. Doesn't
appear to be compatible with the rest of that mdb, which is more than
just the data itself.
 
* Blinky the Shark Wrote in alt.comp.freeware, on 14 Oct 2003 16:03:37 GMT:
SINNER wrote:
Click to expand...
Only to the extent, I believe, of retrieving the raw data. Doesn't
appear to be compatible with the rest of that mdb, which is more than
just the data itself.
Click to expand...

I havent tried, nor read this article in its entirety:

http://articles.linmagau.org/module...s&file=index&req=viewarticle&artid=230&page=1

http://tinyurl.com/qwnz

But it looks like you can get pretty close to Access Fuctionality with
some work.

--
David | AGM Favorite Games - http://tinyurl.com/loec
Asleep at the switch! I wasn't asleep! I was drunk!

-- Homer Simpson
Homer The Vigilante
 
SINNER said:
* Blinky the Shark Wrote in alt.comp.freeware, on 14 Oct 2003 16:03:37 GMT:
Click to expand...
I havent tried, nor read this article in its entirety:
Click to expand...

I have...
http://articles.linmagau.org/module...s&file=index&req=viewarticle&artid=230&page=1

But it looks like you can get pretty close to Access Fuctionality with
some work.
Click to expand...

....and it makes no claims about being able to use anything but the raw
data from an Access mdb file. It claims the ability to do some Access-like
things (reports, queries, forms), as I'd say all db management systems
can do -- but nothing in the way of using the stuff you've already
created and incorporated in that mdb file. IOW, it has the capability
of making you start all over again, except for the data itself.
 
Blinky said:
SINNER wrote:
Click to expand...
I have...
Click to expand...
...and it makes no claims about being able to use anything but the raw
data from an Access mdb file. It claims the ability to do some Access-like
things (reports, queries, forms), as I'd say all db management systems
can do -- but nothing in the way of using the stuff you've already
created and incorporated in that mdb file. IOW, it has the capability
of making you start all over again, except for the data itself.
Click to expand...

Which, I should point out, is not meant to be a complaint, as much as
a reiteration of the fact that there's a lot more to an mdb file than
just the raw data -- there's the whole management system the user has
built around it, and that's not something that seems to be salvageable.
 
* Blinky the Shark Wrote in alt.comp.freeware, on 14 Oct 2003 20:41:23 GMT:
SINNER wrote:
Click to expand...
I have...
Click to expand...
...and it makes no claims about being able to use anything but the raw
data from an Access mdb file. It claims the ability to do some Access-like
things (reports, queries, forms), as I'd say all db management systems
can do -- but nothing in the way of using the stuff you've already
created and incorporated in that mdb file. IOW, it has the capability
of making you start all over again, except for the data itself.
Click to expand...

Ouch! Useless then at least for the OP. Thanks for the clarification
B-Meister :)
 
Réjean Dutil said:
You may download MS Access Viewer form Microsoft. It is free as all viewer.

Rejean
Click to expand...

Thanks for the reply. The viewer was called Snapshot Viewer and I get an
error message telling me that an error occurred while opening a Snapshot
file.
 
Le Mon said:
I need a program that will import a MS Access 2000 file. It is a 76 MB .mdb
file from the USDA website. This is what the USDA site says about this file:

This file contains the SR16 data imported into a MS Access database. It
includes relationships between files and a few sample queries and reports.
You need MS Access 2000 to use this file.
Click to expand...
IBEasy+
http://nte-socio.univ-lyon2.fr/Marc_Grange/TeleCharger_en.htm
An easy, and user friendly, access to Interbase/FireBird main
functionalities, both in user mode and in administrator mode:

-Specialized editors for: Tables, Views, Domains, Stored Procedures,
Triggers, Indexes, Generators, Exceptions.
-SQL: Expert mode (with history), visual mode (QBE: Query By Example),
-Backup, restore, shut down, and restart functionalities
-Grant manager
-Export to Word, RTF, TXT, Excel, CSV, SYLK, DIF, MS Access
-Import of MS Access databases: tables, records, referential integrity
constraints
-Export of Interbase/Firebird databases to MS Access: tables, records,
referential integrity constraints
-Management of auto-increment fields and default values
-BLOB's viewers and editors. Specialized editors for text, image sound and
video BLOBs. Hexadecimal editor for other types of BLOBs.
 
Back
Top