Re: Creating & accessing a database across CDs

I don't know if i got to realize Drews problem.

But i think he wants to run his db from the cd's. With Access db's that wont work, because each mdb creates an ldb file while opening. (locking mechanism).

But if you attach these DB to access and the db files are in a different format there could be a workaround.
If youre db contains different tables, split these Tables to diferent dbs and store each db on a different CD. In youre access db attach them and set the desired relationships. This could work, I think.

This should also work when using Powerbuilder Let Powerbuilder access youre little and smal lokal Access.mdb files.

alv
alv_at_wup.de

>
> I'm not sure if you've tried it yet ... but a couple of options...both deal
> with compression.
>
> Create an install of your DB using 'whatever' ....it should have an option
> for a single flat file ... even install builder does....
>
> Or just zip it....
>
> I had a 128MB DB ... actually, an ORACLE .dmp file .... and zipped it down
> to about 20MB. .. given a compression ratio of about 6X .... then a ~3.9GB
> DB should be able to be compressed down to fit on 1 CD(650MB)
>
> ....and I'm no expert on them ... but I've read that DVDs can handle
> 4.6GB...although $$$$
>
> ..and worse case, you can use a tape backup .... I know there are tape
 ....
> > I'm trying to create a series of 6 CDs containing a database of names
> > and addresses.... the amount of data is quite huge -- about 3-4 gig --
> > and it consists of many tables with links to be accessed using
> > Powerbuilder....

.. Received on Fri Sep 05 1997 - 00:00:00 CDT