Relink the tables take a lot of time when other users using that!!!

[Fekri]

Hi,

I have an accounting Program which made by ACCESS 2003.

one year Accounting Data will store in the separate mdb files which all tables are linked to the Accounting program.
when they start new year program will made one copy from mdb file and named by for example 2008.

Now, when they want to use last years data they have to relink the all tables to access the last years mdb files.

every thing are ok, but the problem is:
if one user is linked to the year for example 2006,
other users during relink the tables to access the same year "2006" will take long time such as 8 minutes.

what I can do to solve this problem??

Thanks for any idea
Fekri

Thanks & Good Luck
Ali Fekri

 

[lespaul]

Well the correct answer is you shouldn't have a system that has a different table for each year.

I don't think there's anything you can do to fix your issue of the amount of time it takes to link.

Leslie

Have you met Hardy Heron?

 

[Fekri]

Thanks for your reply but I'm not agree with you.

because this way is more secure for the companies.

if they want to kepp backup of their years data they can do and if the current year file damaged, last years are safe
And also after 20 years accounting data they have not the large kb file that can make many problem for them.

So, I'm beleive to have continue this method like this,

Atleast can tell me, is there any way to check if any users linked to the special mdb.file to prevent this relink at this time??
for example: if the users know at this moment relink will take lonk time because other users are using same year, they will change theit accounting year later when they are out of programs???

Thanks
Fekri

Thanks & Good Luck
Ali Fekri

 

[lespaul]

Well you are free to disagree but I doubt anyone else is this forum is going to agree with you.

Having identical tables breaks the rules of normalized database development.

Good luck.

Leslie

Have you met Hardy Heron?