Re: Problem reattaching databases

From: coder69 <shutup>
Date: Tue, 23 May 2006 20:25:19 -0700

ei, can anyone help me??? its my first time to code in vb 6... im having
a proble with my insert into statement...

Runtime Error '2147217900 (80040e14)'

this is my code:

Connect = " Provider = Microsoft.Jet.OLEDB.4.0; Data Source =
C:\coder69\HRM.mdb"
Conn.Open (Connect)
SQL = " INSERT INTO GuestInfo(GuestID, LastName, FirstName,
MiddleName, GAddress, ContactNo, GNationality, RoomNo, RoomRate)
Values(" & txtGuestNo & ", '" & txtLastName & "', '" & txtFirstName &
"', '" & txtMiddleName & "', '" & txtAddress & "', '" & txtContactNo &
"', '" & txtNationality & "', '" & txtRoomNo & "', " & txtRoomRate & ")"
Conn.Execute (SQL)

is there a problem in my code???

i really appreciate ur help...

thanks
coder69

*** Sent via Developersdex http://www.developersdex.com ***
.

Follow-Ups:
- Re: Problem reattaching databases
  - From: Bob Butler

Prev by Date: Re: VB6 IDE just seems to quit randomly
Next by Date: Re: Problem reattaching databases
Previous by thread: Time Function Problem
Next by thread: Re: Problem reattaching databases
Index(es):
- Date
- Thread