Why can't I

[Gary.Lowe]

I am using ADO to create an encrypted database, this is the code I use



Dim cat As New ADOX.Catalog
cat.Create ("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\new.mdb;" & _
"Jet OLEDB:Encrypt Database=True;" & _
"Jet OLEDB:Engine Type=5;")


If I use Engine Type 4 it throws an invalid arguement error up.

I can only create an Access 2 version or Access 2000.
Does anybody know why I can't create an Access 97 version.

Does anybody know the best way to create a database through code so that anyold person can't look at the contents, I'm not sure if this is the best method.


Thanks

[Ianpbaker]

Hi gary

I might be talking out of my arse but i think you need to use jet 3.5 for access97.

it might work

Ian

[Gary.Lowe]

Cheers Ian

I'll try that and see what happens

[FrancisC]

I'm fairly new at that stuff, but is Engine Type=5 not what you need for a 4.0 Jet provider ? If you specify Engine Type=4 would be for the 3.51 Jet...

...just reaching here.... actually asking as much as giving hints...

[Gary.Lowe]

Cheers

I have tried using 3.5 but that doesn't work either.

I have used the type 4 to compact into an access 97 database through ADO using 4.0 and that works fine.

It is not a massive problem but it's just nice to have that function