PC Review


Reply
Thread Tools Rate Thread

Accesssing Access data-base without Access -- How?

 
 
Cyril N. Alberga
Guest
Posts: n/a
 
      3rd Jan 2008
I have been sent an Access data-base (.mdb filetype). I do not have any
MicroSoft Office programs installed on my computer. Is there anyway to look at,
and extract data from this file? I do have Paradox installed, but it seems to
require some sort of modules from Access (DAOs - "Data Access Objects"). Is
there a source for these.

I know that Paradox provides a free database engine to allow non-users to use
..db files. Does Access have such a thing?

Cyril
 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      3rd Jan 2008
Cyril

In many instances, an Access database is actually an Access-based
application. Are you interested in the data this file might contain, or the
application?

Have you checked on-line at Microsoft.com for a "reader"? Or for a
downloadable trial version?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Cyril N. Alberga" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have been sent an Access data-base (.mdb filetype). I do not have any
>MicroSoft Office programs installed on my computer. Is there anyway to
>look at, and extract data from this file? I do have Paradox installed, but
>it seems to require some sort of modules from Access (DAOs - "Data Access
>Objects"). Is there a source for these.
>
> I know that Paradox provides a free database engine to allow non-users to
> use .db files. Does Access have such a thing?
>
> Cyril



 
Reply With Quote
 
Tim Johnson
Guest
Posts: n/a
 
      3rd Jan 2008
If your interest is strictly in viewing the data, you might also look into
downloading Access 2007 runtime. It will work for Access 2003, as well. I
don't know if this will suit your purposes, but it's a quick download and may
be able to assist you.

"Jeff Boyce" wrote:

> Cyril
>
> In many instances, an Access database is actually an Access-based
> application. Are you interested in the data this file might contain, or the
> application?
>
> Have you checked on-line at Microsoft.com for a "reader"? Or for a
> downloadable trial version?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Cyril N. Alberga" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >I have been sent an Access data-base (.mdb filetype). I do not have any
> >MicroSoft Office programs installed on my computer. Is there anyway to
> >look at, and extract data from this file? I do have Paradox installed, but
> >it seems to require some sort of modules from Access (DAOs - "Data Access
> >Objects"). Is there a source for these.
> >
> > I know that Paradox provides a free database engine to allow non-users to
> > use .db files. Does Access have such a thing?
> >
> > Cyril

>
>
>

 
Reply With Quote
 
Cyril N. Alberga
Guest
Posts: n/a
 
      3rd Jan 2008
I'm after the data, if it is of interest. I went to the MS site, but it claimed
I didn't have cookies enabled (although I do -- I'm using FireFox). The file is
huge (about 1.18 Gb), so I feared that a "trial" version wouldn't handle it.

I'm going to follow up the next response, the Access run-time, first, then check
the MS site again -- that is if it will let me in to look for the run-time module.

Cyril

Jeff Boyce wrote:
> Cyril
>
> In many instances, an Access database is actually an Access-based
> application. Are you interested in the data this file might contain, or the
> application?
>
> Have you checked on-line at Microsoft.com for a "reader"? Or for a
> downloadable trial version?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Cyril N. Alberga" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> I have been sent an Access data-base (.mdb filetype). I do not have any
>> MicroSoft Office programs installed on my computer. Is there anyway to
>> look at, and extract data from this file? I do have Paradox installed, but
>> it seems to require some sort of modules from Access (DAOs - "Data Access
>> Objects"). Is there a source for these.
>>
>> I know that Paradox provides a free database engine to allow non-users to
>> use .db files. Does Access have such a thing?
>>
>> Cyril

>
>

 
Reply With Quote
 
Cyril N. Alberga
Guest
Posts: n/a
 
      3rd Jan 2008
Thank you. I'll check for Access 2007 runtime, and see if that fits my needs.

Cyril

Tim Johnson wrote:
> If your interest is strictly in viewing the data, you might also look into
> downloading Access 2007 runtime. It will work for Access 2003, as well. I
> don't know if this will suit your purposes, but it's a quick download and may
> be able to assist you.
>
> "Jeff Boyce" wrote:
>
>> Cyril
>>
>> In many instances, an Access database is actually an Access-based
>> application. Are you interested in the data this file might contain, or the
>> application?
>>
>> Have you checked on-line at Microsoft.com for a "reader"? Or for a
>> downloadable trial version?
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "Cyril N. Alberga" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> I have been sent an Access data-base (.mdb filetype). I do not have any
>>> MicroSoft Office programs installed on my computer. Is there anyway to
>>> look at, and extract data from this file? I do have Paradox installed, but
>>> it seems to require some sort of modules from Access (DAOs - "Data Access
>>> Objects"). Is there a source for these.
>>>
>>> I know that Paradox provides a free database engine to allow non-users to
>>> use .db files. Does Access have such a thing?
>>>
>>> Cyril

>>
>>

 
Reply With Quote
 
Cyril N. Alberga
Guest
Posts: n/a
 
      3rd Jan 2008
Tim Johnson wrote:
>


<snip>

> it's a quick download and may


I have to smile - 51 mbytes! (which took a couple of minutes). I can remember
connecting to my work computer from home with a 300 baud acoustic coupler!

Cyril

>
> "Jeff Boyce" wrote:
>
>> Cyril
>>
>> In many instances, an Access database is actually an Access-based
>> application. Are you interested in the data this file might contain, or the
>> application?
>>
>> Have you checked on-line at Microsoft.com for a "reader"? Or for a
>> downloadable trial version?
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "Cyril N. Alberga" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> I have been sent an Access data-base (.mdb filetype). I do not have any
>>> MicroSoft Office programs installed on my computer. Is there anyway to
>>> look at, and extract data from this file? I do have Paradox installed, but
>>> it seems to require some sort of modules from Access (DAOs - "Data Access
>>> Objects"). Is there a source for these.
>>>
>>> I know that Paradox provides a free database engine to allow non-users to
>>> use .db files. Does Access have such a thing?
>>>
>>> Cyril

>>
>>

 
Reply With Quote
 
George Nicholson
Guest
Posts: n/a
 
      3rd Jan 2008
Using Runtime would only work if the mdb file is a full featured application
that *and* was specifically designed to work with runtime. Runtime is *NOT*
a "viewer". There will be no access to tables, queries, forms, even
toolbars, etc. that the developer did not specifically include in the
application. Using Runtime to open a mdb file that wasn't designed to use
runtime will most likely result in a very, very empty Access window with no
menus and no ability to do anything except close the window.

If the OP only wants to view the data then *maybe* the Excel viewer would
allow him to import tables from Access. It's been a while since I've looked
at the limitations of the Excel viewer, so that might be wishful thinking.

--
HTH,
George



"Tim Johnson" <(E-Mail Removed)> wrote in message
news:9CC8A860-4CC4-4B04-94C4-(E-Mail Removed)...
> If your interest is strictly in viewing the data, you might also look into
> downloading Access 2007 runtime. It will work for Access 2003, as well.
> I
> don't know if this will suit your purposes, but it's a quick download and
> may
> be able to assist you.
>
> "Jeff Boyce" wrote:
>
>> Cyril
>>
>> In many instances, an Access database is actually an Access-based
>> application. Are you interested in the data this file might contain, or
>> the
>> application?
>>
>> Have you checked on-line at Microsoft.com for a "reader"? Or for a
>> downloadable trial version?
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "Cyril N. Alberga" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> >I have been sent an Access data-base (.mdb filetype). I do not have any
>> >MicroSoft Office programs installed on my computer. Is there anyway to
>> >look at, and extract data from this file? I do have Paradox installed,
>> >but
>> >it seems to require some sort of modules from Access (DAOs - "Data
>> >Access
>> >Objects"). Is there a source for these.
>> >
>> > I know that Paradox provides a free database engine to allow non-users
>> > to
>> > use .db files. Does Access have such a thing?
>> >
>> > Cyril

>>
>>
>>



 
Reply With Quote
 
Cyril N. Alberga
Guest
Posts: n/a
 
      3rd Jan 2008
So, I downloaded and installed it, but when I point it at the file I get, first,
a warning that it doesn't know where the file came from, and do I want to
continue, and second, a blank display. So, what ever this damn file is, I guess
it isn't readable by that program.

I'm going to have to go back to the source and find out exactly what kind of
animal I have here.

Thanks, anyway.

Cyril

Tim Johnson wrote:
> If your interest is strictly in viewing the data, you might also look into
> downloading Access 2007 runtime. It will work for Access 2003, as well. I
> don't know if this will suit your purposes, but it's a quick download and may
> be able to assist you.
>
> "Jeff Boyce" wrote:
>
>> Cyril
>>
>> In many instances, an Access database is actually an Access-based
>> application. Are you interested in the data this file might contain, or the
>> application?
>>
>> Have you checked on-line at Microsoft.com for a "reader"? Or for a
>> downloadable trial version?
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "Cyril N. Alberga" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> I have been sent an Access data-base (.mdb filetype). I do not have any
>>> MicroSoft Office programs installed on my computer. Is there anyway to
>>> look at, and extract data from this file? I do have Paradox installed, but
>>> it seems to require some sort of modules from Access (DAOs - "Data Access
>>> Objects"). Is there a source for these.
>>>
>>> I know that Paradox provides a free database engine to allow non-users to
>>> use .db files. Does Access have such a thing?
>>>
>>> Cyril

>>
>>

 
Reply With Quote
 
George Nicholson
Guest
Posts: n/a
 
      3rd Jan 2008
Access Runtime is not a "file viewer" it is an "application runner". If the
mdb file you have is not a fully blown, fully functional Access application
(developer designated startup forms, developer supplied toolbars & menus,
etc.), a blank display exactly what I would expect to see.

--
HTH,
George



"Cyril N. Alberga" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> So, I downloaded and installed it, but when I point it at the file I get,
> first, a warning that it doesn't know where the file came from, and do I
> want to continue, and second, a blank display. So, what ever this damn
> file is, I guess it isn't readable by that program.
>
> I'm going to have to go back to the source and find out exactly what kind
> of animal I have here.
>
> Thanks, anyway.
>
> Cyril
>
> Tim Johnson wrote:
>> If your interest is strictly in viewing the data, you might also look
>> into downloading Access 2007 runtime. It will work for Access 2003, as
>> well. I don't know if this will suit your purposes, but it's a quick
>> download and may be able to assist you.
>>
>> "Jeff Boyce" wrote:
>>
>>> Cyril
>>>
>>> In many instances, an Access database is actually an Access-based
>>> application. Are you interested in the data this file might contain, or
>>> the application?
>>>
>>> Have you checked on-line at Microsoft.com for a "reader"? Or for a
>>> downloadable trial version?
>>>
>>> Regards
>>>
>>> Jeff Boyce
>>> Microsoft Office/Access MVP
>>>
>>> "Cyril N. Alberga" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> I have been sent an Access data-base (.mdb filetype). I do not have
>>>> any MicroSoft Office programs installed on my computer. Is there
>>>> anyway to look at, and extract data from this file? I do have Paradox
>>>> installed, but it seems to require some sort of modules from Access
>>>> (DAOs - "Data Access Objects"). Is there a source for these.
>>>>
>>>> I know that Paradox provides a free database engine to allow non-users
>>>> to use .db files. Does Access have such a thing?
>>>>
>>>> Cyril
>>>
>>>



 
Reply With Quote
 
Cyril N. Alberga
Guest
Posts: n/a
 
      3rd Jan 2008
[Very strange, yours is the only message where my "reply" fails to quote the
whole thing. All the history has vanished. I can't find anything in my
settings to cause this, so it must be a property of your message. I'll have to
investigate further.]

Well, I don't have Excel either, so I'll, first try Quatropro, then see if I can
find "Excel viewer".

Cyril

George Nicholson wrote:
> Using Runtime would only work if the mdb file is a full featured application
> that *and* was specifically designed to work with runtime. Runtime is *NOT*
> a "viewer". There will be no access to tables, queries, forms, even
> toolbars, etc. that the developer did not specifically include in the
> application. Using Runtime to open a mdb file that wasn't designed to use
> runtime will most likely result in a very, very empty Access window with no
> menus and no ability to do anything except close the window.
>
> If the OP only wants to view the data then *maybe* the Excel viewer would
> allow him to import tables from Access. It's been a while since I've looked
> at the limitations of the Excel viewer, so that might be wishful thinking.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the change access developer 2007 do to the access data base? a Microsoft Access Form Coding 1 2nd Dec 2007 01:48 PM
Word Mail Merge w/Access Data Base - reports empty data base recor =?Utf-8?B?U3RldmUgUnV0bGVkZ2U=?= Microsoft Access Macros 1 13th Apr 2007 08:48 PM
Unsafe access to Access 2003 Data Base from MSWord mail merge =?Utf-8?B?UmFtb24gTWFydGluZXogT2x2ZXJh?= Microsoft Access Security 0 28th Jan 2005 01:05 AM
Exclusive access to a MS Access data base running in office 2003 Phil Microsoft Access 5 26th Jan 2005 01:01 PM
Access error when attempting to access a data base. See body MrB Microsoft Access 2 3rd Mar 2004 12:52 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:53 PM.