MaryLustion

 Profile Answers by MaryLustion 

• Apr 10th, 2008

 

+ Its recommended to split the database in Frontend and backend.
+ Put the backend on a server/common computer.
+ Give appropriate permissions on the folder for all the users who would be using that database
+ Then Save a copy of the frontend on all the local computers of the users.
+ Make sure the linked tables are refreshed.
+ This method helps in preventing corruption to a great extend.
+ You can also keep the frontend on the server along with the backend and have shortcuts for the frontend on the local computers.
+ But this is more risky as it can cause corruption in DB
+ Having a non-split database is also another method but not recommended by microsoft.

johnjustin

 Profile Answers by johnjustin Questions by johnjustin

• Apr 14th, 2008

 

Place the database in a computer which is connected in a network. Place the front end application in all the computers connected in the same network. Modify yor code in such a way that the applicaiton is accessing data from that computer where the database is available.