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

-- 
- Frank Schönheit, Software Engineer         [EMAIL PROTECTED] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to