Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    USA
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database Executable

    I need to build a database that imports data stored in XML files, allows for user input via forms, and prints reports.

    Ideally I would like to 'compile' the database into an executable file so that the potential users cannot get to the guts of the application and mess things up. Also, I do not know what programs a potential user will have installed on their system.

    I do not particularly want to use Access runtime due to the amount of files that this requires to be installed on the user system, and some conflicts when users already have the full version of Access.

    Does anyone have any suggestions or experience with programs that will accomplish this?

    Thanks,

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database Executable

    I'm sure there's a lot of stuff out there for this. I imagine the best choice for you depends on how much you're willing to spend on both the software and the expertise to develop the required solution. Another big factor may be what programming platform is preferred by your organization.

    If I were the developer, and if your organization supported the .NET platform, I would recommend building a .NET Windows application with SQL Server as the database (assuming you need a central data source). That's just my 2 cents <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>

  3. #3
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,579
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: Database Executable

    Just to add a little to Mark's comment, if you are looking for a single machine application you could use MSDE (SQL Server 2000) or SQL Server Express (SQL Server 2005). Both are freely redistributable and you can configure a SQL Server instance specifically for your app. If you organization is considering SQL Server 2005 and your timetable is somewhat flexible I'd suggest waiting for SQL Server 2005 which is due to be released November 2005.

    Joe
    Joe

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database Executable

    Aside from what the others have said, I want to point out that you will NEVER be able to install a simple executable on a machine and run a database from it alone. All the options, from Access runtime to VB.Net require additional files, whether it's the Access runtime, the VB runtime or the .Net framework. In some cases, the runtime files may already be on the target machine, which makes it appear that you don't need extra files, but that is an illusion.
    Charlotte

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database Executable

    You can also use an access MDE, which is not easily opened to see your code

Posting Permissions

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