Access 95 to 2000 and back question

[Jimmy G]

I have designed a database in Access 2000 and wish to put it on someone's
computer (with 95) for data-entrey. I would then like to put it back on my
2000 system. Can anyone offer help?

 

[John Nurick]

Hi Jimmy,

I've never tried this, but in principle you can use
DBEngine.CompactDatabase (see Help) to convert the database to Jet
version 2 file format and then open it with Access 95 and try to make it
work. The conversion process should handle the data OK unless you've
used any features that aren't available in Access 95, but other things
may not survive intact.

Alternatively, just work in Access 95 to build a minimal "data-entry"
version of the application.

When the data entry is complete, don't try to convert back to Access
2000 format. Instead, import the data into the Access 2000 database,
using (temporary) linked tables to connect to the Access 95 one and
append queries to move the data into the Access 2000 tables.



On Sun, 2 Jan 2005 21:55:01 -0800, "Jimmy G" <Jimmy

 

[Jimmy G]

Thanks John,

I was already considering building a quick and dirty data
entry instance on the 95 system. I think I'll go that route. If I'm slick
about it, could I build the tables to exactly match the original database and
just copy and paste the data in the table, mabey transfer it from one
computer to the other using Excel? I'll figure that part out, thanks for
confirming my thoughts on building a quick data entry instance.

 

[John Nurick]

As I said, you can use linked tables and append queries to move the data
from the Access 95 database (which Access 2000 will be able to open) to
Access 2000. No need to muck round with Excel or the clipboard.