Hi guys,

Could you please tell me if I should wait on a back end that no users are
connected before re-importing a table?

Basically I have csv files that I import into tables that are my libraries,
or my hierarchy if you want. They have 1000 records max, but I was wondering
if I can do that while users are on the db?
They will mainly run queries and reports, so no record locks supposedly.

For now I only trigger the import on the load event of the main form, if the
ldb file is not present in the back end folder, but it means that only the
first user who opens the db will be able to trigger the import... and who
knows if he will ever be able to log alone. It would be luck but I don't
know...

Anyhow thanks for any answer and for that great forum.
T_D

Shouldn't be an issue.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"The Dude" <f_com2°AT°yahoo°DOT°fr> wrote in message
news3E4E9AD-F0CE-436E-ADDA-(E-Mail Removed)...
> Hi guys,
>
> Could you please tell me if I should wait on a back end that no users are
> connected before re-importing a table?
>
> Basically I have csv files that I import into tables that are my
> libraries,
> or my hierarchy if you want. They have 1000 records max, but I was
> wondering
> if I can do that while users are on the db?
> They will mainly run queries and reports, so no record locks supposedly.
>
> For now I only trigger the import on the load event of the main form, if
> the
> ldb file is not present in the back end folder, but it means that only the
> first user who opens the db will be able to trigger the import... and who
> knows if he will ever be able to log alone. It would be luck but I don't
> know...
>
> Anyhow thanks for any answer and for that great forum.
> T_D

Ok thanks Douglas

"Douglas J. Steele" wrote:

> Shouldn't be an issue.
>
> --
> Doug Steele, Microsoft Access MVP
> http://www.AccessMVP.com/DJSteele
> (no e-mails, please!)
>