The best way I found to get data from a tinybyte (the table on the PDA) to
an Access table was via an "export" in the ThinkDB Desktop.I tried using
sync but was never really happy about the process. Also, the Desktop does
have some advantages.

As a Scuba diver, I use ThinkDB to track my diving history and when I am the
dive organiser/Marshal have to log who does what in the water when. For this
I have created 3 tinybytes. DiveSheet (Parent table), Divers & DiveSites.
Divers holds details of the people who dive, DiveSites - details and
locations of the places I/we have dived, while DiveSheet holds details of
each persons dive. Normally I can enter the data directly into the PDA, but
if I have a very LARGE group with a large amount of diving activity, then it
is easier and faster to enter the data into the Desktop which can then be
exported to Access and also downloaded to the PDA. I can then run reports
over the access tables for my clubs diving officer and each diver as I like.
I have also set up a number of Access Query's that use the data in all three
tables to create stats on Divers (number of dives, deepest, last etc) which
I then IMPORT back from Access to the Desktop to update my Divers tinybyte
which is then downloaded back to the palm. I also have a similar process for
DiveSites.

I found the simplest way was to create a table in Access and define the
characteristics of the fields exactly the way I wanted them. For example,
its important to define memo fields in the access table if you have them in
the Tinybyte. It also helps if you have the data fields in the Access table
in the same order as the Tinybyte. Finally , it is VERY IMPORTANT to ensure
that you have a "KEY" field defined in the Tinybyte. Believe me, do that
first, every time, it will save you a lot of grief.

However, a couple of words of caution. As far as I was concerned there were
two significant bugs with Desktop revision 2+. The first was with 'memo'
exports. If you have a memo in the tinybyte that is greater than 255
character, the export process truncates this to 255 characters (which when
you have spent a couple of weeks researching a dive site and have a nice
long history put together, only to see most of it vanish the next time you
export to Access is, to say the least, a tad frustrating). This was fixed in
a subsequent release, but another bug that turned up was that links to other
Tinybytes did not resolve.

Normally, on the Desktop or PDA, you see the data from the child Tinybyte
that you have linked too. When you export a Tinybyte via Desktop to Access,
only the 'data' associated with the first link to a child Tinybyte is
displayed. All subsequent links are displayed as a KEY value (i.e. the
reference used to point to the RECORD in the child Tinybyte). This was a
known issue in Desktop 2.1 that was fixed in release 2.5. However, the
Release 2.5 also introduced the text truncation issue, so I am running
Desktop 2.1 as I NEED the full memo fields exported.

The non key data resolution is a pain, but there is however a work around,
in that you can set up a relationship in Access from table to table based on
the KEY values (see told you they were important) OR, more simply, you can
use Access Query's to translate the KEY value to data. This might mean you
need to do a intermediate table translation, but that will depend on your
data and what and how you want to report it.

I have had a very stable process running using this method for about a year
now and it works very well. I am just waiting (and have been since 14th Feb
2002) for the fix to be implemented in Desktop 2.5.

rgds
mark




-----Original Message-----
From: tombalazs [mailto:tombalazs@...]
Sent: 07 November 2002 20:00
To: ThinkDB@yahoogroups.com
Subject: [thinkDB] ThinkDB to Access: How


ThinkDB to Access: How

Hi,

1. Can I export the structure of a ThinkDB database, in a way that
Access will use that to create a database (e.g. Name = text, Date =
date, days left = field - date). So I don't have to manually recreate
the database.

2. Whats the best way to get records from the ThinkDB database to the
Access database

I recently converted a HanDBase database to ThinkDB 2.5. I am
enjoying ThinkDB a lot.

I'm using this database in a private adult education school. The
students have a clear path to follow. I track name, phone, last
project done, days remaining on contract, and how many projects they
would have to do each week to finish on time.

Syncing the ThinkDB and Access Databases would be nice but I don't
have dbSync. So maybe I will just export from the ThinkDB to Access
once a week, so I can get a nice printout for my boss. (I can't find
a good way to print from the ThinkDB Desktop 2.5.)

Now I want to take that ThinkDB database and export that information
into an Access database. I think I

I am using a Palm Vx and a Windows 98 PC.

Webmanoffesto






Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=237459.2482214.3917349.2146399/D=egroupweb/S=17073678
35:HM/A=1267611/R=0/*http://ad.doubleclick.net/jump/N2524.Yahoo/B1071650;sz=
300x250;ord=1036699199650640?>

<http://us.adserver.yahoo.com/l?M=237459.2482214.3917349.2146399/D=egroupmai
l/S=:HM/A=1267611/rand=510733489>

To unsubscribe from this group, send an email to:
ThinkDB-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]