Hi All
Our programmer has just left the company for pastures new and I have been left to pick up the pieces, unfortuantly I have never used MS SQL or Visual Studios 2005, but I am now required to support our in house applications, at the moment we are far to busy for me to go on any courses, so I am looking for tutorials or guidance..
At the moment I have a form in VS2005 with three text fields, FName, SName, Age. IN SQL I have a database called training, with a table called information with 3 fields First_Name, Last_Name, Age. I have a button on my VS2005 form called Add Record, so basically I want to be able to fill information in the text fields, click on the Add Record button and populate my SQL table.
On another VS2005 form I have 3 text fields again, but what I want this time is to display the record from my SQL table, and have some sort of buttons to move between records, add a record or delete a record..
Any help is appreciated
Regards
Djbell
Answers (1)
0
Ahhh yeah thats a good idea.. I my query was just a select (*) where password = password..
I guess pulling it and comparing it will work and just as easy. Thanks. :D
0 This can be an issue with any database. SQL Server is not case specific, and apparently Access is as well(don't know for sure about Oracle). I know how to fix the issue in SQL Server, but I've never dealt with it in Access. Here is a page I found that helps somewhat:
http://support.microsoft.com/?kbid=209674
Alternatively, you could do a select on the database for the given username. Select the password, it should be returned to you with the case retained, and then you can do the password comparison within your code.
0 Hi......
It is from Access.....
Good luck......