Creating Database Passwords in VB4

Creating Database Passwords in VB4

Jet 3.0 (32-bit VB4 only) includes a new security system basedon database passwords that you may use instead of the more complex,more secure, workgroup security system. This system allows youto set a single, all-user password to open a database. While muchsimpler to implement and use, this system is very easily compromisedbecause all users use the same password. In addition, it doesn’tlet you track individual user activity in a shared database. However,you can use both workgroup-based security and database passwordsat the same time.

Set a database password in VB using the NewPassword method ofthe database object, using code like this: 

 Dim wrk As WorkspaceDim dbPwd As DatabaseSet wrk = DBEngine.Workspaces(0)' You must open the database ' exclusively (note 2nd parameter).Set dbPwd = _wrk.OpenDatabase_        ("MyData.MDB", True)' Set the database password which ' currently is blank to "NewPass".dbPwd.NewPassword "","NewPass"
Share the Post:
data observability

Data Observability Explained

June 8, 2023

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

June 1, 2023

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

May 24, 2023

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

Show More