Jump to content
Sign in to follow this  
keteng

Create MDB file password

Recommended Posts

keteng

We're sorry.My English is very bad.

The code can work generated MDB files. But no password. May I ask how to create MDB file with a password.

Local $DbFileName = @ScriptDir & "\Test.mdb"

Local $UserID = "admin"

Local $PassWord = "Testpwd"

Local $ODBC_ADD_SYS_DSN = 4

Local $lpszDriver = "Microsoft Access Driver (*.MDB)" & Chr(0)

Local $lpszAttributes = "CREATE_DB=" & $DbFileName & " General" & Chr(0) & _

"UID=" & $UserID & Chr(0) & _

"PWD=" & $PassWord & Chr(0)

DllCall("odbccp32.dll","BOOL","SQLConfigDataSource","HWND",NULL, _

"WORD",$ODBC_ADD_SYS_DSN ,"str",$lpszDriver,"str",$lpszAttributes)

Share this post


Link to post
Share on other sites
water

Welcome to AutoIt and the forum!

Please search the Example Scripts forum. There is a MSAccess UDF which might have the function you are looking for.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
keteng

Thank you very much for your reply.

I search and download its function. But the same can not generate the MDB files with a password.

#include "MS_AccessDB.au3"

MS_AccessDatabaseCreate("MSDataBase.mdb","admin","123456789",0,True)

Share this post


Link to post
Share on other sites
water

What's the value of @error after you called MS_AccessDatabaseCreate?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
keteng

MS_AccessDatabaseCreate establish the success of the MDB file. No error return value.

Just MDB files with no password.

Share this post


Link to post
Share on other sites
water

What do you get when you rung:

Global $iReturn = MS_AccessDatabaseCreate("MSDataBase.mdb","admin","123456789",0,True)
MsgBox(0, "", $iReturn & "-" & @error)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-10-19 - Version 1.4.10.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×