Re: VBA in Excel & ADO: some problems
- From: "Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 17 Aug 2005 10:06:03 +0100
"Santiago" <Santiago@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:24C04FCA-5263-439E-8131-3406504CADDE@xxxxxxxxxxxxxxxx
> Hey guys,
>
> I'm quite new in ADO and I need some help...
>
> 1) can the same MSAccess database be accessed from Excel using ADO at the
> same time?? what should be the "mode" property on the connection string??
Yes you can. As it is being shared, you would not want tyo try and open it
exclusivley, so don't set it at all.
> 2) how can I put a password to the database and access to it from MSExcel
> using ADO?? should I use the "user" and "password" property in the
connection
> string??
Yes, here is an example
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDB:Database Password=MyDbPassword", _
"myUsername", "myPassword"
..
.
- References:
- VBA in Excel & ADO: some problems
- From: Santiago
- VBA in Excel & ADO: some problems
- Prev by Date: Re: Reference a cell as part of a file name
- Next by Date: Re: Hyperlinks to other Sheets
- Previous by thread: VBA in Excel & ADO: some problems
- Next by thread: RE: VBA in Excel & ADO: some problems
- Index(es):
Relevant Pages
|
