How to connect vb program to access 2007 room bookings?

Asked By Amanda Mitchel 30 points N/A Posted on - 12/23/2012

 

Hi,

How to connect vb program to access 2007 room bookings? I am done with the graphical user interface of the program; I already did the log in system but not yet connected with the database. Can you give me some idea on how to connect vb programming language to a access database system?

Thanks.

 

Regards,

Amanda Mitchel.

• Status: Open
• Question Views: 725
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Barbara Miller 0 points N/A #166269

How to connect vb program to access 2007 room bookings?

 

Hello Amanda Mitchel,

You can connect Visual Basic to Microsoft Access via coding. The ADODB object is needed to create a link to the database and gain access to the records using ADODB.connection and ADODB.recordset APIs. SQL is needed to search the database for records that equad the information provided as parameters to the subroutines. I have written the code in Notepad and attached it to this message, please try it out.

About Barbara Miller

Questions
0

Answers
101

Best Answers
46

• Vote Up 0 Vote Down

• Posted on - 01/24/2013
• Question Category: MS Access