Refresh Tables on opening

[Tempy]

Hi all,

I have a database that i need to import an excel sheet into every day.
Is it possible that the first person to open the database access will
import the spreadsheet and then not again untyil the next day. I have
tried this on start up with a macro, but it then imports every time
somebody opens the database.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

[Justin Hoffman]

"Tempy" <an*******@devdex.com> wrote in message
news:_7***************@news.uswest.net...

Hi all,

I have a database that i need to import an excel sheet into every day.
Is it possible that the first person to open the database access will
import the spreadsheet and then not again untyil the next day. I have
tried this on start up with a macro, but it then imports every time
somebody opens the database.

Tempy

Create a new table to hold general info about the database e.g. tblDbInfo
give it an ID column of type long with a validation rule of "=1" so the
table can only ever have one row. Another column should be LastImportDate =
Date/Time.
The import routine should update the LastImportDate column after it has
finished, so then when somebody ones the database the macro only runs if
this field is at least 1 day old.