-
I am using ADO to create an encrypted database, this is the code I use
Code:
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
-
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
-
Cheers Ian
I'll try that and see what happens
-
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...
-
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