Author |
Message |
crashman
Joined: 16 Oct 2009 Posts: 8 Country: Guatemala |
|
Use mdw for the conection |
|
I try to use the assistant but I dont know how configure the conexion, the database use a file a mdw to validate the users for the database.
Thanks for the help
|
|
Fri Oct 16, 2009 8:18 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7951
|
|
|
|
If you mean custom MS Access workgroup file, it has nothing to do with SQL Assistant. As long as you have a working ODBC connection setup for your Access database, SQL Assistant can use that connection. Please ensure in the Connection Options you choose pre-configured ODBC profile, which should appear in the drop-down list, look for DSN=[your ODBC profile name here]
See the following screenshots for more details

|
|
Sat Oct 17, 2009 12:13 pm |
|
 |
crashman
Joined: 16 Oct 2009 Posts: 8 Country: Guatemala |
|
Thanks |
|
I find the answer in the connections string.
"Dbq=path\data.mdb;"
"SystemDB=path\file.mdw;"
"Uid=user;Pwd=Pass");
|
|
Sat Oct 17, 2009 12:50 pm |
|
 |
|