protecting tables from Importing

[lana]

Hi there,

I developed an access2003 program and I made .mde file from it.
It works fine and no one can access the tables.
BUT when the user creates a new DB in Access and imports from my file then he can have all the tables.

Is there any way I can prevent this?

Cheers

 

[JHB]

You can not guarantee you 100% no matter what you do, if the data is on a computer.
If people want to see your data, they will find a way to do it.

 

[GSSDevelopment]

You can try separating the front end and the back end, which should only make the links importable rather than the tables themselves. I'm not sure if / how that works in 2003, but it's another layer they have to work through if it works.

In general, Access isn't designed to be a true end user application. It's a database management tool through and through. If you don't trust your users having access to the data, giving them an Access front end is a bad idea.

 

[lana]

thanks for the reply.
can you explain how I can separate front end and the back end?
Cheers

 

[GSSDevelopment]

Like I said, I have limited experience with 2003, but you should be able to make a separate mdb file and link to the tables in your first database. Then copy your forms, queries, modules, and reports to the new mdb, and make an mde from it.

That prevents users from editing the table structure. Keep in mind, users importing data from the separated front end file will still be able to see and edit table data, just not the structure.

Cheers

 

[Galaxiom]

Although the database definitely should be split anyway, it isn't going stop the tables being imported. The backend must be linked from the frontend so the users can still get to the tables and import them from the backend.

If you want data security the only way is to put the backend on a database server such as MS SQL Server or MySQL.

 

[lana]

Thanks for the replies.

I did your suggestion (BE, FE) but still they can access to the tables. I have an accounting program which is written in Access and they did set a permission on it which prevents the user from accessing the tables but as much as I read and tried I still can not do that!!
I did set permission (group, user ...) and it works on my system and asks the password and all that but when I copy the program on another computer then everything is accessible.
Any help on that?
Thanks again.
Cheers