Question:
How to create database at server side and forms at client side in ms access?
1970-01-01 00:00:00 UTC
How to create database at server side and forms at client side in ms access?
Three answers:
?
2016-06-01 08:40:18 UTC
they run a website off of MS access? wow, that's not a good implementation. However, you use SQL queries to talk to the database. The script files use either ODBC drivers or JET drivers to connect to the database, then you send the query, and get a result set back. Look up odbc and transactional sql to get some tutorials.
?
2010-04-16 09:48:12 UTC
Simple solution.



Store your Access Database on the server.



Grant you users the modify NTFS permission, and also deny them the Delete permission.



If you have the proper licensing, you can deploy the MS Access Runtime component instead of giving the users the full MS Access program on their computer.
Capt Crasher
2010-04-19 14:43:08 UTC
"i want that no user on client side could access the database on server" would make sharing the DB impossible, since they need to "access the database" tables to work in the DB (unless You want to script a daily file import/export/update process... not enough room here to explain THAT).



In general though the best way to do this would be to create a "Master DB" with All of the Tables/ Queries/ Forms/ Reports/ etc... Then make a "Front-end" with the Forms/ Queries/ Forms/ Reports/ etc, BUT with LINKS to the "Master DB" Tables rather than actual tables.

Now copies of the "Front-End" can be distributed to individual desktops, and They all read/write to the same tables (on the network).



As for security, You can "lock it down" within Access through the START-UP OPTIONS (See the main tool bar>>TOOLS>>STARTUP...) by turning off the pop-up menus, hiding the DB window, and setting a "STARTUP FORM". But be aware all of this (in fact ALL MS Access security measures) can be bypassed by holding down the "SHIFT" key when You open the DB ("Back-door" for editing).



To make a truly Secure DB You would have to write it in VBA or SQL Server or some other more robust DB application.


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...