Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using data base Access

 
Kendra Payne
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I am new to Java and don't know much. I am trying to build a simple program to access my MS Access database. I am not sure how to put all of the components together. My ins gave us parts but I don't know what to do with them.

Any help is appreciated-thanks so much


[ February 04, 2007: Message edited by: Kendra Payne ]
[ February 04, 2007: Message edited by: Kendra Payne ]
 
Henry Wong
author
Marshal
Pie
Posts: 21116
78
C++ Chrome Eclipse IDE Firefox Browser Java jQuery Linux VI Editor Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am new to Java and don't know much. I am trying to build a simple program to access my MS Access database. I am not sure how to put all of the components together. My ins gave us parts but I don't know what to do with them.


Well, these are three different programs. The first will create a table, the second insert items into the table, and the third will select items from the table. These are more like example programs, than callable code. I guess you are suppose to use them as examples to create what you need.

Henry
 
Kendra Payne
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks!
Do you know you to change the names of the columns? I can get the table to create but when I change the names from say MyColumn1 to a title I would like to have, I get a syntax error when I run the application.
 
Paul Clapham
Sheriff
Posts: 21107
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, normally you would just use Access to open the database in design mode and change the column names there.

As for the syntax error, it would be more useful if you gave us a description of the error and also of the code that causes the error. Including the SQL statement that is the problem. You will appreciate that we can't tell much about your problem if we only know that you have a syntax error.

Edit: And normally you wouldn't even use a Java program to create your tables in the first place. You would just design them in Access. So don't pay any attention to that first program.
[ February 06, 2007: Message edited by: Paul Clapham ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic