microsoft.public.access

Each user should have his/her own copy of the ADP file.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Atlas" wrote in message
news:6EC734FC-6F7B-455A-AC34-D488BCE4B919@microsoft.com...
>I have an ADP project with a back end SQL Server. I'm using the following
> code to connect to the database. But this will only allow me one user to
> connect using the front end ADP. Once the first user has logged on a
> second
> user cannot seem to connect as it can't open anotehr connection. Does
> anyone
> know how I can overcome this or is there a way of specifying/allowing
> multiple connections?
>
> Application.CurrentProject.OpenConnection _
> "Provider=SQLOLEDB.1;" _
> + "Persist Security Info=false;" _
> + "Initial Catalog=" & strDatabase & ";" _
> + "Data Source=" & strServer & ";" _
> + "Integrated Security=SSPI;"
>