I have an Access file which was frontend(Is just linking Tables .. but do have local queries,forms and reports) to Sql server backend ..whether the size of it be reduced after compact ?
What i did was, i copied their .mdb file and tried to compact is failing still saying the following error 3197(Multi user envt).
But my doubt is i copied the .mdb file to my machine , who else will open that ?

Can any one pls advise me on this

Thank you