Click here to Skip to main content
15,919,132 members
Home / Discussions / Database
   

Database

 
QuestionSQL Update problem I'm still having. Pin
PyroManiak23-Jun-06 8:59
PyroManiak23-Jun-06 8:59 
QuestionRe: SQL Update problem I'm still having. Pin
Alexander Wiseman23-Jun-06 9:15
Alexander Wiseman23-Jun-06 9:15 
AnswerRe: SQL Update problem I'm still having. Pin
PyroManiak23-Jun-06 9:53
PyroManiak23-Jun-06 9:53 
GeneralRe: SQL Update problem I'm still having. Pin
Alexander Wiseman23-Jun-06 10:59
Alexander Wiseman23-Jun-06 10:59 
GeneralRe: SQL Update problem I'm still having. Pin
PyroManiak23-Jun-06 12:35
PyroManiak23-Jun-06 12:35 
GeneralRe: SQL Update problem I'm still having. Pin
Alexander Wiseman23-Jun-06 13:20
Alexander Wiseman23-Jun-06 13:20 
Questiondatabase newbie; what do i need in order to accomplish the following simple application Pin
katsolimon23-Jun-06 6:19
katsolimon23-Jun-06 6:19 
AnswerRe: database newbie; what do i need in order to accomplish the following simple application Pin
Kschuler23-Jun-06 9:22
Kschuler23-Jun-06 9:22 
I suppose if you wanted to store this information in text files instead of a database you COULD...it is just easier to use a database, especially if you have large amounts of data and several tables.... I think nowadays it will be a lot harder to find help if you go with textfile way.

About the type of database...I recently wrote a VB.Net windows PC project using an SQL Express database. It required a very hefty bootstrap that users needed to install. So midway through we switched to use an Access database. Access runs on the Jet platform, which is standard in windows. We just had to make sure that they had Microsoft Data Access Controls (MDAC) installed and that was a considerably smaller install. Access has less capabilities than SQL Express, but the project was small so it didn't effect anything.

About distribution...if I understand your situation correctly you want one central location to store the data but to distribute reports or queries on the data to many people. It kind of sounds like your perfect solution would be to make a website that displays the data. That way users would be able to access the most current information at any time and you only have to update the data in one place...no worries about people viewing out of date information.

Assuming that you haven't done any programming, you may be interested in trying the free version of Visual Studio 2005 for people who program as a hobby.

If all of this is too much and you don't want to write a website/program, it almost sounds like you could do all of this in an Access Database or if you don't mind it being a little crude...in an Excel spreadsheet. Excel has the ability to add VB code by record macros. Here is a site I found that goes in depth on the subject:
http://www.office-addins.com/-excel-addins/microsoft-excel-visual-basic-macros-made-easy-1.html[^]

Not sure exactly what you were looking for, but hopefully this will give you some more ideas to explore. Good luck.
GeneralRe: database newbie; what do i need in order to accomplish the following simple application Pin
katsolimon23-Jun-06 11:21
katsolimon23-Jun-06 11:21 
QuestionAlter column? Pin
Kschuler23-Jun-06 6:16
Kschuler23-Jun-06 6:16 
AnswerRe: Alter column? Pin
Eric Dahlvang23-Jun-06 6:26
Eric Dahlvang23-Jun-06 6:26 
GeneralRe: Alter column? Pin
Kschuler23-Jun-06 8:57
Kschuler23-Jun-06 8:57 
Questionnot sure of advantages of functions over stored procedures Pin
sishya23-Jun-06 2:33
sishya23-Jun-06 2:33 
AnswerRe: not sure of advantages of functions over stored procedures Pin
J4amieC23-Jun-06 3:11
J4amieC23-Jun-06 3:11 
GeneralRe: not sure of advantages of functions over stored procedures Pin
Colin Angus Mackay23-Jun-06 3:42
Colin Angus Mackay23-Jun-06 3:42 
GeneralRe: not sure of advantages of functions over stored procedures Pin
J4amieC26-Jun-06 2:49
J4amieC26-Jun-06 2:49 
GeneralRe: not sure of advantages of functions over stored procedures Pin
Colin Angus Mackay26-Jun-06 8:25
Colin Angus Mackay26-Jun-06 8:25 
AnswerRe: not sure of advantages of functions over stored procedures Pin
Colin Angus Mackay23-Jun-06 3:48
Colin Angus Mackay23-Jun-06 3:48 
Questionchecking for existence of server and SQL instance Pin
Talal Sultan23-Jun-06 0:27
Talal Sultan23-Jun-06 0:27 
AnswerRe: checking for existence of server and SQL instance Pin
Colin Angus Mackay23-Jun-06 1:08
Colin Angus Mackay23-Jun-06 1:08 
GeneralRe: checking for existence of server and SQL instance Pin
Talal Sultan23-Jun-06 3:15
Talal Sultan23-Jun-06 3:15 
QuestionUsing Centralized Database MS SQL Server2000 Pin
Varun Arora22-Jun-06 23:20
Varun Arora22-Jun-06 23:20 
AnswerRe: Using Centralized Database MS SQL Server2000 Pin
Colin Angus Mackay23-Jun-06 1:04
Colin Angus Mackay23-Jun-06 1:04 
Questiondata from database Pin
rcshek22-Jun-06 15:12
rcshek22-Jun-06 15:12 
AnswerRe: data from database Pin
VK-Cadec23-Jun-06 8:25
VK-Cadec23-Jun-06 8:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.