File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Ms Access update field automatically Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Ms Access update field automatically" Watch "Ms Access update field automatically" New topic

Ms Access update field automatically

Loh Ying Hui

Joined: Feb 03, 2002
Posts: 22
I need to add numbers automatically into a certain field in a table for every record whenever it reaches month-end. This action has to be automatic, means, no action button should be clicked by admin for this. How is this possible with Access ?

Regards,<br />Ying Hui
Amit Tiwary

Joined: Feb 13, 2003
Posts: 22
I have posted a one like urs.Hope u get answer quickly.
Where r the brains today???
It might be due to Valentines day.
Anyway,Happy Valentines day
Peter den Haan
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
Is this a JDBC question?
In SQL Server you can set up a stored procedure that executes every so often. I don't have a clue about Access; it's probably much more limited.
Alternatively, you can use the WinNT/2K/XP scheduler to run an Access or Java application every month.
- Peter
I agree. Here's the link:
subject: Ms Access update field automatically
It's not a secret anymore!