Actually i have one Excel file and one Access DB with macros in both files.
Here the Excel macros is calling the Access macros at the runtime
As the excel file users are more than one, i split the DB and planned to share the Excel file and front end DB to all users
here its working but a performance issue occurring, each user is taking 60 minutes to complete the excel macros to run(including access macros)
so please help us in getting best performance here
we heartfully appreciate the solutions
advance thank you...
Best regards,
Raghukanth