Delete/import a table from csv; wait for no users?

T

The Dude

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
 

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

Cannot import CSV file into ACCESS 1
Csv import: direct link vs temp table dump 2
Export / Import 0
Create a chart from a table in word thats dynamic 0
Access Lock File .LACCDB / Now shows as a notepad file 0
Import Multiple CSV Files from Same Folder into Open Workbook 5
Incorporating the User Profile location into a document template path 1
Access Project SQL Import csv 4

Top