How to connect vb program to access 2007 room bookings?

Asked By 30 points N/A Posted on -
qa-featured

 

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.

  • Answer Accepted: No
  • Question Category:
SHARE
Answered By 0 points N/A #166269

How to connect vb program to access 2007 room bookings?

qa-featured

 

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
  • Posted on -
  • Question Category:

Where to find the Microsoft SQL manager for Linux?

Previous

How to find percent as2?

Next

Related Questions