What is the connection string for connecting to an MS ACCESS database?

ODBC Driver for Access

For Standard Security:

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
                   "Dbq=c:\somepath\mydb.mdb;" & _
                   "Uid=Admin;" & _
                   "Pwd=;"

If you are using a Workgroup (System database):

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
                   "Dbq=c:\somepath\mydb.mdb;" & _
                   "SystemDB=c:\somepath\mydb.mdw;", _
                   "admin", ""

If MDB is located on a network share:

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
                   "Dbq=\\myServer\myShare\myPath\myDb.mdb;"

g118481---->  These are your open questions here.  Many date back to the year 2000.  Help requested, help given and open today.

https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=11397018
https://www.experts-exchange.com/jsp/qShow.jsp?ta=winnt&qid=20171262
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20166677
https://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=11811578
https://www.experts-exchange.com/jsp/qShow.jsp?ta=java&qid=20192428
https://www.experts-exchange.com/jsp/qShow.jsp?ta=java&qid=20006788
https://www.experts-exchange.com/jsp/qShow.jsp?ta=javascript&qid=11947538
https://www.experts-exchange.com/jsp/qShow.jsp?ta=javascript&qid=11626838
https://www.experts-exchange.com/jsp/qShow.jsp?ta=javascript&qid=11373117
https://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20233826
https://www.experts-exchange.com/jsp/qShow.jsp?ta=asp&qid=20182621
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20268689
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20263774
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20256576
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20187192
https://www.experts-exchange.com/jsp/qShow.jsp?ta=coldfusion&qid=20121821

Your options are:

1.  Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you. You must tell the participants why you wish to do this, and allow for Expert response.
3.  Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process.
4.  Delete the question. Again, you must tell the other participants why you wish to do this.

Please click this Help Desk link for Member Guidelines, Member Agreement and the Question/Answer process:  Click you Member Profile to view your question history and keep them all current with updates as the collaboration effort continues.

https://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp

PLEASE DO NOT AWARD THE POINTS TO ME.  
_________________________________________
------------>  EXPERTS:

Please leave any comments regarding this question here on closing recommendations if this item remains inactive another three days.

Thank you everyone.

Moondancer
Community Support Moderator @ Experts Exchange

P.S.  For year 2000 question, special attention is needed to ensure the first correct response is awarded, since they are not in the comment date order, but rather in Member ID order.

solved this myself using DB2 Connect