how can i make multi user access database

[waqas]

Dear All Experts,



i have build a single user application in access 2010. now i want to build multi user application and want to deliver to end user.

kindly guide me how can i do it? and how can i make my all vba code safe from end users.

thanks

[RayMilhon]

To change from a single user to multi-user split the DB into a front end and back end. Data goes in the backend everything else goes into the front end. The front end is then copied to each user's Computer.

To make VBA Code Save convert the front end to an MDE file.

[waqas]

dear experts,

i am using access2010 and i tried to convert it accde it is done. its lock module, reports and form to open in design mode but queries and table still any user can open and change it. how can i lock it too.

[RayMilhon]

as far as the backend where the data is stored I've made it a hidden file it's generally safe from most users. You can also hide queries in Access and the user can't see them. I don't believe they can change any properties of tables or queries in an ACCDE File but I'm not 100% sure of that.