Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 5 of 5

Thread: how to get last modification time of ms access database table using java

  1. #1
    Junior Member
    Join Date
    Jan 2012
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default how to get last modification time of ms access database table using java

    hi....
    I am working on incremental backup project for ms access database.
    But i have problem in getting last modification date-time of tables using java.

    please help me...


  2. #2
    Forum Squatter newbie's Avatar
    Join Date
    Nov 2010
    Location
    North Wales
    Posts
    661
    My Mood
    Stressed
    Thanks
    28
    Thanked 115 Times in 106 Posts
    Blog Entries
    1

    Default Re: how to get last modification time of ms access database table using java

    You have a few options here, you could either;
    1.) Use database triggers
    2.) Have a "Last updated" column in your table, and update it with a Date object whenever an update/insertion is performed

    There will be other options which work, but you could easily find them through Google.
    Best of luck.
    Please use [highlight=Java]//code goes here...[/highlight] tags when posting your code

  3. #3
    Forum Squatter newbie's Avatar
    Join Date
    Nov 2010
    Location
    North Wales
    Posts
    661
    My Mood
    Stressed
    Thanks
    28
    Thanked 115 Times in 106 Posts
    Blog Entries
    1

    Default Re: how to get last modification time of ms access database table using java

    Please use [highlight=Java]//code goes here...[/highlight] tags when posting your code

  4. The Following User Says Thank You to newbie For This Useful Post:

    seemone (January 7th, 2012)

  5. #4
    Junior Member
    Join Date
    Jan 2012
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: how to get last modification time of ms access database table using java

    thanks!


    But database( whose table's modification time i want to know ) is selected by user for backup through my software .
    so ,i can't change database tables in any way.

    please give me some other solution which works without any change in database.

  6. #5
    Forum Squatter newbie's Avatar
    Join Date
    Nov 2010
    Location
    North Wales
    Posts
    661
    My Mood
    Stressed
    Thanks
    28
    Thanked 115 Times in 106 Posts
    Blog Entries
    1

    Default Re: how to get last modification time of ms access database table using java

    If I've understood you properly, you have software which backs up user specified databases and their tables, in which case I don't have any idea how you could get the information if you've never seen the database files before.
    This isn't to say it isn't possible, but without it being a table created by your software, I just don't know.
    Please use [highlight=Java]//code goes here...[/highlight] tags when posting your code

Similar Threads

  1. [SOLVED] I have a problem with this java code for database access
    By abhiM in forum What's Wrong With My Code?
    Replies: 3
    Last Post: August 19th, 2011, 04:52 AM
  2. how to access mysql table using java and display it?
    By vivin09 in forum Member Introductions
    Replies: 2
    Last Post: August 10th, 2011, 03:41 PM
  3. Stop Access Table Locking
    By aussiemcgr in forum JDBC & Databases
    Replies: 4
    Last Post: February 4th, 2011, 07:23 PM
  4. how to import excel file to database table using java
    By palani in forum File I/O & Other I/O Streams
    Replies: 2
    Last Post: September 3rd, 2010, 01:17 AM
  5. Replies: 6
    Last Post: August 18th, 2010, 06:41 PM

Tags for this Thread