VS 2010 - Database Has Been Placed In A State By User (Admin)
May 23, 2012Error: The database has been placed in a state by user 'UserName' on machine 'ComputerName' that prevents it from being opened or locked.
View 5 RepliesError: The database has been placed in a state by user 'UserName' on machine 'ComputerName' that prevents it from being opened or locked.
View 5 Repliesi have a script with a login form that creates a folder per user with username.txt, password.txt, firstname.txt, and lastname.txt. - auto creates when creating new user.after i log in and change form i want an label showing the first and last name of the person logged in,how am i supposed to do that? is there any way to make like an "admin" form where new account applies will pop-up when "admin" log in and then either accept or reject new users?
View 8 Repliesi'm having some problem over here. When user enter their id,it will show up the main page and its for user but when admin enter their id,it will enter the user's main page and i have to click admin site on the top hyperlink and it automatically logout and once i enter back admin passwrd and then only it redirect to admin page.how to make it like once user enter their passwrd it redirect to user page and once admin enter admin password in the login it redirect to admin ?I have 3 roles over here which are admin,staff and user. Hereby i'll provide you my aspx code and also my vb code which is running behind the program.p
ASPX
<asp:Login ID="Login1" runat="server" BackColor="#009933" BorderColor="Red"
BorderPadding="4" BorderStyle="Ridge" BorderWidth="1px" Font-Names="Verdana"
[Code].....
I've searched the forums but never seems to find an answer for this one.. I recently connected to MySQL database server "Automatically" in Visual Studio 2010. I want to know if there's a way to determine the connection state for "Automatically created" connections in Visual Studio 2010. I know how to do it for"programmatically created" connections but just want to know how on the auto-generated ones.
View 1 Replieshow to add user level's like admin and normal user
i have this table login with the gebruikersnaam paswoord admin (admin is a int and if its 1 then your a admin)
this is my login script
Dim cnn As New SqlClient.SqlConnection
Dim comand As New SqlClient.SqlCommand
Dim adapt As New SqlClient.SqlDataAdapter
[Code]....
what is the diffrence between single call and single ton 2)is it possible to maintain state for every user whose requests not overwrite with another user..i mean i created one remoting application and client.i have one class created in remoting application and i am calling functions created in this call from client application.
View 3 RepliesI think this has to do with a third party OCX control. Below is the output when the application starts. When I install my application on a stand-alone PC or most PCs in a networked environment it runs fine. When I go to some offices that have very tightly controlled networks I have problems.
The set up won't run under the user name so someone from IT must log in as administrator. They run the set up and the application installs and runs fine. The IT person logs off and the user tries to run it and the application won't even start. An error box appears and below is the report. SCANNERLib.DLL is the third party control. Maybe there is something I'm missing when I compile. Maybe the DLL registering funny under the Admin rights. [Code]
I found that snippet, edited it a little bit and now im trying to use it...the problem that ocurres, is that its never going into the first IF... so already there seems to be an error.Im working on XP SP3 with admin privileges..
Private Shared Function GetCurrentPrivileges() As Privileges
If My.User.IsAuthenticated() Then
If My.User.IsInRole(ApplicationServices.BuiltInRole.Administrator) Then
[code]......
I'm creating a program that users will login to and I'm trying to make different user levels. I have the login and registration part done. But i need the user levels part. I know i can use a billion if then statements for each admin i have but that will be thousands lines of code afterwards. So I thought up maybe i can check the column name admin and see if its set to true. Or even check another table to see if the user is in that table then load a different form.
Dim conn As MySqlConnection
'connect to DB
conn = New MySqlConnection()
[CODE].................
Also I'm using Visual Studio 2008 express and was wondering if this would work also even though its for 2005 Do to I see the flaw in hard coding it into the program. Any hacker who de .exe it can get a hold of my information and use it against me. And if not how would i go about in 2008 and use it. [URL]
Just a pretty question that seem to me a bit difficult to do it. Well, I have a form called customers. Login form and mainform. So my clients want to have an option that explains this: If a user enters information in the customer form, then that information has to be confirmed by admins panel.
[Code]...
on XP Pro, IsUserRole(eUserType.Administrator) returns true, if the class is administrator, and false if it's limited...
On Vista, it returns true, if it's the first administrator account, and false for anything else... I created a second administrator account on Vista, and it shows in code as "Standard" (or limited) user, the same as if I made a "Managed Account" on Vista...
My
#Region " [IsUserRole] "
Public Enum eUserType
Administrator = 0
[Code].....
Public Class Form2
Public login As Boolean = False
Dim dt As New DataTable
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
[Code]...
i have a login page link above the page /// i want if user already loggedin then anybody click on loginlink then the user will automatically redirect to default.aspx ..
View 3 RepliesI'm designing a system, whereby am unable to use 2 different login authorities, which are Admin and Non-Admin. I am using VB.NET and Ms. Access and need help for the codes.I want something like, if i click on admin/non admin (with different passwords) a dialog box pops onto the screen and asks for the password. If the password is correct it should take me to the form i want. Something of this sort please.
View 9 RepliesI'm pretty new to WinForm Development (Normally just do Web Dev)... Anyhow, what i'm trying to do is store information about the logged in user so it can be used throughout the App...Normally in WebDev you could use Session, Cookie Etc..
View 4 RepliesHow can one obtain his/her database password with code while the admin privileges are proved to be sufficient by windows authentication?
View 1 RepliesI programmed an app with an Access 2010 database, I installed the app and the database on a computer with office 2007. The app can't open the database. Do I need to copy some extra file on the user's PC?
View 15 RepliesI need help making this code work better. Currently, what happens is when it reloads, I loose the third value which is a calculated value . I would like for my page to reload without loosing the values for each property and each instance of the user control on the page.
[Code]...
I'm setting up a program where I would like the user to be able to select a state from a combo box. I can not figure out how to allow to select the abbreviation from the drop down list and also allow them to type a letter and it will select the state from the state or just allow them to type the full abbreviation that would match what is already in the list. It is supposed to be in the drop down list style. I would also like to confirm that the user has chosen a state before allowing them to click a submit button but I'm not sure how to go about confirming it.
Private Sub FrmMain_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
' Inserts state abbreviations in combo box
cboState.SelectedItem = " "
cboState.Items.Add(" ")
[code].....
i want to excute this command in a guest account
Shell("net user new2 /ADD")
This needs administrator privelages
I've written a service in VB and a config app for the service which has a service start/stop button. In order to start and stop the service you need admin rights, under Windows 7 you right click on the exe and "run as administrator". This works ok, I've used the Visual Studio Installer to also create a desktop shortcut, but if you right click on the shortcut there is no way to run as administrator.
The question therefore is, how to run the shortcut as an admin user? Edit, if you hold shift down whilst right clicking you get the "Run as administrator" option, but you still can't change the advanced property to tick the box as its grayed out.
I am wondering if it is possible to run an application from a domain account that has restrictions on running .exe files by coding in the local administrator details (username / password).
View 3 RepliesHow To on a database driven login form. I'll include the Administration Backend to go along with it soon. Dial-Up users should not use this thread, it is image heavy
[Code]...
I'm trying to ensure that a user exists in a database before the data they are logging is inserted. I have the following code;
Dim ID As String
Dim v_sqlid As String
ID = txtEmployee.Text()
[code].....
I have a VB2005 winforms application that will loads city data from my database table. This is to ensure that the user enters the correct city spelling, in order to receive an accurate quote. Currently, there are about 150K cities that are being loaded to the dropdown listbox on page load. It takes about 30-40 seconds for that page to load. My initial thought was to allow the user to select the state first. Then load the city values. But the user has the option of going back and requesting a quote for a different city / state.
View 2 RepliesI need help with the code to make it so when a form loads it will check the Access database for the user and if that user is present, then it will load their selections. Otherwise, if no user is present it will add a new row to the database and display nothing.
View 2 RepliesHow it's possible to get values (string) from the database when a user connects? i use in this
[Code]...
How connect Vb.Net to MYSQL..? How to add info to database user informations using mysql database. How to call login infos using mysql.
View 8 Repliesworking on a March Madness Program and need help searching the database. I have the database all linked and all the cells connect, but now I need to make it so when people login it will search the database for their username and password to verify the user. My database is in access is called MarchMadness, with the table being tblUser and the column's are "username" and "password"
View 2 RepliesI am trying to essentially allow the user to merge data from a database onto a document and print it. I am new to working with the PrintDocument, but I believe this would be the way to accomplish this. I know how to print the text onto the PrintDocument at a certain position, but what I am trying to figure out is how to deal with the coordinates of the text I am drawing on the PrintDocument. Ideally, I would love to click on the PrintDocument in a PrintPreviewControl and capture the coordinates of the PrintDocument.
View 9 Replies