You should look at PocketAccess.
Bob
Is it possible to have a 2mb database on a handheld and be able to sinq with MSaccess to my desk computer?
![]() | Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years. Thanks, CNET Support |
Is it possible to have a 2mb database on a handheld and be able to sinq with MSaccess to my desk computer?
Discussion is locked
I am in the process of converting a 266,000 kb Access Data Base to my IPAQ 1945 with 52 k of available memory. The problem Active Sync has is that it can only handle a little over 60,000 records at a time, so I have to break up the data base tables to ensure none are over the legal limit as to the number of records. I am storing the converted pocket access db files on a 1G SD card. If you are running Windows Pocket PC 2003, there is no pocket access data base program. You will have to find a third party data base that can handle the amount of data you want to use. Read the specifications of the program very carefully. I bought Pocket Database and found out that you had to have embedded visual basic installed in order for it to run. Pocket PC 2003 uses .NET not visual basic and Microsoft does not support VB for 2003 and later. I downloaded the VB Basic file and a VB fix from the data base company's website, but the program still wouldn't recognize that VB was installed. I downloaded the VB file from microsoft, but it didn't have a setup program. I used the setup program from the DB company's VB download, modified names in the setup config file and finally got the right version of VB installed so everything would run. Just took over 3 days.
1. I still use VB6 to access Access on the PC.
http://www.devbuzz.com/content/zinc_eVB_copy_files_to_device_II_pg1.asp has some code for you to work with.
2. http://www.cewindows.net/faqs/PocketOfficeFeatures.htm notes where you might find Pocket Access. It's sad that it didn't stay in newer versions.
3. http://www.kaione.com/ supports Pocket Access files. And more.
Bob