Create MDB file password

[keteng 0]

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)

[water 2,116]

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.

[keteng 0]

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)

[water 2,116]

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

[keteng 0]

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

Just MDB files with no password.

[water 2,116]

What do you get when you rung:

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

[keteng 0]

The return value is "True-0"