Question Close the Access DB present in network quickly.

[teja]

Hi all,

I have Access as front end and SQL Server as back end. The Access application is placed on a common network drive for theusers to access it. The compact on close option is enabled when the access application is closed.

I have a local copy of the access app. When I close the app, it takes ony a few seconds. But when on a network drive, it is taking 2 mins.

I just wanted to know if the time taken to close the application on the network drive can be brought down without disabling the compact on close option.

Thanks in advance.