MS Access

Discussion in 'Databases' started by zac439, Apr 7, 2007.

  1. #1
    Do you have to have MS Access in order to use a program that uses its database? I am developing a VB.NET application that uses MS Access, and do not wish to only attract users that have the program on their machine.

    Haven't tested it yet, as I am not on a machine with my program on it.
     
    zac439, Apr 7, 2007 IP
  2. Smyrl

    Smyrl Tomato Republic Staff

    Messages:
    13,740
    Likes Received:
    1,702
    Best Answers:
    78
    Trophy Points:
    510
    #2
    Even if you can won't this move require you to tie yourself to Microsoft hosting?

    We did an ecommerce site using StoreFront about seven years ago. As I remember anyone that had StoreFront on their computer could access the database and update it whether they had Access or not.
     
    Smyrl, Apr 7, 2007 IP
  3. zac439

    zac439 Notable Member

    Messages:
    3,074
    Likes Received:
    214
    Best Answers:
    0
    Trophy Points:
    260
    #3
    I am using the local database configuration. No internet connection is involved. It is actually for a login administration system for my program.
     
    zac439, Apr 7, 2007 IP
  4. Smyrl

    Smyrl Tomato Republic Staff

    Messages:
    13,740
    Likes Received:
    1,702
    Best Answers:
    78
    Trophy Points:
    510
    #4
    I bet you can work things out so it will work.
     
    Smyrl, Apr 7, 2007 IP
  5. zac439

    zac439 Notable Member

    Messages:
    3,074
    Likes Received:
    214
    Best Answers:
    0
    Trophy Points:
    260
    #5
    Obviously. The problem is simple- I just need to know if I give the program to someone else who doesn't have MS Access- will it work? Or do they need MS Access to use the database?

    The database program I created uses creating/editing/deleting features, if that changes anything.
     
    zac439, Apr 8, 2007 IP
  6. tandac

    tandac Active Member

    Messages:
    337
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    58
    #6
    You might need to bundle some libraries but distributing the .net app and a .mdb file is all you really need.

    I used to do this many years ago with VB6 and Access.
     
    tandac, Apr 8, 2007 IP
  7. JenniP

    JenniP Peon

    Messages:
    250
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Your users wont need MS Access on their machine, they will however need the MS Access database library.

    Although depending on the version of MS Access database your using you may need to ship the Access database engine with your application, but this is freely distributable.

    Depending on how you distribute your application you may need to package the Access libraries with your app.

    I havent packaged up a windows application in ages but it was never that difficult.

    Jen
     
    JenniP, Apr 8, 2007 IP
  8. zac439

    zac439 Notable Member

    Messages:
    3,074
    Likes Received:
    214
    Best Answers:
    0
    Trophy Points:
    260
    #8
    Thanks for the replies! Helped me out a great deal.
     
    zac439, Apr 9, 2007 IP