Re: Sql Server Compact Edition - Lost Data

It's simply copying your .sdf file to the output directory when you run the app from within the IDE. So, check the file output options for your database ".sdf" file. The changes aren't getting deleted by themselves. You are just creating a new database from the old one everytime your run the app. The database that is changed while your app is running is not the one you think it is. Hope this makes sense.

Thanks,

Vince

<mjhillman@xxxxxxx> wrote in message news:1171464462.706030.128250@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
While using this database to write a simple application using Visual
Studio (VB.Net) I have lost records from the database on several
occassions. Most recently this happed while executing local reports.
Has anyone else experienced this problem?

The records were present when I closed the application but after
restarting the application the records were gone. When the
application starts, the database is read and a tree menu is
populated. Only read functions are performed.

Thanks.
Mike


.

Relevant Pages

  • Re: Sqlserverce class not working when VB.Net application is running from network drive
    ... one app attempts to connect to a sdf file on a network share, ... possible that the database is already in use when you attempt to ...
    (microsoft.public.sqlserver.ce)
  • Re: Sql Server Compact Edition - Lost Data
    ... check the file output options for your database ".sdf" file. ... You are just creating a new database from the old one everytime your run the app. ...
    (microsoft.public.sqlserver.ce)
  • Re: Portable Database Choice
    ... I searched this group quite a bit looking for database alternatives and did find the options below from this search. ... I'm posting this in the hope it can be of use to other developers in a position similar to mine where I needed a low cost alternative to Pocket Access. ... One app requires synchronization between desktop and mobile device, the other requires a push of data from the desktop to mobile. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Portable Database Choice
    ... > database alternatives and did find the options below from this search. ... One app requires ... > push of data from the desktop to mobile. ... > Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Portable Database Choice
    ... database alternatives and did find the options below from this search. ... of data from the desktop to mobile. ... The read-only app requires speedy lookup of data in a flat table ... Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
Loading