How To Secure Access Database

[deepaktheindian]

Hi Guy's,

I need your help, I'm developing an access based tool. I've made some forms which are connected to an access database, forms and database are located on a server seperately. I want to prevent unauthorised access to my database, may be using some login credentials. Is there any way to do it on Microsoft Office 2007 platform.

Thanks

 

[cooh23]

This is probably what you're looking for: Password Login Screen

I hope this gets you started.

 

[deepaktheindian]

Thanks DuDe.. This is exactly the same thing that I's looking for..

 

[dportas]

Hi Guy's,

I need your help, I'm developing an access based tool. I've made some forms which are connected to an access database, forms and database are located on a server seperately. I want to prevent unauthorised access to my database, may be using some login credentials. Is there any way to do it on Microsoft Office 2007 platform.

Thanks

There is no way to secure a Jet/ACE database from someone who has file system access to the MDB / ACCDB file. You could build a login screen but that's really just pretend security for people who don't know any better. So unless you intend to deceive your users it is worse than doing nothing at all.


If security is one of your requirements then you should not be using Jet/ACE - it really is that simple. Upgrade the database to SQL Server or some other client server DBMS.

 

[deepaktheindian]

There is no way to secure a Jet/ACE database from someone who has file system access to the MDB / ACCDB file. You could build a login screen but that's really just pretend security for people who don't know any better. So unless you intend to deceive your users it is worse than doing nothing at all.


If security is one of your requirements then you should not be using Jet/ACE - it really is that simple. Upgrade the database to SQL Server or some other client server DBMS.

Yeah, I know that.. I just wanted to prevent users from editing data.. I could do it by some programming skills..