View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Santiago[_2_] Santiago[_2_] is offline
external usenet poster
 
Posts: 26
Default VBA in Excel & ADO: some problems

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??

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??

Any hint will help me out here. Thanks.

Bregards

Santiago.