We're a community of 1.1M IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,080,434 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

Visual Studio Pro 2010 - linking access database

Hello All,

I have starting using Visual Studio Pro 2010 and I understand the very basics in programming. Currently I am trying to create a login system where users enter their usernames and passwords.

I have been experimenting with trying to link Access database to MySQL but im having no joy. I have created a query which works but I dont know how I can link the query into the login form. According to some other forums this cannot be done in 2010?

I want to create some sort of database where I can have a record of all users that can log in. I want to be able to edit or delete users from logging in. ( I spent about 2 hours yesterday night only to start from scratch again )

Does anyone have a link to a website which can guide me or if someone can post up the process. Programming noob so may need to be a simplified guide.

Many Thanks

2
Contributors
4
Replies
21 Minutes
Discussion Span
1 Year Ago
Last Updated
5
Views
ads1188
Newbie Poster
14 posts since Feb 2012
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

You don't link the database itself, but a library of functions. There are at least two ways to do this:
1) ODBC -- see this tutorial

2) ADO -- tutorials here

Both the above require a good deal of programming and require a good grasp of c or c++ languages. Some of the tutorials are written for vb, but they apply to c/c++ too.

Ancient Dragon
Achieved Level 70
Team Colleague
32,275 posts since Aug 2005
Reputation Points: 5,852
Solved Threads: 2,591
Skill Endorsements: 70

You don't link the database itself, but a library of functions. There are at least two ways to do this:
1) ODBC -- see this tutorial

2) ADO -- tutorials here

The links you provided dont work. They dircet me to 'Google Home Page'.

ads1188
Newbie Poster
14 posts since Feb 2012
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

They worked ok for me -- the links are a list of google links

Ancient Dragon
Achieved Level 70
Team Colleague
32,275 posts since Aug 2005
Reputation Points: 5,852
Solved Threads: 2,591
Skill Endorsements: 70

They worked ok for me -- the links are a list of google links

Managed to get it working. Link looks like what I need to start learning. Many thanks. I'm sure there will be loads of noob questions from me in the near future so my apologies in advance :)

ads1188
Newbie Poster
14 posts since Feb 2012
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
View similar articles that have also been tagged:
 
© 2013 DaniWeb® LLC
Page generated in 0.1007 seconds using 2.68MB