Roedd <<Neily wedi ysgrifennu:

Hi,

I use the code below to query against an Access Database. I would
like to add a password to the database so that it can't be accessed
unless you have the password.

Would anyone know how I would add such a password to Access and how
to adapt the code below to use that password.

Thanks
Neil


In Access ToolsSecuritySet Database Password

In your code:

With conn
.Provider = "Microsoft.JET.OLEDB.4.0"
.Open DatabaseLocation, , "MyPassword"

End With

Rob