2 Users Open Same Ado Record (SQL Server 2005) Via VB6 Front End?
Oct 26, 2009is there a way to tell if the record is currently open (for editing) by another useregclerk 1 gets recordset for a person. pessimisic lock, client cursor.
View 1 Replies
ADVERTISEMENT
DB/Reporting :: Can VB 2005 Front End Running In Win XP Access MySQL Database In Linux Server?
Aug 5, 2008I am asked to write a front end program in VB 2005 (that will run in client computers which running on Win XP) to access an existing MySQL database running in Linux. It is not my preferred choice, but the user have the database and server working just as he wants it, and do not wish to change, at the same time I do not wish to change programming language. Is that even possible? Can we actually write VB 2005 programs that will run in client computers complete with NET framework 2.0 to access a Linux operating database?
View 4 RepliesData Management - Changing Current Database System, MS Access 2007 Front End And MS SQL Server 2005 Backend
May 8, 2012We are thinking about changing our current database system, MS Access 2007 front end and MS SQL Server 2005 backend to using a higher level language such as Visual Basic .Net. I wonder if this is the BEST solution for data management? Currently, among others, we have two big database programs that handle more than two hundred users and it's crashed often. That's the reason we think about changing to something that can handle these database programs effectively preferably using MS technology such as .Net.
View 12 Replies.net - Cutting Off The 0's At The Front Of A Record?
Feb 6, 2012Basically, I have an Access database with Primary keys that are structured with this format ("02"000).When I try to paste the number, it ignores the "02" and goes straight to 000.For example, here is the code;
PeriodRoomID.Name = ("R" & ds.Tables("sqlSpecRoomRequest").Rows(i).Item(1))
What PeriodRoomID.Name should be is R02001.What PeriodRoomID.Name comes up as is R1.It ignores the "02" and ignores the 0s. This makes sense mathematically but it is not what I want. I need a way to get the exact output and not some simplified version.
The query;
SELECT SpecialSoftware.SpecSoftID, SpecialSoftware.RoomID, SpecialSoftwareNames.Description, Rooms.Capacity
FROM SpecialSoftware, SpecialSoftwareNames, Rooms
Force Users To Save Current Record (If Current Record Has Changed) Before Going To Next Record
May 17, 2010How do I force users to save the current record (if current record has changed) and not let user go to the next record unless the save button is pressed?
View 5 RepliesFront End - Record Updation Taking Long Time
Jul 6, 2009I have a backend database in MS access, which is updated using excel as front end. Due to network issues the record updation takes lot of time. Would it be faster if i use VB.net as the front end.
View 1 RepliesVS 2010 Store And Open Files To And From SQL Server 2005?
Jul 18, 2011Is it possible to store excel, word, pdf, .rar .zip files to a column in a table of a SQL Server 2005 DB.And also open the fie with excel, word, acrobat reader, etc????My other sollution would be to store the file on a location on a server and only sory the filename and location in my db and then open them with "Process.Start("filename")".My main problem with solution 2 is this:Lets say I install the programm on a pc called "manager". When I use the savefiledialog and I am on the manager pc the string C:/myfiles/test.xls will be stored
View 1 RepliesInserting Data From Front End To Sql Server?
Jun 22, 2010I have designed a front end screen for a simple login page with two fields username and password in ASP.net/VB.net. I want the data that I enter into the textboxes to be populated into the database, on click of submit button and a confirmation message like 'Your data has been entered successfully'.Please explain me two things.1.How can I connect to the database and how should the insert statement be?
View 1 RepliesVS 2008 Bring The Open Excel Sheet To The Front After Form Finishes?
Mar 18, 2009I am working on an excel add-in. Currently I have a couple of forms that grabs info from excel, processes and pastes data back into excel.My problem occurs after my form closes (this leaves excel and one other MDI form still open). I need my excel sheet to come to the front for users to view and edit. My MDI form just stays on top even though I just edited the excel doc. I have tried everything I can think of using:
.visible
.activesheet etc.
Here is my latest:
[code]....
VS 2005 Window Bring To Front
Oct 24, 2009So I have this code to make a "windows taskbar". When you click on an item, it's supposed to bring that window to the front. The only problem is that's not happening. When I use Debug.WriteLine, it has the right window title, except it doesn't come to the front. What's wrong? There is no EntryPointNotFoundException or anything, it just doesn't bring the window to the front.
[Code].....
Accessing Same Record By Two Users On Different Machines At The Same Time?
Mar 4, 2009I am developing Client/Server application in Visual Basic 2005 with back-end SQL Server 2005 Database.I have lot a users to access to this application.I have a problem with accessing same record by two users on different machines at the same time.For example: Two user fetches the same record display on the machine.Now both have same data on the machine. The first user modified and saved the record and after some times another saved the data without modified or modifed some other columns. Now the last user who modifed the record contains the old data.
View 5 RepliesUsing SQL Express 2005 As Backend Database On VB6(front End)
Mar 9, 2010I've been using ms access bfore but want to upgrade coz the company im working in is getting bigger. With almost 10,000 new clients added every week. Im afraid access can't handle it anymore. So im planning to create a new database. Im really new to this SQL Express but have knowledge in sql using vb codes. Is it easy to be used as backend database?
View 6 RepliesVS 2005 Viewing Label Controls At The Front End?
Oct 6, 2009I have some buttons, labels, datagrids, radiobuttons etc. on the front end of an application. Can anyone tell me how to make all the labels visible in the design view even if the focus is removed from those controls. The problem is once the focus is removed from the labels they do not appear in the screen.
View 5 RepliesVS 2005 Created A Project That Has Add New Record / Edit Record And A Search Form
Apr 1, 2009I have created a project that has an add a new record, edit record and a search form, that has multiple text, combo boxes and is working great.Last nite I have added a checkbox under my add new record form and i am saving the checkbox value to my database, so far so good. I would like to be able to search any record that is mark with a checkbox to show up in my search screen when I do a search: [code] The problem that i am having is that now that I have added the code to my project to search for the checkbox field in the search screen and if I leave everything blank and click on the the search button I get no record found. I expected to see all that data, since I have nothing selected. Now if I click my checkbox, as soon as I click on my search button I see that two records that I have added for my test.
View 1 RepliesUsers Enter Some Record Sometimes Two Records Get Saved On Same Number?
Aug 26, 2009i have a sql table which has 2 fields number & name
1 abc
2 xyz
Situation is that the app finds out max of number and increments it by 1 to get new number.The problem is when two users enter some record sometimes two records get saved on same number.
[Code]...
Unable To Delete Row Record From SQL SERVER Record?
Mar 26, 2011when i try to delete a row . always restricting to delete on certain Table table.( DELETE ERROR tble_tombstone) message comes up.
View 8 RepliesVS 2005 - Displaying Image In Front Of A Nodes Caption Of A Treeview
Jan 12, 2010Displaying an image in front of a node's caption of a treeview. i have an imagelist that contains of images and a treeview containing of nodes. I have also assigned the name of the ImageList control to the ImageList property of the TreeView control, as you can see in the following code. here is the structure of my treeview: Code: even i know that by using the image index and the selected index property i can display the images in front of the node caption of a treeview but i cant do it properly and having a few confusions.
View 6 RepliesVS 2005 Drawing On PictureBox Erase When A Window Move On Front
Dec 25, 2009I used a picturebox to allow user draw lines by mouse. I used this code in mouse down:
Dim D As New System.Drawing.Pen(DrawingColor, 2)
Dim g As Graphics = PB.CreateGraphics()
g.DrawLine(D, X1, Y1, X2, Y2)
but when a window appear on front of picturebox... its seams that picturebox redraw itself, so drawn lines erased.
[2005] Open File Dialog Box In VB 2005 To Open Up An Existing Txt
Jan 9, 2009I am trying to use the open file dialog box in VB 2005 to open up an existing txt, or rtf file from a directory into a rich text box. I am able to get the Open file dialog to appear and the directories, but when I try to open the file it doesnt import it into the text box. Here is the code I am using
[Code]...
Changed SQL Server 2005 Express To SQL Server 2005 Standard Edition?
Mar 4, 2011May I ask a question to you all.I have vb.net project that generate sales report from SQL Server Database.I changed SQL Server 2005 Express to SQL Server 2005 Standard Edition.
After that my program can't run properly and every time I got Time Out Expire message.
That program work properly with SQL Server 2005 Express.May I request suggestion how to fix this.
VS 2010 Working With Files Already Open By Another Users?
Sep 29, 2011I created a program that processes files on a nightly bases for the company I work for. These files are used on a daily basis and very often a file is left open by a user and it causes my program to error out and not finish running. My program needs delete access to these files.
I need 1 of 2 solutions.
1. I need somehow add a check to see if a file is in use and if it is just skip it.
2. I need to make my program automatically force close the files on the users. (note that these are shared by one computer, I can put the program on the computer that the files reside so that it has access to close them out.)
how to add a check for if a file is in use or not?
Way To Send Users A Message If Have 2 Or More Websites With Same URL Open
May 2, 2011I am trying to figure a way to send my users a message if they have 2 or more websites with the same URL open(These are web tabs in one IE window). Is this possible?
View 4 Replies[2008] Open Specific Form For Different Users?
Feb 19, 2009I've got 2 levels of users, and I'd like to find a way to open a certain form for each user. I have tried something that I thought would work, but it just opens the same form for all users:
If "MenuType" = "Landscaper" Then
Dim MainPanel As frmOwnerPanel
MainPanel = New frmOwnerPanel
[code]......
Open A Form And Bring The Form To The Front AS Default?
Jun 1, 2011I've been looking all over the internet, and I couldn't find any decent answers. Obviously, two things to know:1) I'm using VB.2) The Forms are all FULL SCREEN, with the code
Me.FormBorderStyle = Windows.Forms.FormBorderStyle.None
Me.WindowState = FormWindowState.Maximized
Me.TopMost = True
[code]....
Add Users To SQL Server Programmatically?
Dec 30, 2009So I'm creating this app that will install SQL server 2008 express, add some SQL users and then import a database.
Is there a way to create users for SQL express in Vb.net?
Users Should Not Have Access To SQL Server
Apr 13, 2010Is it feasible to deploy a VB.NET windows forms application with a SQL Server back end where no users have direct access to SQL Server? The idea is that there is no way someone at the client site with admin capabilities could mess up the data definition, or directly alter data. I always assumed that somebody with the client should get admin capabilities, but perhaps not.
The application will have to have the capability of creating logins, doing backups, perhaps running scripts (encrypted?) For upgrades, and whatever else a user with elevated privileges would do. I guess the application would have a hard-coded account with admin privileges for this purpose. Is this a common way to deploy an application? The application uses SQL Server Express, which is installed with the application. The database will be installed with the application.
Read Users In Sql Server In Program?
Jan 25, 2010How to read users in sql server in vb .net. i want to synchronise users from sql with users from my application.
View 2 RepliesTerminal Server Users Logged On?
Aug 6, 2009is there a way for a program to get a list of users that are logged into the terminal server that it is running on???
View 3 RepliesActive Directory Users Into Sql Server Table?
Apr 21, 2012I am trying to retrieve all the users in the Active Directory and dump into a Sql Server Table(Sql2008). I was able to search one employee at a time but could not able to search all the employees in the Active Directory. Basically i want to retrieve 1.SamAccountname and 2.Employeenumber. I am using VS2010/VB.NET/ASP.NET.
View 1 RepliesActive Directory Users To Sql Server Table?
May 17, 2012I am trying to retrieve all the users in the Active Directory and dump into a Sql Server Table(Sql2008). I was able to search one employee at a time but could not able to search all the employees in the Active Directory. Basically i want to retrieve 1.SamAccountname and 2.Employeenumber.
View 2 Replies