
Convert 32-BIT MDB Database to 16-bit database
Quote:
> I have recentlly completed a point-of-sale program and it has been in
> use for some time now. However all the users were originally on
> Windows 95. Now there are 11 Windows 3.11 computers that must be
> networked into the system however since the datbase is 32-bit, the
> Windows 3.11 computer can't access the data. Is there a way to
> convert the database without losing the information.
> P.S.
> The owner of the company does not want to upgrade the computers.
> Thanks in advance,
> Dave
VB4 comes with both the 32 and 16 bit jet engines.
Try this.
Create a duplicate, empty database using the 16-bit DataManager from VB4 or
16-bit Access.
In 32-bit VB4, write an application which will copy the *data* from one
database to the other. You will end up with a 16-bit and 32-bit version of
your database.
Recompile your original code into 16-bit for use on the Win3.11 systems.
Some issues to consider:
1) Uninstall 32-bit VB4 prior to installing 16-bit VB4; or use a separate
machine for 16-bit VB4. Creating distribution disks on a computer with
both versions of VB4 installed can cause problems.
2) Perform all of your integrity checks and verifications on the 16-bit
database from 32-bit VB4. VB4 32-bit will automatically use Jet2.5 to
access a 16-bit database.
3) Your existing Win95 systems might not be able to access the new 16-bit
database. They should be able to, but you'll have to check. Worst case
scenario you will have to re-distribute your application in 16-bit to your
Win95 users.
--
Don Good