Add Data from a Palm (Access 97)

Topic

New Reply

I have a database with two tables. I want to be able to record data into a Palm then sync with the Access tables. I have a database of sorts on my palm, but the Access database is too complicated. I’m looking for a good piece of Palm-based software to feed this Access database. I’m posting here since I figured that you folks reading this would likely have done something like this before, and that most of those in the Palm forum wouldn’t track with all the Access stuff. Can you help?

I have a probably typical scenario where for one event there is some data that defines the event ( date, time, employee, etc) and multiple pieces of data that are associated with that event ( test given, results, notes, etc. ). I have one table, tblTestMaster, that has all of the defining data fields and one AutoNumber Key named TestEvent. The second table, tblTests, has the repetative data including the TestEvent number and an AutoNumber field that is the key. I have created a many-to-one relationship between tables on TestEvent where tblTests is the many side. Referential Integrity is enforced. The tblTests is fed by a subform of the main form such that the TestEvent number is fed to tblTests.

Reply | Quote

Replies

(Edited by HansV to remove space from URL and to make it clickable – see Help 19)

Check the HandBase site http://www.ddhsoftware.com/syncexchange_access.html%5B/url%5D. You can download a 30 day trial and see if it helps. I started doing something like this, and it worked OK. However, in the end the client seems to prefer Pocket PC and I am going to use a VB front end on Pocket PC, and forget about Palm

Reply | Quote

This, believe it or not, is just where I started since I had purchased HanDBase for my own uses. The difficulty is that I cannot use the Palm to generate autoID numbers since there would be a chance of duplication. I tried syncing only the remaining fields, but Access chokes on that and generates an error. For what it’s worth the error is from the process hdeaccess.exe. The message says that an error log is being created, but I don’t know where it might be. It doesn’t show up in Event Viewer.

Reply | Quote

Dean

Can you give us an update on your HanDBase application?

Thanks, John

Reply | Quote

Wow, this was from a *very* long time ago.

I never did solve the problem. The powers that be in the company had decided they didn’t want to follow through, so the problem went unsolved.

Reply | Quote

This, believe it or not, is just where I started since I had purchased HanDBase for my own uses. The difficulty is that I cannot use the Palm to generate autoID numbers since there would be a chance of duplication. I tried syncing only the remaining fields, but Access chokes on that and generates an error. For what it’s worth the error is from the process hdeaccess.exe. The message says that an error log is being created, but I don’t know where it might be. It doesn’t show up in Event Viewer.

Reply | Quote

(Edited by HansV to remove space from URL and to make it clickable – see Help 19)

Check the HandBase site http://www.ddhsoftware.com/syncexchange_access.html%5B/url%5D. You can download a 30 day trial and see if it helps. I started doing something like this, and it worked OK. However, in the end the client seems to prefer Pocket PC and I am going to use a VB front end on Pocket PC, and forget about Palm

Reply | Quote