triggers in MS Access

G

Guest

Hi,
Can I write triggers if I am using only MS Access connected to Java front
end through JDBC and no MS SQL Server? (I am new to database programming).
I need to do two things:
1. Generate a report automatically at say, 21:00 hrs
2. Insert one row to two of the tables in the database at 23:59 hrs.
Atleast, I should be able to insert these rows when a row in the same table
is accessed.
Is this possible to do in MS Access? I am using MS Access 2000 on Win XP.
Please help me
 
T

Tom Ellison

Dear Prashanth:

There are no triggers for Access, but that's not what you need anyway.

Create a separate, small Access application that performs these tasks
automatically when they are opened. Link the necessary tables to
them. Use the system scheduler to run them. Each can just close when
it is finished. You may want to generate a small report or send an
email showing they executed and any important details.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Regarding MS Access and Storeed Procedures 1
Using Passthrough Query to Disable Triggers 4
vlookup in ms access 1
MS Access Query criteria Problem 2
multiple users' simultaneous access to a MS Access database 4
multiple users' simultaneous access to a MS Access database 0
Triggers in Access 2
Access Tricky IIF statement in Access - Grrrr 2

Top