Exporting mass MS Word and Excell OLE's to seperate MS Word and Excell files from Access 97 DB

[Charles]

Dear Readers,

I am intern at an IT company. I have been given a task to extract MS
Word and Excell files, stored as OLE's in a MS Access 97 database.
There are several hundred files, so I was wondering if there was a way
to automate a process to extract them into one directory. They need to
be in there own prospective files and formats (.doc and .xls). Thanks
in advance.

 

[John Nurick]

Hi Charles,

There's no neat way of doing it in Access 97. This is neat but only
works in later versions: http://www.lebans.com/oletodisk.htm

Here's a KB article that shows the older approach to exporting an
embedded document from a single record.
How to Save a Copy of an Embedded MS Word Document
http://support.microsoft.com/kb/132003/

To export multiple records, move the form from record to record.

 

[Frosty]

Dear Mr. Nurick,

Thank you for advice. I am going to try to convert the DB to Access
2000. I keep running into a few problems when trying to do so though.
I'm sure if its a problem, but in Access 97, I am prompted that the DB
has reached its maximum size. When I try to open it in Access 2000, it
won't convert. Here's the prompt it gives me:

The current user account doesn't have permission to convert or enable
this database.

Here's a picutre of the window:
http://i6.tinypic.com/152iyw5.jpg

I am very new to databases, so I've been playing around with the
permissions to the DB in Access 97, but to no avail.

 

[John Nurick]

Hi Frosty,

You need to compact the database if it's getting near its maximum size. For
Access 97, that is 1 GB (i.e. about 1,000,000 KB as shown in Windows
Explorer). Before you compact it, make sure you have a fresh backup copy -
and preserve that in case the problems you've been having are signs of
anything more serious in the database.

If you're working at a company that knows its stuff, there may well be
security on the database that will prevent you converting it to another
version of Access. Check with the person who owns the database, or the
network administrator.

Dear Mr. Nurick,

Thank you for advice. I am going to try to convert the DB to Access
2000. I keep running into a few problems when trying to do so though.
I'm sure if its a problem, but in Access 97, I am prompted that the DB
has reached its maximum size. When I try to open it in Access 2000, it
won't convert. Here's the prompt it gives me:

The current user account doesn't have permission to convert or enable
this database.

Here's a picutre of the window:
http://i6.tinypic.com/152iyw5.jpg

I am very new to databases, so I've been playing around with the
permissions to the DB in Access 97, but to no avail.

 

[Frosty]

Dear Mr. Nurick,

Thank you much again. Your inforamtion helped me out alot. Take care
now.

Hi Frosty,

You need to compact the database if it's getting near its maximum size. For
Access 97, that is 1 GB (i.e. about 1,000,000 KB as shown in Windows
Explorer). Before you compact it, make sure you have a fresh backup copy -
and preserve that in case the problems you've been having are signs of
anything more serious in the database.

If you're working at a company that knows its stuff, there may well be
security on the database that will prevent you converting it to another
version of Access. Check with the person who owns the database, or the
network administrator.