Convert 32-BIT MDB Database to 16-bit database 
Author Message
 Convert 32-BIT MDB Database to 16-bit database

Unfortunately you can't go back !! You can export tables from v7 to v2 but
that is all. You can link v2 tables to v7 but not vice versa

rgds
Rob Agnew
r&d TeamSoft



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



Sun, 16 May 1999 03:00:00 GMT  
 Convert 32-BIT MDB Database to 16-bit database

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



Sun, 16 May 1999 03:00:00 GMT  
 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



Mon, 17 May 1999 03:00:00 GMT  
 Convert 32-BIT MDB Database to 16-bit database

Quote:

>>> The owner of the company does not want to upgrade the computers. <<<


Essentially what it boils down to is writing a conversion program to
move the data over to an Access 2.5 database and getting rid of any
JET 3.0 specific code you've done.

My point is why doesn't the owner want to upgrade the systems. Even
if they're older 486's they could get memory upgrades to at least
16mb for a very reasonable price and, unless the app is a monster,
have adaquate performance. If the owner hasn't priced RAM recently,
you might want to bring this up by comparing the cost of a RAM
upgrade to your programming time.

I would 'ballpark' your development time at $30/hr and the RAM at
$150 a system (assuming a 4mb to 16mb upgrade) and ~$900 for the
Win95 upgrades. If the conversion effort takes you more than about 12
days the cost of the upgrade is cheaper. Note that the RAM upgrade
might be necessary anyway to get adaquate performance out of the
16-bit VB4 program you would have to develop. If all you need is the
Win95 upgrade, this reduces the time/cost difference to a mere 4 days.

Anyway, make sure that it is really a good business decision and not
one based on them considering your programming time as a 'freebie'.

Frank Carr



Tue, 18 May 1999 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. 16 bit & 32 bit users which database

2. Desperate for help Converting 16 bit app to 32 bit

3. Convert 16-bit vbp to 32-bit?

4. Converting 16 bit to 32 bit

5. Problems converting from 16 bit to 32 bit

6. Converting Reports from 16-bit to 32-bit??

7. converting 16-bit VB4/Access2 to 32-bit

8. Converting a VB4.0 16 Bit app to VB5 32 bit

9. URGENT! Convert 32-bit to 16-bit

10. Converting 16 bit to 32 bit VB 4.0 Pro

11. 8-bit, 16-bit & 32-bit Colour

 

 
Powered by phpBB® Forum Software