Offline database

I don't know where to begin with this. We designed an online product
catalogue who now want to put it on a CD. Is there any third party piece of
software that could convert an sql server or access db into standalone
program that the client could put on a CD without he need for Access Forms,
OLEDB etc.
If I could put the db in XML could I point the Access runtime, which the
developer version of Office can export, at that as a datasource without the
need for OLEDB drivers.Chris
You can use data transformation services (DTS) to write out the data in lots
of different formats, one of which should be suitable for your purposes.
Maybe write it out so it can be read into an excel spread sheet?
Have a look into what you can do with it, I'm sure it will be the answer.
Regards
John
"Chris Kennedy" wrote:
> I don't know where to begin with this. We designed an online product
> catalogue who now want to put it on a CD. Is there any third party piece of
> software that could convert an sql server or access db into standalone
> program that the client could put on a CD without he need for Access Forms,
> OLEDB etc.
> If I could put the db in XML could I point the Access runtime, which the
> developer version of Office can export, at that as a datasource without the
> need for OLEDB drivers.
>
>|||Doing it like that wouldn't be a problem but there is the possiblity the
clients won't have office. I need some thing like an exe that will run on
any Windows machine. This is a bit OT but....
I was thinking if I could point the exported access runtime at an xml file
that I could stick it on a disc and not worry about what software they have
installed but does the Access runtime allow for querying?
"John Bandettini" <JohnBandettini@.discussions.microsoft.com> wrote in
message news:9040D3F6-81A7-4DF6-A794-B1644086413D@.microsoft.com...
> Chris
> You can use data transformation services (DTS) to write out the data in
> lots
> of different formats, one of which should be suitable for your purposes.
> Maybe write it out so it can be read into an excel spread sheet?
> Have a look into what you can do with it, I'm sure it will be the answer.
> Regards
> John
> "Chris Kennedy" wrote:
>> I don't know where to begin with this. We designed an online product
>> catalogue who now want to put it on a CD. Is there any third party piece
>> of
>> software that could convert an sql server or access db into standalone
>> program that the client could put on a CD without he need for Access
>> Forms,
>> OLEDB etc.
>> If I could put the db in XML could I point the Access runtime, which the
>> developer version of Office can export, at that as a datasource without
>> the
>> need for OLEDB drivers.
>>