A1VBCode Forums / Classic Visual Basic (VB 6 or earlier) / Database Programming

SAVING AND RETRIEVING IMAGES INTO ACCESS USING VB6

jessiekidfernando — Sat, 27 Feb 2010 00:14:21 GMT

HELP GUYS. I JUST WANT TO KNOW HOW TO SAVE IMAGES INTO ACCESS USING VB6. I'M 3RD YEAR COLLEGE NOW. AND WERE WORKING NOW WITH DSS.. THANK YOU. AND GODBLESS...

how to create digital signature in forms

belat — Tue, 16 Feb 2010 07:57:22 GMT

hey...i just want to ask if

how to create digital signatures for form in

visual basic....

thanks

Lan base system

belat — Wed, 17 Feb 2010 00:17:46 GMT

i just want to ask if how to create lan based

system with mysql database and vb 6???

thanks..

Database back up and restore

belat — Mon, 15 Feb 2010 00:22:28 GMT

good day! i just want to ask

if how to back up and restore mysql database using visual basic 6

thanks..

Problem with Insert Statement

nick447923 — Tue, 05 Jan 2010 17:34:23 GMT

I am a beginning programmer and am having a problem with adding a record to a customer table in a Microsoft Access database. I have worked for hours reading my textbook and troubleshooting to no avail. When I execute this code below the record is not added and I do not get an error of any type. When I go into debug mode, all of the parameters are correct and everything looks good. If I open up Access I can manually add the record but using my program nothing happens. All datatypes are string in VS and text in Access.

First an instance of the Customer Class is created and this seems to be successful. But when I take that customer object and run the AddCustomer method of the customer class it is not successful in that the database does not reflect that the record was ever added.

Here is the code for the AddCustomer method:

<code>
Public Shared Function AddCustomer(ByVal customer As Customer) As Boolean

Dim connection As OleDbConnection = PaulMeadeInsuranceDB.GetConnection
Try
Dim insertStatement As String _
= "INSERT INTO Customers (CustNumber, Lastname, Firstname, MidName, Address1, Address2," _
& " City, State, ZIP, Phone1, Phone2, PolicyNumber) VALUES" _
& " (@CustNumber, @Lastname, @Firstname, @MidName, @Address1, @Address2, @City, @State," _
& " @ZIP, @Phone1, @Phone2, @PolicyNumber)"

Dim insertcommand As New OleDbCommand(insertStatement, connection)
insertcommand.Parameters.AddWithValue("@CustNumber", customer.Custnumber)
insertcommand.Parameters.AddWithValue("@Lastname", customer.Lastname)
insertcommand.Parameters.AddWithValue("@Firstname", customer.FirstName)
insertcommand.Parameters.AddWithValue("@Midname", customer.MiddleName)
insertcommand.Parameters.AddWithValue("@Address1", customer.Address1)
insertcommand.Parameters.AddWithValue("@Address2", customer.Address2)
insertcommand.Parameters.AddWithValue("@City", customer.City)
insertcommand.Parameters.AddWithValue("@State", customer.State)
insertcommand.Parameters.AddWithValue("@ZIP", customer.Zip)
insertcommand.Parameters.AddWithValue("@Phone1", customer.Phone1)
insertcommand.Parameters.AddWithValue("@Phone2", customer.Phone2)
insertcommand.Parameters.AddWithValue("@PolicyNumber", customer.Policynumber)
Return AddCustomer
Catch ex As OleDbException
MessageBox.Show(ex.Message, ex.GetType.ToString)
Finally
connection.Close()
End Try
Here is the code from the actual program:

Private Sub btnNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNext.Click
Try
Dim record1C As New Customer(txtCustNumber.Text, txtLastname.Text, txtFirstName.Text, _
txtMiddleName.Text, txtAddress1.Text, txtAddress2.Text, txtCity.Text, _
txtState.Text, txtZIP.Text, txtPhone1.Text, txtPhone2.Text, txtPolicyNumber.Text)

CustomerDB.AddCustomer(record1C)

Catch ex As Exception
Throw ex
End Try
End Sub
<code>

suggestion to copy data from Sql Server into Access database

sal21 — Fri, 11 Dec 2009 06:56:23 GMT

Situation:
I have a Sql Server in Rome and a shared server dir (with the access database) on a Server in New York.

I have permission on sever dir and databse.

