Hi All,

thank you for reply, and the macros will do check the input data is available or not first, then copy and paste the data each cell wise from the Excel sheets and create a flat excel work sheet. then from this flat file the data will go in to the access tables (holding tables).

in the access macros the data from holding tables will go into processing tables then back to excel sheet as out put.

in between...

Hi Jim,

thank you for your reply, and as you asked
all users are using MS-Office 2010
and i did the split of database and i am using MS-Office 2007
and before the split it was working fine without any delay
and there is no slow in any macro(Excel or Access)
and we place the back end database in one server
and placed Excel file and database front end file in each user local systems
so now we tested...

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...