I would like to do a switch from Access 7.0 to Delphi 2.0, but
encountered the following problems, while trying to access my Access
*.MDB file with Delphi's BDE:

1) Field names are only allowed to be 31 characters long, otherwise I
get an "Too few paramters - expected 1" ODBC error.

2) Access "Memo" fields (LongVarChar) are only displayed as BLOB objects
in the Data Grid.

( 3) Trying to update fields leads to a "general SQL" error
     [BDE is configured as "read/write" access] )

All these problems cannot be caused by the ODBC driver, because
everything works just fine with "MS Proof" using the same ODBC source.

Since many Access features cannot be exported to other databases
(SQL,..) I cannot easily switch to a different database backend.

I didn't switch from Access 2.0 to Delphi 1.0 for much the same reason,
but I'm sick of developing with Access, so any hints would be greatly
appreciated.

Thanks in advance,
              Markus

Hello,
  Look at alternate BDEs like DirectAccess and TitanAccess.
Iceman

PS.  A couple posts down I give some detailed info.
====

Long field names is a problem.

The memo nightmare is because you have stored you databases in
directories with long file names.  Its a BDE bug I figured out (the hard
way) the other day.  Other symptoms are a two byte truncation of access
memo field data.  Once I moved the files into short directory names the
problems went away.

I'm working on a document that shows how to reproduce these steps that I
will send to Borland.  

Later...
In article <319B48A2.4...@stud2.tuwien.ac.at>,
e8725...@stud2.tuwien.ac.at says...