The database on sql Server have exactlly the same structure of Access database. (the table on Sql Server have 200.000 records and 48 columns).

Now i want to recopy all records from Rome to NewYork.

Wath is the best way in terms of time to recopy records from Sql Server to acces Table?

note:
I want to use in my app the ADO jET drive.

visual basic.net

tawfiiq — Thu, 04 Feb 2010 02:31:40 GMT

hi dear

i am new to vb.net , and i want to add date and time (DateTimePicker1) to my form
then when i save the record a wrong date is saved to the table , my database is sql 2005

Code: " & Format(DateTimePicker1.Value, "dd/mm/yy") & ") "

Result: 1/1/1900 12:00:00 AM

i much liked to help.............

The student record database

Afi83 — Wed, 23 Sep 2009 08:14:45 GMT

I have a problem with creating this database.
I want to create the student record system. I have a table containing Individual information and using of ID as primary key.
For registering grades I use another table for grades. But here is the problem. Here we have 6 or more class with different courses.
Firstly, I should to permit the user for adding more classes and then more courses to these basic assumptions. (But how the user can add another table that the relationship between new table and the Individual information table makes sense).
How can I save the grades in table?
It is better to use different table for different class with using different courses as filed in this table.

Or add all the courses in my filed and for each ID I just fill out the course for that class.

Or something else I don't know?

Another problem is when some person has grades with lower than 15, I have to add another grades for this person. This person failed then must have another grade for taking effect in GPA.

Please help me to find the way through these problems.

mySQL DB inserting issue

honomas — Tue, 05 Jan 2010 05:23:53 GMT

I am having a major issue with inserting french characters in my mySQL DB. The french charaters display perfectly fine on the client-side page. If I edit a field directly in the phpMySQL control panel, the french characters also displays correctly.
But if I insert or update fields from a form on a webpage (using PHP), it converst the special french characters into something not readable. For example, à becomes Ã Â.

I feel as if I've tried it all... any ideas?? here are the variables set on my server for phpMySQL:
*********************************************
character set client utf8
(Global value) latin1
character set connection utf8
(Global value) latin1
character set database latin1
character set filesystem binary
character set results utf8
(Global value) latin1
character set server latin1
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_general_ci
(Global value) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ci
********************************************

Any ideas or suggestions would be much appreciated!

Connection

mohamedsamir3000 — Fri, 25 Dec 2009 12:19:43 GMT

Hi everyone,

I want to know how can I connect to an external database via vb.net.

Thank you

calling of all primary key of ADODB using combo box in other form

roskie21 — Mon, 14 Dec 2009 02:21:12 GMT

how can i call all primary key of database (ADODB) using combobox in other form because i want to update a data in other form

Drop Down Menus

WikusHeyns — Sun, 08 Nov 2009 12:39:24 GMT

I am very new to Databases and are busy with my first database. However, in order for it to be practical for my use I would need to pre define inputs for certain fields. (January, Februay, March ...)

In exsample the database I would like to create I need to input the Month in which a person's birth is when entering data from a drop-down list in the "BIRTHDAY" field.

I am using IB Expert and after reading for many hours I cannot see how to do this.

Help with Database Query in VB2008

Booster1977 — Tue, 10 Nov 2009 08:35:07 GMT

Hi everyone!

I've worked with Visual Studio for a couple of years, but it's been a while. I'm trying to build a database driven application, but I can't figure out the new system with the tableadapters and such.

What I'm simply trying to do (to get started) is to compare a username and a password provided in a textbox, with those in the database.

I do understand SQL queries very well so that's not the problem. My question is, what on earth do I put down when I:

Have a table 'users'
that holds a column Username and a column Password
String userinput is what the user entered as username and string passwordinput is what the user entered as password.

I tried to make a query in the tableadapter, that worked fine, but I can't seem to get the output anywhere. If I know how this works I can continue building. So if you guys could give me a head's up that would be most appreciated!

Thank you so much in advance.

René

Help With Database Programming

dryan — Fri, 09 Oct 2009 07:24:10 GMT

Hello to all. My name is ryan and to get to the point, I'm a graduating student at a certain computer school here in the Philippines. For our final project, my instructor has instructed us to make a system. Now, i've already took this subject twice, having failed last time due to database error and now that it's my 2nd time taking up this subject. I would very much appreciate it if any of you could kindly help me out on how to make the database work.

