VBA in Excel & ADO: some problems
Thanks, but what I mean is the userid and pass used in the Connection string
is the one that I put in access in "TOOLSSECURITYUSER AND GROUP ACCOUNTS"??
thanks
bregards
Santiago
"Bob Phillips" wrote:
I gave you that in my response.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Santiago" wrote in message
...
Ok Guys thanks.
So ... if I do not specify the mode property, users can access update and
read data at the same time... good
I know how to specify userid and pass in ADO, but how can I add password
to
the database in Access?? I know it should not be in this forum but since
it's
all related...
Thanks again. Bregards
"Simon Letten" wrote:
1. Yes you can connect to the same database more than once. The mode
property depends on whether you want to modify the data and whether you
want
more than one person to be able to read/update the database at the same
time
2. You'll need to specify the UserId and Password when you open the
connection, e.g. connection.Open strConectString, strUserId,
strPassword.
You might need to specify which System Db you're using in the connection
string, i.e. the Jet OLEDB:System Database parameter.
--
HTH
Simon
"Santiago" wrote:
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.
|