Results 1 to 5 of 5

Thread: Creating databases without DB apps

  1. May 15th, 2006, 04:07 PM #1
    BreadBaker
    BreadBaker is offline

    Thread Starter
    New Member
    Join Date
    May 2006
    Posts
    2

    Creating databases without DB apps

    Yeah, I know, this is a totally n00b question...

    I have learned some VB and a couple other languages in the hopes of turning a current MS Access database into a program that I can sell... it is a niche market that I think I could do quite well in. I have a lot of VBA code in the Access project, and have pretty much got the database design all figured out. What are my first steps towards creating a application I can sell? The cheaper I can sell the application the better, so I certainly can't design it to use SQL Server... and Access may be out for the same reason. This is going to be for non-technical folk who won't be wanting to configure servers on their systems. What are my options?

    -BreadBaker
    Reply With Quote Reply With Quote
  2. May 15th, 2006, 04:11 PM #2
    sevenhalo
    sevenhalo is offline
    Banned
    Join Date
    Nov 2005
    Posts
    2,367

    Re: Creating databases without DB apps

    Welcome to VBF

    Well, XML sounds like it would be the best for you. But it all depends on how sensitive the data is and how much you're going to store. You'd still want to look into an obfuscator or something regardless, but... Atleast you'd be completely self suficient when it comes to your information.
    Reply With Quote Reply With Quote
  3. May 15th, 2006, 04:19 PM #3
    BreadBaker
    BreadBaker is offline

    Thread Starter
    New Member
    Join Date
    May 2006
    Posts
    2

    Re: Creating databases without DB apps

    As usual... searches are fruitless until just after I post a question! I think that this thread probably tells me what I need to know. I can go ahead and use an Access backend as long as I write my own GUI. Time to go read up on ADO...
    Reply With Quote Reply With Quote
  4. May 15th, 2006, 10:33 PM #4
    eimroda
    eimroda is offline
    Fanatic Member eimroda's Avatar
    Join Date
    Jul 2000
    Location
    Philippines
    Posts
    642

    Re: Creating databases without DB apps

    SQL Server 2005 Express Edition is FREE. Access databases are also free to distribute, but i would still recommend SQL Server Express...
    On Error GoTo Hell

    Hell:
    Kill Me


    Food For Thought:

    - Do not judge a book... if you're not a judge!

    Reply With Quote Reply With Quote
  6. May 15th, 2006, 11:19 PM #5
    Al42
    Al42 is offline
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: Creating databases without DB apps

    Keep the application in the Access db. The user doesn't need to have Access installed for your app to access the database.

    Look for tutorials on ADO (here on vbforums), and a post of mine on 5/14 or 5/15 with a link to planetsourcecode to see how you can have your app create a blank database the first time it runs.
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.
    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.
    Please Help Us To Save Ana
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width