Pocket PC

[misslee1888]

I have recently bought a pocket PC and have an access database which I would want available from the pocket PC. I know that I can syncronise the tables in my database, however all of my forms and VB code will become unusable. Is there anyway in which I can get my current forms and my VB code operational from my pocket PC.

All advice much appreciates.

 

[Kevin_S]

I have recently bought a pocket PC and have an access database which I would want available from the pocket PC. I know that I can syncronise the tables in my database, however all of my forms and VB code will become unusable. Is there anyway in which I can get my current forms and my VB code operational from my pocket PC.

All advice much appreciates.

what version of pocket pc? versions 2002 and 2003 no longer support pocket access...? Are you running some version of a 3rd party software?

Kev

 

[misslee1888]

I don't have any access programs installed I am not sure how to do this. However I would be looking for something which would allow me to use the forms on my database, all of the apps I have seen so far only allow you to use the tables from the databases and not the forms. Most of the functionality on my database comes from VB code on the forms, and this will be lost.

 

[Kevin_S]

misslee -

sorry to have to tell you this but there is no way to migrate Access forms and VBA to the Pocket PC in an app (unless perhaps you are running an early version of Pocket PC that supports Access as the last two releases do not). What you will have to do is either rewrite the forms in something like VB.NET and use on the device or use a third-party RAD software product (something like Pendragon forms) to do development for the Pocket PC and sync with your db on the desktop or server...

HTH,
Kev

 

[misslee1888]

How can I use pocket SQL server to do what I want. What would I use to create the forms and how easy would it be to develop this using pocket SQL.

What do you suggest?

 

[Kevin_S]

How can I use pocket SQL server to do what I want. What would I use to create the forms and how easy would it be to develop this using pocket SQL.

What do you suggest?

Pocket SQL (SQLCE) is a fairly complicated application - depending on your experience level you may wish to go with something more canned, RAD tool like Pendragon forms or HandiBase... also - to use SQLCE you will need a license of SQL Server 2000 Developer Edition or VS.NET 2003.

If you have these tools above you can create a replica of your db on the CE device from the db schema on your development pc/server. To create the forms you can use Vb/VB/NET or C/C#/C++ to interface with the db in SQLCE on the device (Note* if you use any of the .NET software (i.e. VB.NET or C#.NET) you'll need to also install the .NET compact framework on the device)

This setup would be the most flexible and robust but also fairly complicated and may require some coding specific to the CE device to be learned... THis is why something like a canned PDA database software package would probably be the best bet for fast development --- it really all depends on your experience level and your comfort with the software...

HTH,
Kev