Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    74

    Unanswered: Standalone MS Access

    Hi guys! Is it posible to use ms access file(mdb) as my database for my application even without ms office installed in my pc? Thanks in advance!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    If you mean that only the data tables are in Access and some other program provides the user interface, then yes. If the user interface is part of the mdb, then no; either the full or runtime version of Access must be installed.
    Paul

  3. #3
    Join Date
    Sep 2008
    Location
    Amherst NY (near Buffalo)
    Posts
    11
    You'll find that a lot of people do this with Visual Basic apps. You can connect a simple VB app to an Access MDB file just to get it's tables. In fact, using DAO (Data Access Objects) you can have your VB app *create* the MDB file on the fly.

    Now - if you're asking whether or not you can distribute your Access database to people who don't have Access, then YES you can, but you'll need either the Access Runtime version (which you can give away royalty free) or you'll need the Access Developer Extensions (you have to pay for these with Access up to 2003, free with 2007).

  4. #4
    Join Date
    Sep 2008
    Posts
    7
    Yes, you can use an Access MDB in your application. There is a well-known way for old VB developers using DAO. You can use the same method in .NET by creating an interop reference. The other way is to use ADOX library.

Posting Permissions

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