how to activate a macro file in another access file

[sunilvedula]

hi all,

i have divided my access file into 2 components. one is the front end and the other is the backend which contains tables only. Now the problem i have is i run a macro which loads the data from an excel sheet into the tables. I cant run the macro on the front end since they are all linked tables. i need to run the macro on the backend file which will load data. How do i activate that macro in the backend file from the front end file. how do i mention it? docmd.run macro "what do i give here"?

 

[namliam]

You can run the macro in the FE to load data into linked tables no problem...

 

[sunilvedula]

thanq a lot. i was worried it may lead to problems but it worked fine