Re: Updating a CDB File

Been there, done that, got the teeshirt. It looks like an attractive way to
deploy an Access database on a Pocket PC, but as you have just found out, it
does not actually work.

"E.D." <ED@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3EAE86D2-BA3E-4040-B59A-209F7E651F16@xxxxxxxxxxxxxxxx
> I'm writing an application that reads a file-mounted CDB database and lets
> the user update the data. Here's what's happening:
>
> 1. I import the .mdb file and check the synchronize box
> 2. I run my application and add a record
> 3. I synchronize my device
> 4. I open the .mdb file on my desktop, and the new record is there
> 5. I run my application again and add another record
> 6. I synchronize
> 7. I open the .mdb file on my desktop again, but the new record is NOT
> there
>
> This is absolutely repeatable, it happens every time. Adding a record
> works
> the first time, but not after that. I don't get any error messages or
> warnings of any kind. I can synchronize as many times as I want, but no
> matter what, the new record doesn't appear. When I look at the <dbname> CE
> sync.mdb file, the time stamp is getting updated, but adosync.txt file
> says:
>
> Changes to the Device Changes to the host computer
>
> Table Name Ins Upd Del Ins Upd Del Conflict
> table-name 0 0 0 0 0 0 0
>
> It's like the synchronization code just doesn't see the changes made on
> the
> handheld. But when I run my app, the new data is still there.
>
> I read this article:
>
> http://www.devbuzz.com/content/zinc_db_force_commit_pg2.asp
>
> and tried adding CeFlushDBVol in different places in my code, but no
> matter
> what, the same behavior happens. I think it must be something I am doing
> wrong in my code, but I can't figure out what it is. My application does
> this:
>
> - CeMountDBVol to mount the CDB file
> - CeOpenDatabaseEx2 to open the desired table
> - CeWriteRecordProps to add new records
> - CloseHandle to close the table
> - CeFlushDBVol to flush the updated data to the CDB file
> - CeUnmountDBVol to unmount the volume
>
> Do you have any ideas what I could be doing wrong? Is there some other
> cleanup step I need to do after adding records or when I'm exiting my
> application?
>
> In case it matters, I'm using a PPC 2003 device and have Microsoft Access
> 2000. Thanks in advance for any help you can give me.
>
> E.D.


.

Relevant Pages

  • Updating a CDB File
    ... I'm writing an application that reads a file-mounted CDB database and lets ... I import the .mdb file and check the synchronize box ... I open the .mdb file on my desktop, and the new record is there ... and tried adding CeFlushDBVol in different places in my code, ...
    (microsoft.public.windowsce.embedded.vc)
  • Updating a CDB File
    ... I'm writing an application that reads a file-mounted CDB database and lets ... I import the .mdb file and check the synchronize box ... I open the .mdb file on my desktop, and the new record is there ... and tried adding CeFlushDBVol in different places in my code, ...
    (microsoft.public.pocketpc.developer)
  • Re: Desktop Access database
    ... I am running Access 2000 on XP on my ... > I have an Access database on the desktop computer. ... synchronize the ... > data from this database with a Pocket PC. ...
    (microsoft.public.pocketpc.developer)
  • Re: Multiple PPC Syncs
    ... the host database is an Access database. ... >PPC that I'm using for testing only shows up in Windows ... For Access, go to Tools -> Options in ActiveSync, enable Access sync, ... You can only synchronize one Pocket PC at a time with ActiveSync. ...
    (microsoft.public.pocketpc.activesync)
  • Re: Navigation buttons
    ... is a small Access database ... MS Access MVP ... Access Database Samples: www.rogersaccesslibrary.com ... there a way to synchronize my own buttons with the integrated ones, ...
    (microsoft.public.access.modulesdaovba)
Loading