Replication with Jet 4.0

[Paolo F Cantoni]

Has anybody had success with .EAP replication under MS JET 4.0 engine?  I heard a statement that it didn't work.

Were there any issues that had to be overcome or was it straight forward?

Before attempting it, I thought I'd check first...

Cheerz,

Paolo

[sargasso]

Suggest you get on to www.databaseadvisors.com and get into their accessd forum.

If there are any issues with Access Jet 4 replication they will be the ones to know.

bruce

[thomaskilian]

Is there any reason for using 4.0. I mean: do you import structures from  Access very often? If you don't have a real reason, stay with the default Jet.

[sargasso]

AFAIK Jet 4 allows you to use the later MDAC versions, which IMO are a bit more stable than <=2.3

Apart from that, as I use MDAC technologies for various other things I just like to keep the number of MDAC versions on the machine as low as possible.

Apart from that,  Jet 4 is slightly faster for MSAccess than previous versions.  How this translates into EA I have not investigated.  Perhaps someone could compare a "large" report generation on both versions?

bruce

[driedtoast]

Here is a tip I noticed.

If you create your project off of EABase.eap the default database seems to be in the Jet 3.5 format and if you have the option set to Jet 4.0 it doesn't allow you to create this project as a Design Master.

Solution:

1. Close your project in EA
2. Open in Access 2000 (or greater)
3. Tools > Database Tools > Convert to Current Database and select your EAP file
4. Open your project again in EA
5. Make  Design Master
6. Create replicas.

Hopefully this helps a few people. It seems replication works after that but I am still playing around with it.

[thomaskilian]

Is there any way to achieve that without having MS Access installed?