Auto Exec on load??

[mohsinhq]

Hi,

I have a macro which runs when my database is opened.
basically, the macro runs several querys to create a new table.

The problem is that i only need the macro to run once a day - so for only the first person who opens the database that day.

At the moment, everytime the database is opened, the autoexec recreates the table - and has been leading to annoy the users!

Please help - need to know how to limit the execution to once a day for first user

Thanks in Advance

 

[KenHigg]

Why can't you just have one table and post whatever info you need in it and include a current date fld? Then you'd be able to check to see if the data for that day existed before you re-posted it?

kh