Dealing with Secured Jet Databases

This chapter has already discussed dealing with user IDs and passwords in non-Jet, ODBC Direct data sources. This is usually managed in a connection string, whether that string is supplied as the value of the Connection object's ConnectString property or as an argument to its Open method.

As mentioned in the prior section, “Opening a Database Using DAO,” DAO does not offer a Connection object that is distinct from a Database object. Furthermore, Jet databases are secured in a fashion that's very different from, say, a SQL Server database. This section provides an overview of the ways that Jet databases—specifically, Access databases—are secured, as well as code that enables you to deal with them.

An Access database ...

Get Managing Data with Microsoft® Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.