|
You can use SQL Express, its free and much better than Access.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I second that. There are times I wish Access would be a legacy product...
|
|
|
|
|
Mika Wendelius wrote: There are times I wish Access would be a legacy product...
Same here, and I am sure eventually (hopefully soon), it will truly be a legacy system people will steer away from 
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
That is how I regard it these days.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I agree.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Better in what sense?
For developers/programmers SQL Server is, more often than not, a better solution.
For someone like the secretary to the local cricket (or baseball) club Access is a good solution. It's completely self-contained i.e provides forms, reports, easy set up of tables and relationships and you don't need to develop a WinForms front-end.
What more could you want if you are not a developer?
I once heard a developer loudly pontificating on databases to the effect that if it isn't Oracle it's not a real database. Can you imagine a local club investing in Oracle to keep member details for a couple of hundred people?
|
|
|
|
|
riced wrote: For developers/programmers
Thats the sort of people who are probably using this forum.
I agree, its horses for courses and Access is ideal for the local cricket club, but in the corporate world it should be regarded as a sub-optimal solution for many reasons.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Yes it is 'horses for courses' but even in the corporate world there's still a role for Access.
I did some work for a Fund Management company in the City where they had an expensive portfolio management and accounting package. Unfortunately it could not generate reports that were suitable for clients. So I got it to dump the appropriate data out to CSV files, imported them into Access and created the reports. I could have done this using VB, and perhaps Chrystal Reports, but Access was the optimal solution in this case.
By the way I wouldn't advocate using Access to run an enterprise, I just think it's something that can be brought into the mix.
|
|
|
|
|
To be honest, a database is no more insecure than text files. I'd ask the teacher first if they have constraints on what they will let you use, otherwise I would consider Access or XML. I would leave out SQL Express only because of deployment issues, having to set up a DB instance on another machine for marking, etc.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
In my VB.net Programme I generate a PDF using crystal report which retrieves data from database containing about 700 to 1000 pages. Each page contain so many amount of fields, so takes 2 or 3 minutes depending upon machine. So I like add a progressBar .But how to develop it. Please anybody me to design he code.
|
|
|
|
|
hi,
you dont need to develop one, it comes in the tool box within vs.
drop the control onto your form as you would for any other control.
here's what i set on the controls properties...
Maximum - The total number of pages you have.
Minimum - should be zero
use the step property to increment the progress bar until it the output...
alt,
you can set the pbar as a marquee which runs continuosly until you stop/hide it...
hope this helps
Anoop
|
|
|
|
|
The only progress bar you can use to do this is one that doesn't progress. I mean you can show one that constantly scrolls.
You cannot use a 0 to 100% progress bar because Crystal Reports, last I checked, does not expose any progress information. So, there's no way of knowing how far along it's gotten.
|
|
|
|
|
|
Dave Kreskowiak wrote: there's no way of knowing how far along it's gotten
if you were to know the final file size (say from an earlier run), and you are willing to use some native code to get to the current size of a file while it is being written, you could come up with a reasonable progress indication, at least something better than an "I'm at it" or "lets pretend I'm at it".
|
|
|
|
|
That's such a ghetto solution! I like it! 
|
|
|
|
|
just a quick question how do i measure the level of the line in jack of my sound card ? ie the signal level coming in .
what i want to achieve is to triger an recording event once music is present on the line in jack.
im guessing im going to have to use a reference dll ect .
has anyone atempted this or could provide a simple example .
cheers
luke
|
|
|
|
|
A quick Google for "VB.NET microphone level" reveals these[^] possibilities.
|
|
|
|
|
Hi
I want to get an item from listitem containing some particular text. Using "FindItemWithText" we can do but, this will get all the items that contains the particular text. But I want exact search.
For ex:
The following are the items in listitem:
201, 100, 2, 150
When I search for item "2", I am getting 201 with "FindItemWithText" as 201 contains 2. How can I get the Item "2"?
Thanks in advance,
AR Reddy
|
|
|
|
|
Well, there's no exact match function, so, you can still use that search to return a smaller result set, then do your own string comparison, item-by-item, to find the one that matched exactly.
Or, skip searching the ListView and just search the underlying dataset that you used to populate the ListView yourself.
|
|
|
|
|
You can add an 'object' to the listview (as well as the combobox). Therefore you can add a key/item pair to the the listview and get the value based on the key. You have to cast the listview.currentitem to the object type (IE: keyvalue pair).
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
--> how to communicate with oracle form through dotnet at runtime..?
OR
--> how to pass data from dotnet form to oracle form at runtime..?
--> NO DATABASE INVOLVED....
J A Nasir K
|
|
|
|
|
Jamal Abdul Nasir wrote: NO DATABASE INVOLVED
Oracle IS a database. Use ADO.NET.
|
|
|
|
|
--> but i want to communicate with oracle form through dotnet form at runtime.
--> its a direct communication, form-to-form....
--> any clue, any book, any article....
J A Nasir K
|
|
|
|
|
I doubt very much that it is possible, unless oracle forms have changed significantly int eh last few years. Have you tried any oracle forums?
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Like Ashfield said, you could try Oracle forums. Also there's a difference if the product is Oracle Forms (PL/SQL based) or Oracle JDeveloper (Java based).
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
