Stop the editing of the backend database

[Tsango]

How can you stop people editing the data in the backend database from the linked table in the front end?

The back end is passworded but you can still change data manually from the front end.

Can this be stopped?

 

[bach]

Hi

Cant you stop them from making changes by disabling the fields on the form, making them read only. ??

 

[RuralGuy]

What you are describing is a normal way a FrontEnd and BackEnd interact. Do you want to open the BE linked tables as ReadOnly?

 

[Tsango]

Yeah, see what you are saying but if they are read only then the VB code will not be able to write to them either.

I can see the logic now that if you need to write to the database in the code then how can you distinguish the difference between doing that and the user going into the table and changing the data....!!

The reason I need to do this is that I want to make each application different by having the company name on the main front screen so they would not want to copy it and pass it onto another business. I want to store the company name in a database rather than hard coding it so that updates are easy.

If the user can access the database then they can simply change the appropriate fields.

I may work on an encryption for the fields instead.

 

[RuralGuy]

You need to lock down your project. Uncheck everything in the StartUp menu and only release MDE files.

 

[ghudson]

Using Access security with a custom workgroup file and user permissions will protect the data of the db and also prevent the importing/exporting of the db objects and data. The MDE method will protect your code and the design of the forms and reports but not the design of the tables and macros and it will not protect the data in each table. Search around for this topic has been asked and answered is so many threads

 

[Tsango]

Thanks for your help guys