Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / February 2006

Tip: Looking for answers? Try searching our database.

username in adp

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Everaldo Ricardo - 20 Feb 2006 13:59 GMT
using mdb, when a user open the mdb file and put his username and password,
the windows keeps username for next time...

but...

using adp, the username's default  always is the connection's username

how can I change this situation?
andrei   skor - 20 Feb 2006 20:12 GMT
> using mdb, when a user open the mdb file and put his username and password,
> the windows keeps username for next time...
[quoted text clipped - 4 lines]
>
> how can I change this situation?
Everaldo Ricardo - 21 Feb 2006 19:14 GMT
answers in english please

"andrei skor" <alena.5> escreveu na mensagem
news:uV3yynlNGHA.2916@tk2msftngp13.phx.gbl...

>> using mdb, when a user open the mdb file and put his username and
> password,
[quoted text clipped - 5 lines]
>>
>> how can I change this situation?
Sylvain Lafontaine - 21 Feb 2006 19:28 GMT
You must use Integrated Security or Close/Reopen the connection; something
like:

   CurrentProject.CloseConnection
   CurrentProject.OpenConnection connectionString, user, password

Not a perfect solution, I admit.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> using mdb, when a user open the mdb file and put his username and
> password, the windows keeps username for next time...
[quoted text clipped - 4 lines]
>
> how can I change this situation?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.