Solved

Windows Mobile 6, VS 2008 and MS Access 2010

Posted on 2011-09-20
18
291 Views
Last Modified: 2013-12-27
We have an Access 2010 database inventory system. We need to build an app for a Motorola smart device (scanner) that the users can take offsite to use at other locations.

We would like to download a subset of the Access database data to the smart device and use it as data for an app running on Windows Mobile 6. Users will then take the smart device to other remote sites and scan or data entry. When they return to the main office, the data needs to be uploaded and re-synched to the Access database.

I spent hours today figuring out that Visual Studio 2010 doesn't support development for Windows Mobile 6.0. In fact, two Microsoft customer support staff told me it would until I proved them wrong.

From what I understand (please correct if wrong), you cannot run Access 2010 on Windows Mobile 6.

Would you recommend building an app using Visual Studio 2008 to download to the smart device?

What format would the data need to be on the smart device such that it can be downloaded from Access, used by Mobile 6 and resynched with Access 2010?

I would prefer a web-based system but we're concerned about performance (data entry speed) and if some remote locations don't have good internet connection.

Any suggestions are much appreciated.

Thanks
0
Comment
Question by:mph23
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 6
  • 2
18 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 125 total points
ID: 36570870
"From what I understand (please correct if wrong), you cannot run Access 2010 on Windows Mobile 6."

You are correct. I believe the Windows Mobile devices include an instance of SQL Server Compact Edition, but could be wrong - but you can always install SSvr CE.

However, you cannot "sync" that database with your Access desktop database. You'd have to either build your own sync utility, or perhaps purchase a utility that could do this for you. I don't know of any, but a quick search shows that such items exist.

Or you could use SQL Server as the backend for you local (i.e. workstation) applications, and you could most likely then take advantage of the replication features of SQL Server.
0
 

Author Comment

by:mph23
ID: 36570997
LSM Consulting: Have you developed any projects using VS 2008 for use on Windows Mobile 6 devices?
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 36571031
ACCESS is not supported on WM since WM5. The only way around it is to make a web service or wcf service to host the Access database and the windows mobile can communicate with the access database. You other alternative is to use SQL mobile.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 85
ID: 36571040
No, I have not.
0
 

Author Comment

by:mph23
ID: 36571054
Ok thanks all. Will look into using SQL Server Compact Edition and SQL Mobile.

Actually wanted some advice on using VS 2008 for Windows Mobile 6 device was a good/painful idea and any other recommendations on 3rd party tools.

Has anyone developed using VS 2008 for Windows Mobile 6 smart devices?

Thanks,
jw
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 36571100
I have developed ALL with all versions. I suggest you move to VS2010 and WP7
0
 

Author Comment

by:mph23
ID: 36581771
I wish!
The motorola es400 unit only comes with Windows mobile 6.

Spent all afternoon yesterday trying to figure out the dev tools. Apparently you need VS 2008 PRO (not standard) for Windows mobile 6. Or VS 2005 Standard.

Is this correct? What's the cheapest way to start developing?

0
 
LVL 48

Expert Comment

by:Mikal613
ID: 36581816
buy VS on ebay
0
 

Author Comment

by:mph23
ID: 36581883
ooh, good tip.  Thanks!
0
 

Author Comment

by:mph23
ID: 36581891
Wow even on ebay VS 2008 Pro is $600.

Will VS 2005 Standard work ok with Windows Mobile 6 dev?
0
 
LVL 48

Assisted Solution

by:Mikal613
Mikal613 earned 375 total points
ID: 36582408
Microsoft Visual Studio 2008 Professional Edition and above or Microsoft Visual Studio 2005, Standard Edition or above (Express Editions are not supported). SP1 recommended.
0
 

Author Comment

by:mph23
ID: 36584686
Thanks!
0
 

Author Comment

by:mph23
ID: 36584697
Mikal613: What do you mean by,
"The only way around it is to make a web service or wcf service to host the Access database and the windows mobile can communicate with the access database. You other alternative is to use SQL mobile."

How do you make a web service (what is wcf?) to host the Access db? How would WM communicate with the db?

Would you first recommend that solution or SQL mobile?
0
 
LVL 48

Assisted Solution

by:Mikal613
Mikal613 earned 375 total points
ID: 36584745
Yes first is SQL mobile because its local to your phone and would not require an internet connection. The second option would be the wcf or web service which would act as a "Wrapper" to the access database and you can used the exposed methods from the services to your device.
0
 

Author Comment

by:mph23
ID: 36592822
Do you use VS2005 to build the wcf/web service wrapper?
0
 
LVL 48

Assisted Solution

by:Mikal613
Mikal613 earned 375 total points
ID: 36594054
you need 2008 and above for the wcf service but you can create web services in any version.
0
 

Author Comment

by:mph23
ID: 36594075
Ok I'll research more on  it. Thanks for the tip!
0
 

Author Closing Comment

by:mph23
ID: 36594081
Thanks everyone!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question