This article is a mirror article of machine translation, please click here to jump to the original article.

View: 11330|Reply: 0

[Source] SQL Server imports the MDB database with password and gets an error solution

[Copy link]
Posted on 5/15/2015 8:30:53 PM | | |
Unable to launch the application. The workgroup information file is missing or has been opened exclusively by another user. (Microsoft JET Database Engine)


When using the Access database with a password, the application cannot be launched, the workgroup information file is missing, or it has been opened exclusively by another user.

The solution is as follows:

Modify the password part of the database connection string to Jet OLEDB:Database Password=pwd.



eg.  Original connection string: "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Database; User ID=Admin; password=password"

Modified as follows: "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Database; User ID=Admin; Jet OLEDB:Database Password=Password"



This will solve the problem.





Previous:Graduation Season Show your graduation photos and class photos!
Next:SQL Server Creates Tables Add Primary Keys Add columns Commonly used SQL statements
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.

Mail To:help@itsvse.com