473,231 Members | 2,009 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

SQL Server login Form For access

Hi there...

I use SQL server integrated security so when a user opens a database in
access it prompts the username & password in a small popup box on
connection, but I'd like to use my own customised form for the
authentication process, is this possible? I do know that this login popbox
is displayed before any forms are loaded, can it be said that on database
conenct that the form is opened? How will I transfer the values entered into
the login form to the sql server for authentication?

Thanks alot in advance
Rudi Groenewald
Jul 20 '05 #1
3 9468
Ben
With integrated security I really don't think you can do what you are
asking. The idea behind integrated security is that the Windows logon
account the user has for the machine also logs them on to SQL Server,
there is not need to enter authentication information. If the users are
getting a login box, chances are that you have SQL security or you have
not specified integrated security in your connection string (which I
think would cause an error). You can create your own by creating a form
asking for the authentication information and storing it in variables,
then concatenate the values into your connection string.
Alternately, if you are using linked tables, check the 'Save password
information' box when linking so creditials only need to be supplied once.

HTH
Ben
Rudi Groenewald wrote:
Hi there...

I use SQL server integrated security so when a user opens a database in
access it prompts the username & password in a small popup box on
connection, but I'd like to use my own customised form for the
authentication process, is this possible? I do know that this login popbox
is displayed before any forms are loaded, can it be said that on database
conenct that the form is opened? How will I transfer the values entered into
the login form to the sql server for authentication?

Thanks alot in advance
Rudi Groenewald


Jul 20 '05 #2
hi ben...
Sorry, that was what I meant. If I use SQL security, I need to to popup my
form to ask for the username and password of the user, not only the msgbox
that pops up asking for it, how will I do this?

Thanks
Rudi

"Ben" <be********@NOSPAMhotmail.com> wrote in message
news:3F**************@NOSPAMhotmail.com...
With integrated security I really don't think you can do what you are
asking. The idea behind integrated security is that the Windows logon
account the user has for the machine also logs them on to SQL Server,
there is not need to enter authentication information. If the users are
getting a login box, chances are that you have SQL security or you have
not specified integrated security in your connection string (which I
think would cause an error). You can create your own by creating a form
asking for the authentication information and storing it in variables,
then concatenate the values into your connection string.
Alternately, if you are using linked tables, check the 'Save password
information' box when linking so creditials only need to be supplied once.

HTH
Ben
Rudi Groenewald wrote:
Hi there...

I use SQL server integrated security so when a user opens a database in
access it prompts the username & password in a small popup box on
connection, but I'd like to use my own customised form for the
authentication process, is this possible? I do know that this login popbox is displayed before any forms are loaded, can it be said that on database conenct that the form is opened? How will I transfer the values entered into the login form to the sql server for authentication?

Thanks alot in advance
Rudi Groenewald

Jul 20 '05 #3
Behind the Access login form, in the CLick event of the Login button, you'll
have code like this:

strConnect = "ODBC;DRIVER={SQL
SERVER};SERVER=YourServerName;DATABASE=YourDB;UID= " & txtUID & ";PWD=" & txtPWD

Then you'll need to cycle through the TableDefs Collection and reset the
COnnect properties and use the RefreshLink Method.

Then you'll need to cycle through the QueryDefs collection to reset the Connect
property of any pass-through queries.

If you have any temporary pass-through queries created in code, you'll have to
hold the UID and PWD values in global variables (or better yet, a Class) so
that you can rebuild the connect string on the fly.
Jul 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Shaun | last post by:
Ok here is the situation… Have an access 20002 application that I'm converting to have a SQL Server backend (2000), the application has been in use with an access backend for years, no real...
4
by: rrober07 | last post by:
Hello, My Setup is I have a Web Server machine(Devweb01), Database SQL Machine(Devsql01), a Client Machine(local machine) I have configured the SQL machine as follows: 1) Added local Aspnet...
7
by: Wade Wegner | last post by:
Hello, I have been desperately trying to programmatically authenticate a windows user, create their credentials, and then redirect them to a different server while passing the credentials at the...
3
by: Ronan Dodworth | last post by:
Hi there I'm having a little bit of a problem with my customvalidator control. The problem is the javascript runs fine on my local webserver IIS but not when I post it to the web hosting server....
3
by: Olivogt | last post by:
Hello, I was just puting an application on the web server but it did not work as usual... - I do develop on my notebook and move released applications to the Web server - both have Sql Server...
6
by: cyndithomas via AccessMonster.com | last post by:
I new to Visual Basic and am struck on a issue. Have created a Login in Screen for Remote User to access and input data. Want the Remote to be able to login & access the Input Form, and Manager...
2
by: Wimpie van Lingen | last post by:
Hey I have some more questions with regards to Remoting in .NET 2. I'm using TCP with the Binary formatter. My solution consists of 4 projects: - Class Library containing the server classes...
2
by: MDANH2002 | last post by:
Hi From VB.NET I want to simulate the POST request of the following HTML form <html> <title>HTTP Post Testing</title> <body> <form action=http://www.example.com/postdata ...
13
JodiPhillips
by: JodiPhillips | last post by:
G'day, I have a silly and simple problem that I need some guidance with. Due to the way our network is set up, I am unable to use the group permissions for Access and have had to implement log...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.