|
Hi
As i was preparing to deliver my first software (VB.NET 2.0/Access 2003) I noticed the folder containing the database is published separately from the set up file. i browsed it and realised all i needed to do was remove the .deploy extension added by vb to the database file and, voila, i had the access database visible and opening like it was not even part of the software.
My assumption was that it should be locked inside the software set-up, which is not. Does anyone know how to hide the database so that users cannot just find it and open it? How come i have never see the database that runs Ms Word, for example?
|
|
|
|
|
cyberexel wrote: As i was preparing to deliver my first software (VB.NET 2.0/Access 2003
Which version of VB.NET?? I'm assuming you're talking about .NET 2.0.
cyberexel wrote: My assumption was that it should be locked inside the software set-up
Wrong. Access is a file-based desktop database.
cyberexel wrote: Does anyone know how to hide the database so that users cannot just find it and open it?
Impossible. Since it's always a file, and users have the ability to show hidden files, you can't really hide it at all. The best you can do is password protect it, but then there's always the utilities sprinkled throughout the web that will break that.
cyberexel wrote: How come i have never see the database that runs Ms Word, for example
Because there's no database that runs Word?
|
|
|
|
|
Thanks so much, Dave. Your straight answer really saved me time searching for things that are (almost) not published, yet!
If you could:
1.Is it possible to use Access 2007 and have vs 2005 'see it' as a datafile? ie when i published my application with accdb database vs did not put it in the bin directory even if i manually put it there. also when i checked in the application files in project properties it is not listed as a datafile as i expected/thought. which means set up will not find it and connection strings are lost on installation.
2.I opted for Access 2007 because some searches indicated that it is nearly unbreakable. How true is that, and would you recommend me on vs 2005 & Access 2007; or vs 2010 and Access 2007? I haven't yet bought vs 2010 and it is quite expensive!
3. mine is a small application that i want to give to 100 users. i want to save them process of installing sql express (the reason for access 2003/7 instead of sql 2005 express). am i thinking right? if I attach sql express database as file (ie to avoid use of servers), will i have a way of protecting the database when installed on users computers?
4. i see software like firefox come in 'one file', not several files as mine does when published. How is this achieved? Is it possible with my vb 2005 (access or sql) applications?
thanks.
|
|
|
|
|
You seem to be under the impression that all applications require databases, and this is not the case. Take Word for instance - files are saved out as Compound OLE Documents; no database in sight.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
cyberexel wrote: 1.Is it possible to use Access 2007 and have vs 2005 'see it' as a datafile?
The version of Access doesn't matter. A database file is still going to be a database file, independant of Visual Studio. Your code uses it the same way, no matter which version of VB.NET or Access you use.
cyberexel wrote: vs did not put it in the bin directory even if i manually put it there
That depends on how your code is written, specifically, the connection string. Since you're a beginner, I'm assuming you're using the designers for everything database related. If you're using ClickOnce deployment, your database will go into a different folder, seperate from the application, usually referred to as the |DataDirectory| folder.
cyberexel wrote: 2.I opted for Access 2007 because some searches indicated that it is nearly unbreakable.
Only for a short time. Any password can be broken, it's simply takes time.
cyberexel wrote: would you recommend me on vs 2005 & Access 2007; or vs 2010 and Access 2007?
The version of Visual Studio doesn't matter.
cyberexel wrote: 3. mine is a small application that i want to give to 100 users. i want to save them process of installing sql express (the reason for access 2003/7 instead of sql 2005 express). am i thinking right?
I don't use Access for anything any more. For a desktop database, I always use SQL Server Express. Access has too many limitations and quirks for my taste and doesn't support stored procedures or a full SQL implementation.
cyberexel wrote: will i have a way of protecting the database when installed on users computers?
You have no way of totally protecting any database. It's simply too expensive to take all the precautions of trying to protect users from themselves. If they want to get into the database and screw with stuff, they're going to get into it. When did you become their parent??
cyberexel wrote: 4. i see software like firefox come in 'one file', not several files as mine does when published. How is this achieved? Is it possible with my vb 2005 (access or sql) applications?
FireFox is a web browser, not a database, nor does it use one. Your app uses a database, which has to be stored in a seperate file from the .EXE. Not all applications use a database, which is what I think your misconception is.
|
|
|
|
|
Thanks a lot! I have learnt a lot from you. I really appreciate.
|
|
|
|
|
can any body plz send combox selected index changed code
|
|
|
|
|
void comboBox_SelectedIndexChanged(object sender, EventArgs e)
{
}
comboBox.SelectedIndexChanged += comboBox_SelectedIndexChanged;
DaveIf this helped, please vote & accept answer!
Binging is like googling, it just feels dirtier. (Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
|
|
|
|
|
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
'What You Want To Do
End Sub
|
|
|
|
|
thanks for your reply pranav.
i done this in web application it works fine but it is not worinking in windows application
|
|
|
|
|
Try the SelectionChangeCommitted Event or SelectedValueChanged Event
|
|
|
|
|
Don't report the same question. Edit your original if necessary. Delete the previous post
And, do not ask for code.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
mark, thank you very much for your suggetion,
i always wellcome to listen my mistake.
|
|
|
|
|
 i worked on web page selected indexchanged in asp.net it works fine
but when it comes to windows app it is not working.
can any body plz explain the code of combobox selected indexchanged.
prashanth
|
|
|
|
|
From my knowledge CLR is a set of DLLs. In which language CLR is Written?
My small attempt...
|
|
|
|
|
|
Jinal Desai - LIVE wrote: It is made from set of DLLs (Assemblies).
Have you even read some of the information you have posted links to?
You claim that CLR is set of assemblies, which is completely wrong.
There's significant difference between assembly and dll.Each dll is not assembly and each assembly is not a dll.One of the links you posted claims that CLR is an equivalent of JVM.Are java frameworks part of JVM?When we are talking about CLR we mean MS runtime for running managed code, we don't mean mscorlib and the other assemblies.
Life is a stage and we are all actors!
|
|
|
|
|
|
|
|
Hi,
1.
my general advice is not to create that much code all at once; in a board application, I always start by filling a huge rectangle with a distinct color (e.g. Aqua), to make sure my events got wired correctly, and something shows. Then I reduce the rectangle to normal sizes, hoping to still see it; and only then I add all the tiny details of the drawing.
2.
Often I also implement a debug mode in which all drawable items get a different color, so one can easily see and identify them, with their boundaries and overlaps.
3.
Having said that, the most suspicious line IMO is here:
Me.boardgame.Width = face(0).X + margin
4.
You described your app as having two pictureboxes, however that does not really show. Your boardgame and menubar Controls could be most anything, in my books they probably would be Panels, as Panle is my preferred canvas provider.
Hope this helps.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read formatted code with indentation, so please use PRE tags for code snippets.
I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).
|
|
|
|
|
hey,
I want to connect to SQL Server 2005 using the ASPNET account in my application. I have created a password for the ASPNET account through control panel and the account is also configured in the SQL Server login.
The connection string i'm using
DATA SOURCE=xxxxx;User ID=sysname\ASPNET;PASSWORD=winter22;INITIAL CATALOG=databasename.
when i use this code i'm getting "login failed for the user 'sysname\ASPNET'" error.
I'm i using the correct syntax,
Please help
Thanks in advance
D.Vinoth
|
|
|
|
|
By seeing at your error it seems that
for your sysname\ASPNET account you did not
provide sql server authentication.
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
thanks for your reply Jinal,
actually when you see the properties for the sysname\ASPNET login in Management studio, the windows authentication and SQL server authentication where disabled.
do you know how to provide SQL Server authentication for the Login.
Thanks,
D.Vinoth
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
