Trouble with custom query

  • Thread starter Thread starter SGT Buckeye
  • Start date Start date
S

SGT Buckeye

I am trying to write a SQL custom query that inserts data from a form
into an access database called Bonus. The database is located in a
folder called fpdb. The form fields are called Username and Password.
The columns in the database table are called Username and Password. I
followed the following steps: 1) Insert > Database > Results 2)
Selected the database and clicked Next 3) Selected Custom Query and
clicked the Edit button. This is the custom query that I am using:

INSERT INTO Bonus (Username, Password) VALUES ('::Username::',
'::Password::')

I get the error message that there is a problem with my custom query.
Am I doing something wrong? Please help.
 
I don't see any thing wrong with the INSERT query. Is there a URL that we can see the entire error message?
 
Hi,
I believe password is a reserved word in Access. Try
INSERT INTO Bonus (Username, [Password]) VALUES ('::Username::',
'::Password::')
 
Back
Top