Can't Open Table Error Message

Question

In my access 97 database (yes we are finally getting ready to update), I have two tables that are linked excel csv files.  I have multiple other standard tables.  I have a switchboard with buttons that execute macros.  One button opens a report that is based on a query of these two table and others as well.  I have a second button that opens a different report which is based on a different query of these two tables and others as well.  This database is housed on our served and accessed by mutliple people.  If somebody has the one report opened, I cannot access the other report.  An error message box appears and states that my macro calling the report has failed because it cannot open one of the linked csv files.   In my macros, I actually have steps to close all the tables just in case I was missing something.  Sure would appreciate some help with resolving this issue.

Thank you,

RJ

Answer 1

Since I don't know what your database looks like or how it is being used by the users I can't give you a real good answer.  But yes, it would entail importing, but finding the right way to do it automated so the users weren't really affected.  Any info you can provide might help me (or us) give you a better, more specific answer.

Answer 2

All,

Thanks for replies. 

Karl,

1. Even if I am the one that has the one report open, I cannot open the second report.  In other words, my macro should close all the underlying tables and queries for the first report which should allow me to open the second report.

I guess a question to ask would be, when are the underlying tables and queries "released' or "unlocked" when used to generate a report.  If I have a report opened, do all the underlying tables and queries remain unavailable until the report is closed?

2)  I don't have front ends and back ends.  Just started reading about that method.

Bob,

If I have information downloaded from our mainframe to our server every 20 min, what is the better way to make the data available to access without having to have the user run a command to import the data?

Thanks,

RJ

Answer 3

Using linked files as a recordsource can be a bit of a problem when you have more than one user using the database.  Personally I don't use them if at all possible.

Answer 4

 In my macros, I actually have steps to close all the tables just in case I was missing something. 

Your macro will not close someone else open.

Do each have their own front end?