J jeva39 Well-known member Joined Jan 28, 2005 Messages 135 Location Panama Programming Experience 1-3 May 19, 2005 #1 I need to use ID and Password in a Access Database. Please, what is the correct syntax for the Connection String? Thanks!
I need to use ID and Password in a Access Database. Please, what is the correct syntax for the Connection String? Thanks!
kulrom Well-known member Joined May 10, 2005 Messages 2,854 Location Republic of Macedonia Programming Experience 10+ May 19, 2005 #2 ODBC Standard Security: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;" Workgroup: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;" Exclusive: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd=" OLE DB, OleDbConnection (.NET) Standard security: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;" Workgroup (system database): "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;" With password: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB: database Password=MyDbPassword;" Upvote 0 Downvote
ODBC Standard Security: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;" Workgroup: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;" Exclusive: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd=" OLE DB, OleDbConnection (.NET) Standard security: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;" Workgroup (system database): "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;" With password: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB: database Password=MyDbPassword;"
kulrom Well-known member Joined May 10, 2005 Messages 2,854 Location Republic of Macedonia Programming Experience 10+ May 19, 2005 #3 I think it has been moved to wrong section/forum ... actually it was well into the previous section as it refers to VB.NET & Data Access ... it's not big deal... but I think it might be a bit confusing for the original threader Cheers Last edited: May 19, 2005 Upvote 0 Downvote
I think it has been moved to wrong section/forum ... actually it was well into the previous section as it refers to VB.NET & Data Access ... it's not big deal... but I think it might be a bit confusing for the original threader Cheers
J jeva39 Well-known member Joined Jan 28, 2005 Messages 135 Location Panama Programming Experience 1-3 May 19, 2005 #4 Thanks.... Regards Upvote 0 Downvote