User Tag List

Thanks useful information Thanks useful information:  0
Results 1 to 13 of 13

Thread: Database software

  1. #1
    Member
    Join Date
    01 Apr 2008
    Location
    Launceston Tasmania
    Posts
    1,172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database software

    Over the last 11 years I have kept up to date an Excel spreadsheet for one of my other hobbies, this started off as a single work book with 100 rows and 2 columns but over the years it has expanded to what is now 4 work books with anything up to 20000 rows and 15 columns each.

    Earlier this year I started programming some software that has this and some other information / programs as a single source of information for other people, this I have put up online for anybody who wishes to use it and I have got some good feedback on it.
    Over the last few months I have not done a lot of work on it but now need to update and refresh the information, add some new features to the software that I built and remove some information that is no longer needed.

    At one stage I was looking at using MS Access to replace the spreadsheet but had some issues with people who have different versions of Office (2000, XP, 2003, 2007)

    What I am looking for is some advice on what the best way is to do this and if anybody knows of some free software that will work without the issues of using Access.

    Paul

  2. #2
    Member
    Join Date
    26 May 2008
    Location
    Launceston
    Posts
    2,012
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use a free converter for word documents, as I only have office 2003, maybe there is one for access as well?
    Cheers, Lani.
    Bodies: Nikon D700, D300 Primes: Nikon 50mm 1.4, 85mm 1.4G, 105mm VR 2.8, 300mm f4. Zooms: Nikon 14-24 2.8, 24-70 2.8, 70-200VR II 2.8, Sigma 10-20mm Processing: Photoshop CS5 extended, LR 3.2.


  3. #3
    Member
    Threadstarter

    Join Date
    01 Apr 2008
    Location
    Launceston Tasmania
    Posts
    1,172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Lani View Post
    I use a free converter for word documents, as I only have office 2003, maybe there is one for access as well?
    Thanks Lani, I have that set up on all the computers here at work but don't know how well it handles databases. I will check that out but would prefer something totally free rather then having to convert it from 2007 all the time.

  4. #4
    It's all about the Light!
    Tech Admin
    Kym's Avatar
    Join Date
    15 Jun 2008
    Location
    Modbury, Adelaide
    Posts
    9,641
    Mentioned
    18 Post(s)
    Tagged
    0 Thread(s)
    Me... I would dump it into a MySQL database.
    Then write some sort of search/edit web form to manipulate the data using PHP.

    You can install all the tech pieces on windoze in one hit using XAMPP http://www.apachefriends.org/en/index.html
    Then if every you needed to you could move it onto the web at any time.

    A single table maintenance etc for a beginner should be less than 40 hours work. (Steal code from the 'net - Google is your friend)
    An experienced PHP/MySQL developer should knock it off in under a day.
    regards, Kym Gallery Honest & Direct Constructive Critique Appreciated! ©
    Digital & film, Bits of glass covering 10mm to 500mm, and other stuff



  5. #5
    Member
    Threadstarter

    Join Date
    01 Apr 2008
    Location
    Launceston Tasmania
    Posts
    1,172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Lani View Post
    I use a free converter for word documents, as I only have office 2003, maybe there is one for access as well?
    I just had a look Lani, does not sound good
    http://office.microsoft.com/en-us/ac...484061033.aspx
    "If you share the database with other users, ensure that those users are all using Office Access 2007 before you convert the database to the Access 2007 file format. You cannot use the Access 2007 file format in earlier versions of Access"

  6. #6
    Member
    Threadstarter

    Join Date
    01 Apr 2008
    Location
    Launceston Tasmania
    Posts
    1,172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Kym View Post
    Me... I would dump it into a MySQL database.
    Then write some sort of search/edit web form to manipulate the data using PHP.

    You can install all the tech pieces on windoze in one hit using XAMPP http://www.apachefriends.org/en/index.html
    Then if every you needed to you could move it onto the web at any time.

    A single table maintenance etc for a beginner should be less than 40 hours work. (Steal code from the 'net - Google is your friend)
    An experienced PHP/MySQL developer should knock it off in under a day.
    Sounds good Kym and what I am looking for. As the people who use this are not very "IT aware" how easy would it be to set it up so they can download and install it themselves?

  7. #7
    It's all about the Light!
    Tech Admin
    Kym's Avatar
    Join Date
    15 Jun 2008
    Location
    Modbury, Adelaide
    Posts
    9,641
    Mentioned
    18 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by pgbphotographytas View Post
    Sounds good Kym and what I am looking for. As the people who use this are not very "IT aware" how easy would it be to set it up so they can download and install it themselves?
    Not.

    What you do is set it up on a server (which could be a desktop) and they all access via a browser.

    If you set it up on a publicly accessible server you will need to secure it as well.

    Maybe I misread what you are trying to do - is this shared data or private?

  8. #8
    Member
    Threadstarter

    Join Date
    01 Apr 2008
    Location
    Launceston Tasmania
    Posts
    1,172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Kym View Post
    Not.

    What you do is set it up on a server (which could be a desktop) and they all access via a browser.

    If you set it up on a publicly accessible server you will need to secure it as well.

    Maybe I misread what you are trying to do - is this shared data or private?
    Sorry Kym, I think it was more I didn't explain it very well rather then you missing reading it

    Basically the data is public and anybody is free to download it and use my program, what I do is every month or so I update all the information in the various Word, Excel, PDF and HTML files, make any updates to the base program that runs them all then make a set up file which I put online for people to download and install.

    The basic requirements for it are:
    Easy to install and set up for the users which I do by having an install file they download and run that copies the files to the right folders and then creates the shortcuts.

    Work as a standalone program without needing to be connected to the internet, it is used by myself and others "in the field" as a reference source and the data only needs to be updated by myself every month or so.

  9. #9
    Member
    Threadstarter

    Join Date
    01 Apr 2008
    Location
    Launceston Tasmania
    Posts
    1,172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  10. #10
    Member
    Join Date
    06 Mar 2008
    Location
    Canberra
    Posts
    338
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    A web based approach (ie. not having to install software on the user's computer) is the best way to avoid compatibility issues.

    I have programmed commercial applications using various software over the years (including MSAccess runtimes) and no matter how hard you try there will be instances of compatibility issues. The most obvious one is operating system (ie. Mac/Windows/Linux etc) and the various versions within. If you go down the path of MSAccess runtime, it's best to package it with your custom requirements in one installer. Back in the old days I used WISE quite a bit, but it's been years since i've done this stuff...

    Not knowing what you're doing exactly, this suggestion may or may not be applicable. You could consider providing the data in a "universal" format like CSV of XML and suggest various tools (eg excel, access, open office...) for users to manipulate it...

  11. #11
    Member colind's Avatar
    Join Date
    04 Aug 2009
    Location
    Brisbane
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I also like what Kym was saying about using MySQL/PHP.
    I think if you have the time and skills to do it, then I think it would be a good option. (Although I'm not totally sure about your requirements)
    You mentioned that the data and program is public, if you point us in the direction of the current set-up someone may be able to suggest something better.
    CC greatly appreciated! Feel free to rework any of my photos but please let me know your secrets when you do.

    Canon 50D | 18-200mm

  12. #12
    Ausphotography Regular
    Join Date
    27 May 2009
    Location
    Northern Beaches - Sydney
    Posts
    774
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi

    I am not an IT professional, but have played around with some programming. I have used Visual Basic (I have VB6) to program a database front end. VB is quite good at this. You can use an Access database (.mdb file) (set it up yourself using Access) then add or display data using your VB application. If it is compiled to an .exe file, your users do not need to have Access to use it. Just distribute your .exe file and update the database when you need to.
    David

    Nikon D810
    Nikkor AF-S 24-120VR, Nikkor AF-S 16-35VR, Nikkor AF-S 70-300VR, Nikkor AF 50 f1.8
    Tamron 90mm Macro

  13. #13
    Member
    Threadstarter

    Join Date
    01 Apr 2008
    Location
    Launceston Tasmania
    Posts
    1,172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by davidd View Post
    Hi

    I am not an IT professional, but have played around with some programming. I have used Visual Basic (I have VB6) to program a database front end. VB is quite good at this. You can use an Access database (.mdb file) (set it up yourself using Access) then add or display data using your VB application. If it is compiled to an .exe file, your users do not need to have Access to use it. Just distribute your .exe file and update the database when you need to.
    This is sounding like a good idea, I am using Just Basic for my program so I will see if I can add that in to read from Access.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •