Hello,
I'm back.
As the banner says: it's been a while since my last post.

Now I want to make my MDB project file secure.

The only thing I need is that the users of the MDB or MDE file weren't able to read the data on the Tables.

I just need that the users only can access to the data on the Tables using only my pre-designed Forms.

Is there any way to do this? Or I need to go for an SQL Server?

I've been reading about this software:
http://www.mindwarp-consultancy-soft...-download.html
Does any one knows about it?

Also, I don't get if the MDE file could help me:
http://help.lockergnome.com/office2/...ict146747.html
http://office.microsoft.com/en-us/ac...578511033.aspx
As I see only secures -a little more- the VBA code.

Any ideas?
As always: thank you in advance for your time and comments.

Regards,
pepemosca

The only way I ever feel that the data is secured is to put it on SQL Server. That in itself doesn't do much, but when you combine it with MDE, unbound forms and connecting to the server without using table links, the data starts to become quite secure.

I often use a "low security" setup where the db window is hidden from the user and the "bypass shift key" is disabled. That stops most people opening it and getting access to the tables.

How do I "connect to the server without using table links"?
What do you mean by that?

Thanks!

That's another topic.

Here it is: http://www.dbforums.com/showthread.p...05#post6315605

Thank you for the advice and the link!

You're most welcome

Does anyone knows any way to code the contents of the tables?

I mean, any way to encript the contents of the table and a VBA code to decript it?

Any ideas?
Thanks!

OMG!!

* Runs away and hides under the bed *

You could probably do it, but there would be a significant performance hit... and a significant development time hit too.

And no, I have never attempted it. If I really want to secure the data, I always lean toward SQL server type data platforms.

Yeah, I know. But my IT department charge me a loooot for a SQL Server access.

I'm thinking about a different solution.

What about MySQL... that's free.

Yes, you are right.
But I cannot share resources or services over the company network.
I'm stuck in this dilemma.

Bugga. If it were me, I'd probably get one of those cheap hosting packages with MySQL and use my own server.

Have you considered Access' inbuilt encryption?

inbuilt encryption? What is that?

Have a look in Tools - Security. Have a read up on Encrypt/Decrypt Database and see if it might help you.

But the table contents is read-able by any user that has the "password" of the database.

I want to make the data on the tables not read-able to all the users (just me).