cancel system login prompt "Sam" <focus10[ at ]zahav.net.il> 29.11.2005 09:17:53 the access to the application is with sql server Authentication for login i use a login form but before it opsen's there is a system login prompt how can i cancel this prompt? thanks

Re: cancel system login prompt "giorgio rancati" <giorgio_No_Spalmer_rancati[ at ]tiscali.it> 29.11.2005 09:44:56 Hi Sam, before closing the project, clear the connection string ---- Currentproject.Openconnection "" ---- bye -- Giorgio Rancati [Office Access MVP] "Sam" <focus10[ at ]zahav.net.il> ha scritto nel messaggio news:etvaWXM9FHA.3660[ at ]TK2MSFTNGP09.phx.gbl... [Quoted Text] > the access to the application is with sql server Authentication > for login i use a login form > but before it opsen's there is a system login prompt > how can i cancel this prompt? > > thanks > >

Re: cancel system login prompt "Sam" <focus10[ at ]zahav.net.il> 29.11.2005 10:24:30 It's ok but now their is a new problem the login form supose to read user name from a connected table but because of canceling the system login prompt the table is yet unconnected when login form activate "giorgio rancati" <giorgio_No_Spalmer_rancati[ at ]tiscali.it> wrote in message news:egr2ZlM9FHA.808[ at ]TK2MSFTNGP09.phx.gbl... [Quoted Text] > Hi Sam, > > before closing the project, clear the connection string > ---- > Currentproject.Openconnection "" > ---- > > bye > -- > Giorgio Rancati > [Office Access MVP] > > "Sam" <focus10[ at ]zahav.net.il> ha scritto nel messaggio > news:etvaWXM9FHA.3660[ at ]TK2MSFTNGP09.phx.gbl... >> the access to the application is with sql server Authentication >> for login i use a login form >> but before it opsen's there is a system login prompt >> how can i cancel this prompt? >> >> thanks >> >> > >

Re: cancel system login prompt "giorgio rancati" <giorgio_No_Spalmer_rancati[ at ]tiscali.it> 29.11.2005 16:10:26 Hi Sam. Before open the login form, you can reconnect the project or read the table in a separate connection to the server, then reconnect the progect Open a recordset in separate connection ----- Dim Cn As ADODB.Connection Dim Rs As ADODB.Recordset Set Cn = New ADODB.Connection Set Rs = New ADODB.Recordset Cn.Open "Provider=SQLOLEDB.1" & _ ";Data Source=ServerName" & _ ";Initial Catalog=DbName" & _ ";User Id=UserName" & _ ";Password=UserPassword" Rs.Open "Select * From Tablename", Cn, adOpenKeyset, adLockOptimistic ....... ....... Rs.close Set Rs=Nothing Cn.Close Set Cn=Nothing ---- reconnect the project ---- If Currentproject.IsConnected=False Then Currentproject.OpenConnection _ "Provider=SQLOLEDB.1" & _ ";Data Source=ServerName" & _ ";Initial Catalog=DbName" & _ ";User Id=UserName" & _ ";Password=UserPassword" End if ---- bye -- Giorgio Rancati [Office Access MVP] "Sam" <focus10[ at ]zahav.net.il> ha scritto nel messaggio news:uWYik8M9FHA.2640[ at ]tk2msftngp13.phx.gbl... [Quoted Text] > It's ok > but now their is a new problem > the login form supose to read user name from a connected table > but because of canceling the system login prompt the table is yet > unconnected > when login form activate