Results 1 to 7 of 7

Thread: Error trying to insert data to DB

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2005
    Posts
    10

    Exclamation Error trying to insert data to DB

    I application is using MS ACCESS 2007 for the database, and when I start the application from Visual Studio 2008 it works fine.

    After I create the setup file, and install the application and start the application from the setup file, it works fine too, and if I exit the application and go to start and click on the icon any time that the application Insert, delete or update to the DB it gives an error message.

    Here is my connection string.

    Code:
    OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Application.StartupPath & "\db1.accdb; Jet OLEDB:Database Password=ghhv;")
    The strange think is that after the setup is done and I start the application from the setup it works, and if I go to the start and click on the icon it doesn't.

    Any ideas.


    I attached the error msg.
    Attached Images Attached Images  

  2. #2

    Thread Starter
    New Member
    Join Date
    May 2005
    Posts
    10

    Re: Error trying to insert data to DB

    I don't know if it helps but I'm using Windows Vista

  3. #3
    Addicted Member
    Join Date
    Feb 2008
    Location
    California
    Posts
    151

    Re: Error trying to insert data to DB

    Have a look at this link


    http://support.microsoft.com/kb/830977

  4. #4

    Thread Starter
    New Member
    Join Date
    May 2005
    Posts
    10

    Re: Error trying to insert data to DB

    I saw that but in developing a windows application using windows forms.

    I also have all the permission on my access db



    The strange think is that my applicatoin works on VS2008 and as soon as I finish the setup for the application but not when I click on the icon to initiale the application.

  5. #5
    Addicted Member
    Join Date
    Feb 2008
    Location
    California
    Posts
    151

    Re: Error trying to insert data to DB

    Are you running setup on the same development computer?

  6. #6

    Thread Starter
    New Member
    Join Date
    May 2005
    Posts
    10

    Re: Error trying to insert data to DB

    yes, it's on the same computer

    To create the setup I'm using Inno Setup 5.

    I guess maybe the Inno Setup is making the files wrong, because I just rebuilt the application, and just ran the .exe file, and it works.

  7. #7

    Thread Starter
    New Member
    Join Date
    May 2005
    Posts
    10

    Re: Error trying to insert data to DB

    Well I used the setup from VS2008 and it works fine.

    Thank you for your help. I guess Inno Setup was doing something wrong.

Posting Permissions

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



Click Here to Expand Forum to Full Width