asked on

mdb to cdb conversion

I've looked at a couple of posts, but is there a way to convert an mdb to a cdb without having to send it through activesync? I want to do the conversion on the desktop before I move it to my pocket pc device. Is there a way to do this? I've looked high and low and it just keeps coming to a dead end. Is it me or does microsoft just make everything harder than it has to be? Everytime i turn around with this little program I am trying to create I run into a snag. I finally got around all the problems I've run into, now, I'm stuck at this point. Any and all help appreciated. Code, tools, info, anything

Thanks,

Matt

ASKER CERTIFIED SOLUTION

jrb1

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

heydude

ASKER

I had looked at that, but it looks like it is still doing the conversion on the pda. I have a program that creates the mdb on the desktop from a couple of csv files. I want it to be as little hastle as possible getting the database to the pda. Don't want to use sqlce just looking for a simple way to store and retrieve records. Nothing seems simple though. I've tried a couple of different ways and I keep running into problems with relating 2 different tables so access seemed the way to go. I would use xml just not sure how to relate the 2 xml files. I need a way to pull data from a couple of different tables table1 holds name and address table2 holds other data that will change but relates to the first table.

Matt

jrb1

I've not used the cbd very much, so I don't know what all your options are. Does it handle any ODBC? If so, could you read from the DB directly from the PDA through ODBC? (seems like alphabet soup)

heydude

ASKER

I'm going to give you the points for trying to help me out. I think I've figured out a way to do it that will be as easy as possible. I will have to tinker.

Thanks

phmurphy

This may be the answer, I haven't tried it yet but it sound about right.
http://www.fairport.com.au/cesync/