Frank Schönheit - Sun Microsystems Germany wrote:
Hello Swarup,
1. I would like to know that if I just simply "connect" to the MDB file
and don't import it, then what sort of functionality is there?
Read/Write data. See MSA's queries as so-called views (i.e. they behave
like tables, but you cannot edit their constituting statement). Don't
see forms/reports/macros.
And then, would I be able to create a query in Base to search the list
for particular data?
Yes.
And if instead I choose "no", then another error message appears: "Wrong
data type: java.lang.NumberFormatException: For input string:
"08/18/2001 12:00:00 AM". In that situation too, the table will appear
with all the proper columns but with no data.
That's somewhat strange. I would guess it seems to depend on your
concrete data. Since no data is copied at all, I would assume there is a
field in your very first row which somehow triggers this problem. If you
have a chance to strip down your MSAccess DB to just this one table with
just this one record, while the bug persists, I would be interested to
have a look at it (provided this is no confidential data, of course).
Ciao
Frank
Since it seems to be having trouble with the date/time field, have you
checked that the destination field type is appropriate? It may be having
trouble recognizing the format. I'm not sure there's an exact equivalent
for the Access form -- in Writer, I see one that has hh:mm:ss but no
AM/PM, and one that has hh:mm am but no seconds. The second form is
available in Base, and when I copied a table with your data into a field
of that type, it came in OK but minus the seconds. There's also an
"OTHER" format, but I haven't looked into that -- maybe you can define
the format you want?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
