|
Why am I getting an error message
when I try to connect to my database?
Here are a couple of things you should check if you find
yourself in this situation: First, you should make sure that
your ODBC connection is pointing to the correct location where
your data source is stored. Make sure that no one has changed
the directory where this file is stored. If your data source
is an Excel spreadsheet, you should run the ScanSeek Analyzer
add-in on it again, if you haven't already done so, to confirm
that your spreadsheet is properly formatted to be downloaded
onto your handheld.If your data source is an Access database,
you should make sure that you have used the appropriate naming
conventions associated with databases. You should avoid using
spaces, hyphens, forward or back slashes, "#", "&", etc. when
you name your tables or fields.
^ Back to Top
I am using an Access database
as my data source. How do I configure the database so that
all data I collect using the handheld posts back to the database?
Check to make sure any of your database fields that are not
required (NOT a key field), have the "Allow Zero Length" property
set to "yes." To check this, switch to Design View in your
database and make sure that the "Allow Zero Length" option,
on the General Tab is set to "yes." By default, Access sets
this value to "No" so you will have to manually change this
for the majority of your fields.
^ Back to Top
How do I configure my Excel spreadsheet
to properly work with ScanSeek?
If you use a Microsoft Excel spreadsheet as your datasource,
there are a couple of things that you need to check: First,
make sure that you have run the ScanSeek Analyzer add-in.
Second, check to see that your "named ranges" include all
of the data that your want to download to your handheld. If
the range does not include all of the data, you need to re-define
it. To do so, go to Insert>Name>Define and change the selection
to include all of your data. Finally, it is a good idea to
keep the spreadsheet closed when you HotSync.
^ Back to Top
|
