Security with VB.NET Application

[janiali]

Need your Help and Favor .
I have one Vb.NEt Desktop application complete in working unfortunatly Developer Ran Away to other country and now I need to Build Secrtiy in that like there are 9 Different location that Application is installed called (Regions) I want every region to use only data relater to that region . I don't want to go in to every form and do this I need some kind so easy way to implement this kind of security

Please help
I have complete source code and this application is developed useing Visual Studio 2005 .
Just one thing that I am useing online SQL DB with this application

Please Please give me some solution thanks
Jani ali

[Kasracer]

I don't understand. This isn't security but some sort of data seperation. You haven't told us anything about this application (ASP.Net? Windows Forms? WCF? Web Service? Windows Service? Directly connects to SQL? Uses an n-tier design to hide database components?). I have no clue how we could possibly help you...

Is this an already deployed solution?

What you want is a seperation of data. I don't understand why you can't just "develop" it but, instead, need a "solution" from us.

[Shaggy Hiker]

Frankly, I'm having a hard time getting past the part where the developer "ran away to other country." So the developer defected leaving a defective program behind.

I think you will be lucky if there is an easy solution to the problem, but I agree with kasracer that this doesn't sound like a security issue. If the DB was set up right, this seems like it would be covered in the data layer. If the DB isn't set up with some means of distinguishing one region from another, I would guess that there is no solution. But I also agree with kasracer when he says that we are a long ways from having enough information to even make a meaningful suggestion.

Where did the programer run off to? Did he do it out of spite?

[Hack]

Are you afraid the developer that ran off built in some back doors to your application? Is that the necessity for additional security?

[Tom Sawyer]

If the data is by region, then that information should be in the database. I'd suggest putting the region that the user is in in the app.config file and pulling that out in the data access layer in order to only returning the data that is for this region.