Here are my specs :
Visual Basic Enterprise Edition
MS Office 2007 - I use the MS Access as database
Windows XP SP2

Anyway, the system is all about Dental System. I've already tried and tried and yet failed again to make the database work. I have no problem with designing and coding a few of the command buttons in the dental system. I'm still a beginner with programming so please bear with me.

Here's the problem, the system is all set in terms of design, now whenever i would try to make a database i do it this way;
1. Add - ins --> Visual Data Manager
2. VisData --> New --> Microsoft Access 7.0 MDB

When i get to this part and start designing the table;
1. Should I include all of the fields that i want to be recorded in the database?
2. Should I also include those that are combo boxes?
3. This system that I am making has a search function, can anyone please tell me how to make that work?
4. Where do I go from now?

Basically, I'm asking help for a step by step procedure on how to make the Database work.

My other problem, whenever I'm finished with the table structure and would start to connect it to the system and begin to add the coding for the SAVE Button
I would use

Data1.Recordset.MoveLast
Data1.Recordset.AddNew
txt1.SetFocus

that's my coding for the SAVE button but it doesn't seem to work cause whenever I would
try save a current record through the system an Error Message would pop up that says
Run Time Error ' 3021 '
" No Current Record " Then you have the option to Continue(grayed out) End Debug Help

Please.. Help me out here. I don't want to fail again on this subject. Please do help me.

Please kindly send me a step by step procedure on how to make the database work.
I don't care if I would have to start from the beginning and ruin the whole design of the system as long as the database can work.
I'm desperate right now. I hope that there's someone out there that can help me out T__T

here's my email address
lil_droj_666@yahoo.com
please please please. help me

store image into ms access

trivedi — Wed, 14 Oct 2009 13:30:31 GMT

hi,

i want top store image(.jpg) into ms access using image box or picture control

with vb6 at run time.

how can i store image????

[highlight=#ffff11]note : not path actual picture[/highlight] [/size]

Coding for find or search using DATA Bar

dryan — Tue, 20 Oct 2009 11:39:53 GMT

Hi to everyone. it's me again. sorry for always troubling you guys but the thing is i'm on my last chance to graduate and i have my dental system working and everything is all set but the trouble is i'm having problems with the Find/Search button in which wherein when the user click on the Search/Find(command button) it would open up a new form with One label(label1) named as Enter Patient Number and a text box(text1) and 3 command buttons
SEARCH Patient History
SEARCH Patient Form
EXIT
and since it's a search form i put in two Data Bar, the one wherein you the codings would start as Data1.recordset.addnew etc....
and the reason why it's two Data Bar is because the search form would search a two kinds of patient record, the patient history, which would include the medical records of that certain patient and the patient form which would include the necessary Patient's Information such as Address, Date of birth etc.

the thing is i don't quite get it how to make that search button work. T__T forgive me, i'm pathetic.

i tried to copy down notes from the book VB6 databases by charles williams and all it shows there are how to use the search button using Adodc.
what i did now is tried to replace the necessary Adodc terms with Data1 and i still can't get it right.

in the book it stated about using strings and adding indexes to the labels and text boxes of the form wherein the criteria for searching would work. in my part the criteria for searching would just be patient number so what i did is i put and index number to the Patient number label and the Patient Number text box. i put 0(zero) on both of it.

here's a copy of the coding that i used.

Public Sub FindString()
Dim strFind As String
Dim intFields As Integer

If Trim(txtsearch) <> "" Then
strFind = Trim(Command1)

With Form4.Data1.Recordset
Do Until .EOF

For intFields = 0 To 1

If InStr(1, Form4.txtnumber(intFields), strFind, _
vbTextCompare) > 0 Then
Form4.txtnumber(intFields).SelStart = InStr(1, Form4.txtnumber(intFields), _
strFind, vbTextCompare) - 1
Form4.txtnumber(intFields).SelLength = Len(strFind)
Form4.txtnumber(intfield).SetFocus

Exit Sub
End If

Next
.MoveNext
DoEvents
Loop
MsgBox "Record Not Found"
.MoveFirst
End With
End If
Exit Sub

End Sub
Private Sub Command1_Click()
If Form4.Data1.Recordset.RecordCount > 0 Then
Form4.Data1.Recordset.MoveFirst
Call FindString
Else
MsgBox "Recordset is Empty"
End If

End Sub

Please kindly help me T_____T

Results not showing in Decimal Form Help Pls

deafgal — Wed, 21 Oct 2009 13:56:53 GMT

Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'Total_CMADataSet.Table1' table. You can move, or remove it, as needed.
Me.Table1TableAdapter.Fill(Me.Total_CMADataSet.Table1)
End Sub
Private Sub Strands_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Strands.TextChanged
Dim area As Decimal = CDec(ListBox1.SelectedValue)
Dim strand As Decimal
Label3.BackColor = Color.Blue
Label3.ForeColor = Color.AntiqueWhite
Label3.BorderStyle = BorderStyle.Fixed3D
If Decimal.TryParse(Strands.Text, strand) Then
strand *= CDec(area)
Label3.Text = strand.ToString
End If
End Sub
End Class

The end result is baffling me here are 2 examples when I debug

Mine: 640.1 * 49 = 31364.9
Debugger: 640.1 * 49 = 31360 ( not right needs to show the correct decimal )

Mine: .775 * 3 = 2.325
Debugger: .775 * 3 = 2.325 ( shows it perfectly???)

help with codings for save

dryan — Mon, 19 Oct 2009 03:17:43 GMT

hello to everyone. lately i was able to create the database for the dental system
that i was making and was able to make it work but recently i made a few changes with the form
of the system and these changes are;
instead of text box I used combo boxes with the selection of yes and no.
my question is;
what kind of field type should i use in the table?
should i use text, boolean, integer?
and my other problem is that everytime i tried to save a sample record on the system i would
receive an error message that says
"run time error 3426"
" this action was cancelled by an associated object"
and i get the option
continue
end
debug
help
what i do is i select on debug and then it would of course stop the system and would
highlight the coding with the error.
the error is on the coding for my save button. can somebody please tell me the correct
coding for the save button.
my system has 3 major command buttons and these are:
SAVE
Data1.recordset.movelast
Data1.recordset.addnew
Data1.recordset.update

UPDATE
Data1.recordset.edit
Data1.recordset.update

NEW PATIENT
Data1.recordset.movelast
Data1.recordset.addnew
txtname.setfocus

can somebody tell me why am I receiving that error message?
please do help me T__T

Hooking Keyboard ViA Windows API in Delphi

hossain — Thu, 15 Oct 2009 06:30:18 GMT

Hi guys

Could anyone point me to the direction of some Tutorials on how to Hook the keyboard usings the windows PAI to capture keystrokes,
I want to enable my App to Bring itself too top if certain key combo is pressed, mainly because i want to give the option for my application to hide when user click Hide button. But i have no real way of havign it charm Form1.hide;
to
Form1.show; unless i can moniter all Keyboard strokes.
I know its posible and have been told not too hard. and i know that it wil lrequire building a DLL, buti just dont know how to code it Thanks

-----------------
définition de développement durable

Do MS SQL server have break point like in vb?

Makura — Mon, 24 Aug 2009 05:54:40 GMT

Is there a way in MS SQL server where we can put break point in stored procedure like in vb.

how to select distinct month from the database

Makura — Wed, 19 Aug 2009 03:51:37 GMT

Hi!

I want to select distinct month from the database table. How can i do that anyone can help me.
my database table records are as

Transaction_Date(mm/dd/yyyy)
01/01/2009
01/15/2009
01/25/2009
02/05/2009
02/20/2009
02/29/2009
03/10/2009
03/15/2009
03/28/2009
04/15/2009
04/22/2009
04/27/2009

using where statement less than today(05/01/2009) date

example
month
01
02
03
04

how to connect vb to SQL

Mr.Emopaul — Tue, 22 Sep 2009 01:52:51 GMT

helo.. everyone...! I am Marpaul and i want to know how to connect SQL database to Visual basic.
i am bigginer for programming..Please help me..
my email add Mr.Emopaul@yahoo.com
thanks..

Reports with MSFlexGrid Data

Smartchap — Sat, 02 Feb 2008 11:26:46 GMT

In VB6 in a form there are 10 labels and associated 10 textboxes and 2 MSFlexGrids. There are 5 columns in the first MSFGrid and 7 in the second MSFGrid. There are 3 rows in the first grid and 4 in the second. I want to generate a report (may be using DataEnvironment and DataReport, as I don’t have Crystal Report) in such a way the its output should be as follows:

7 Labels and associated 7 textboxes

Data in First MSFlexGrid (first row showing headings of columns and next 3 rows data)

Data in second MSFlexGrid (in similar fashion as for first grid)

Remaining 3 labels and 3 textboxes in the form

Please help me, if possible by attaching an example program.

Thanks in advance.

Run a query based on form combo box entry

Barry — Tue, 08 Sep 2009 15:42:41 GMT

I currently have a form that contains a command button, which runs a query (below).

Private Sub Command60_Click()
Dim qryLithLogLinks As Hyperlink

DoCmd.OpenQuery ("qryTrendChartLinks")
DoCmd.RunCommand acCmdOpenHyperlink
DoCmd.Close acQuery, "qryTrendChartLinks", acSaveNo
End Sub

The query selects the record, from a table, based on the selected item in a combo box on the same form that contains the command button (below).

SELECT tblTrendChartLinks.Trend_charts AS Expr1
FROM tblWell_ID INNER JOIN tblTrendChartLinks ON tblWell_ID.WELL_ID = tblTrendChartLinks.WELL_ID
WHERE (((tblWell_ID.WELL_ID)=[Forms]![frmWellMaintenance]![Combo34]))

But, I would prefer to have the command button open another form window, which contains a combo box, OK, and Cancel buttons. Then I would like the query to select the same record as the selected item from the combo box on the separate form window. This has worked well with the "On Click" event for reports, which then ran a macro, which in turn opens the form containing a combo box, but cannot do the same with the query only.

OK, I got it now. I first had to set a command button to open the form dialog, and set the "OK" click button to open the query, with the query selecting the record equal to that selected in the dialog's combo box.

DataReport with two tables

Smartchap — Tue, 25 Aug 2009 05:28:02 GMT

I have two tables in one MSAccess database file and want to get output of them one after other. How to place controls in DataReport & how to relate tables in DataEnvironment (or through programming dynamically) is not known to me? Please help. For clarity of question I have attached one file. please lopen the file and understand my problem clearly.

Thanks.

to get the records field

Makura — Tue, 01 Sep 2009 03:53:56 GMT

how to get the records fields in sql server like in vb.

x.open("select name,address from abc"),cn..........................

txtname.text=x!name
txtaddress.text=x!address

Move Next

Makura — Tue, 01 Sep 2009 03:51:35 GMT

do while not x.eof
x.movenext
loop

equals to in SQL server.

How to insert multiple records through stored procedure?

Makura — Mon, 24 Aug 2009 05:50:58 GMT

How to insert all the records of one table to the another table through stored procedure in MS SQL by using loop.

If the records reach to end of file then exit.

Linking VB6 to MSAccess database?

BuzzL30 — Tue, 24 Feb 2009 23:19:32 GMT

My question or topic as it may be is what elements are need to a VB6 project to work correctly with MSAccess db

I know I need at least 1 table, and Queries, and possibly Modules but do I need to create a report?

I know I need to add the fields that want to have in the VB6 project to the table or tables as it may be, but the rest I am not sure of I do know it will depend on what I want in my VB6 this can be answered by reading my other topic I have in here there is a zip file uploaded for any to try and solve this question.

on goto error

Makura — Fri, 14 Aug 2009 09:06:27 GMT

Hi everyone!
I need help me store procedure. Anyone can help me ? On goto error x in store procedure like in vb.

MS Access security

genlight — Wed, 22 Jul 2009 03:32:17 GMT

Hi, I am an access version 2003 user. I know MS Access 2007 and 2010 does not employ User level security to its new database format.

It is cumbersome for me to use the user level security. Not only me but other of different forums.

However I make my own customized way, permissions to forms and report.

However, I would like to know how ULS protect the objects, like when you open the object, it pop ups messagebox saying not permitted. I think ULS employs code to the objects to protect is and the user and permissions are the criteria in that code.

Can somebody help me what is that code. thanks. my email is lubrigas.genesis@yahoo.com

kindly email me please because I am not frequently in the internet. thank you very much.

Simple Math coding in Acces 2003

RCBNewbee — Wed, 08 Jul 2009 13:59:00 GMT

Here what I have

Five numbers inputed into their owner database feilds by the use of a form

Judge 1, Judge 2, Judge 3, Judge 4, Judge 5

I need the high and low remove and the remainder 3 numbers added up and it will be put in feild call Total (which is displayed in my form)

Then i am dividing this by 3 and putting it in a feild call score which is also display .

I have the table,forms created just need the VB code for the feild Total,

I already have VB code for score

I know this is simple but I am new and only doing this as a hobby

Thanks

how to calculate complex interest calculation in stored procedure

Makura — Wed, 08 Jul 2009 04:52:54 GMT

Hi! I'm trying to develope co-operative software but having problem calculating interest in stored procedure. But i can do this from front end using vb.net. Can anyone can help me regarding this problem.

My database is in microsoft sql server 2005

AccountInformation (table)

Acct_Id numeric,

Acct_Holder_Name varchar,

Acct_Type tinyint,

Interest_Type tinyint,

Acct_Open_Date

Master_Journal_Voucher(Table)

Tran_ID numeric,

Tran_Date datetime,

Jv_No numeric,

Remarks varchar

Details_Journal_Voucher(Table)

Jv_No numeric,

Particular varchar(Acct_ID),

Dr_Amt numeric,

Cr_Amt numeric,

IsInterestCalculated tinyint

Here, every account has to be compare with the AccountInformation and Detail_Journal_voucher. If there is no transactin in Details_journal_voucher then it has to skip and move to next records for further calculation.

Error Class not registered

sok — Wed, 24 Jun 2009 04:43:42 GMT

I developed application with access 2003 under windows xp service pack 2. It works good, but when i run this application with access 2003 under windows xp service pack 3 it shows error "class not registered - 2147221164". How can i fix this problem? Please help me.

Database Help

kiwi2047 — Fri, 26 Jun 2009 02:15:29 GMT

hi friends
i am using adodc control in VB 6.0 and connecting it with MS Access I have one query
can i create a table in my database through VB while run time?? Please help me

Problem with file OWC11.DLL in MS Access

sok — Tue, 23 Jun 2009 04:13:44 GMT

Hi all,

I developed one project using access application(Ms Access 2003). I can run this project with windows xp properly, but I cannot use this application that i developed in MS Access 2003 with Windows Vista and Ms Access 2007. When I run this project with Acces 2007 it appears error "Your Microsoft Office Access database or project contains a missing or broken reference to the file 'owc11.dll' version 1.0.

How can i fix this problem? Please help me. Thank you.

a network database

rocks_lp — Mon, 22 Jun 2009 12:07:48 GMT

for my vb project, i have to develop a system for a network environment. it means a central database to the application. i don't know how to do that. i am hoping to do a sql database. guyz please help me to do this. if you have any tutorials or any of your advices, will help me a lot.

SQL Express

shers — Mon, 23 Feb 2009 07:02:33 GMT

Hi,
I'm new to SQL Server. I just installed SQL Server 2008 Express. Then I opened Management Studio, right clicked on Database and created a new Database. Then I expanded Database, right clicked on Table and created a new Table. Now, my question is, how do I add data to the table I created?

Thanks

Help on Creating a Basic ATM System

sirk — Fri, 13 Mar 2009 07:52:10 GMT

Hi,

I am trying to make a basic ATM system, iv got all the interface done and I have made the link to my SQL database etc. the part i'm stuck on is how I can run a check to see if a bank card number matches up to the users PIN number.

To simulate the user putting a card into the machine I've used a combo box, and that lists all the cards, that haven't been flagged as confiscated (there's a column in my ATMCards table that I can set to true or false) then after the user has selected a relevant card there's another text box where they can enter in their PIN number. Now what I want to do is, if they chose the card number 1234567890123456 in the combo box and they enter in the PIN 1234 into the text box, then, after clicking the check PIN Button if the pin is correct they need to be taken to another from where they can check their balance etc., and if its wrong they got three attempts after which point i want to flag that card as confiscated.

I know I'm asking quite allot but I'm really stuck I don't even know where to start any help would be greatly appreciated. I'm using VB .net 2005.

Thanks in advance

SQL Express Account

shers — Thu, 26 Mar 2009 07:09:55 GMT

Hi,

I'm using SQL 2008 Express with a multi user VB.NET Windows application.

Do I have to add each user to the SQL user account? Does NT Authority\SYSTEM work? I do not know how this works. So far I have NT Authority\SYSTEM in the Security-Logins of the Server. But do I have to add it also in the database? In the databse Security-User, I have the following:

dbo
guest
INFORMATION_SCHEMA
sys

I tested the app in one of the users and it gives me error as follows:

Cannot open database "Print" requested by the login. The login failed.
Login failed for user domain\username.

What could be the reason?