Networks
by ssumahh Accepted solution
by hal 9000 Accepted solution
If you want to lock down a DBase page or file you'll need to use SQL over a LAN and set the settings on the master machine that has created the DBase.
Access is a desktop work environment and is working properly. In this case you are using the wrong tool for the job that you want to do.
Col
by georgeou Accepted solution
MS Access isn't really designed for robust network level security. You can port the data over to MS SQL Server 2005 Express Edition which is FREE. There is a simple porting mechanism. Then you only use MS Access as the front end on the client side and it's infinitely faster than trying to slush the entire Access DB over the network.
If you do this, you've killed two birds with one stone. Not only do you get better security, you get much better database performance and scalability. Best of all it's free and if you want to eventually convert to full blown SQL Server, the data structure in SQL Server Express is identical to SQL Server.
This discussion is closed to new replies.
Sort by Trending