Thank you isladogs for replying,
As per your suggestion, I have also tried encrypting the data on the backend file of another program but there also the program has become slow.
Well I completely agree with you. If you can make and provide a simple video of migrating access backend to sql server as mentioned in post #3, it would be greatly appreciated. I have searched in Google and found out that if the Access backend file is migrated to SQL Server then the data limit of the Access backend file increases from 2GB to 15GB and With this, frontend programs can be accessed at a much faster speed without any interruption. Is this correct?
Thank you again.