asked on

.Net Database files, can they be locked?

I have just started learning on my own, about ASP .NET and VB .NET databases.

I am wondering if the database itself could be somehow locked on the server?

For example if a remote user tried to access the database files itself, is there a password or something that can be setup.

Can this password be bypassed if they are accessing directly?

What is the password to the database is lost, is all the data lost?

polkadot

ASKER

Also, what are good resources online or text book, that I can read to learn more about the questions I'm asking.

Scott McDaniel (EE MVE )

Are you using an Access database? There are no ".NET databases", but instead your .NET program would connect to an external database.

If you're using an Access db, then you can set a Database Password. Using Access, open the database and click Tools - Security - Database Password.

polkadot

ASKER

I'm not really sure what kind of database, but I guess I'm thinking of whatever is standard to be used in a C# .NET application on a SQL Server

Scott McDaniel (EE MVE )

First order of business would be to determine exactly what type of database you're dealing with.

SQL Server is a database engine, and that's typically the default db used with .NET apps ... if that's the case, then unless your user has a username/password to the DB server they can't get to it.

polkadot

ASKER

So the server is password protected, but not the database itself?

Is there a way to password protect just the database, not the server?

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial