Shulou(Shulou.com)06/02 Report--

This article mainly introduces the VS2003 Access database use and maintenance skills, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to know about it.

Resolution steps:

1. Create a form

two。 Pull an OleDbConnection1.

3. Edit its properties: connectionString-- > New connection)

4. Open a tab: provider-Microsoft Jet 4.0 OLE DB Provider

Connect-Select an encrypted access database (db1.mdb, password: a

All-modify two values (double-click the row): 1 sixth Jet OLEDB:Database Password-- > a

The penultimate Persist Security Info-- > true

5. Go back to the "connection" option, the user name: Admin does not change, no longer need to enter the password, and then click the "allow password to be saved" option below

6. Test connection-> successful!

8. After selecting the SQL data, if the pop-up contains a password, click include (* options)

7. The string you get is:

Jet OLEDB:Registry Path= "D:"; Jet OLEDB:Database Locking Mode=1; Jet OLEDB:Database Password=a; Data Source= "D:\ db1.mdb"; Password=; Jet OLEDB:Engine Type=5; Jet OLEDB:Global Bulk Transactions=1; Provider= "Microsoft.Jet.OLEDB.4.0"; Jet OLEDB:System database=1; Jet OLEDB:SFP=True; Extended Properties=; Mode=Share Deny None; Jet OLEDB:New Database Password=; Jet OLEDB:Create System Database=False; Jet OLEDB:Don't Copy Locale on Compact=False; Jet OLEDB:Compact Without Replica Repair=False; User ID=Admin Jet OLEDB:Encrypt Database=False

In order to avoid unnecessary garbage data and database exceptions caused by VS2003 Access database testing, it is necessary to establish a transaction mechanism for database operation and carry out transaction rollback after testing. If you use NUnit to write transactions by hand, it is obvious that there is a large amount of code and is prone to errors, so it is recommended to use the EnterpriseServices component provided by NotNet for editing, which can greatly reduce the complexity of coding and improve the security of databases.

Thank you for reading this article carefully. I hope the article "what are the skills for the use and maintenance of VS2003 Access database" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.