access and blanks

From: Martin Banser (knockin_at_gmx.net)
Date: 11/28/03 

Date: Fri, 28 Nov 2003 17:30:50 +0100

while saving data to an access database via Ado,
i have one problem.

Any String written down to a char-field has
many blank types in the access database.

if i use adoquery1.fieldbyname('lastname').asstring := 'smith'
in the Access Database there is 'smith ' with may clear
types ... maybe the maximum field length is filled.
Does anyone knows, why ???

Martin

Relevant Pages

  • Re: access and blanks
    ... >while saving data to an access database via Ado, ... >Any String written down to a char-field has ... >many blank types in the access database. ... maybe the maximum field length is filled. ...
    (borland.public.delphi.database.ado)
  • Re: How to connect MS ACCESS in Netwaork base VB6.0 Programme from server
    ... Structure you can use to connect to and query an Access Database using ADO. ... How to connect MS ACCESS in Netwaork base VB6.0 Programme from server ... SIDE) AND ATTENDENS STORE OM MS ACCESS DATABASE WHICH IS STORED ON ...
    (microsoft.public.vb.winapi)
  • Re: ADO and Active Server pages on a mac
    ... In otherwords does the Excel object model on a Mac have ADO? ... Here is how to create a connection to a MS Access Database: ... Does ADO only work on Active Server Pages on a PC? ...
    (microsoft.public.mac.office.excel)
  • ADO and Active Server pages on a mac
    ... Can you use ADO object to connect to an Access database from Excel on a Mac ... Does ADO only work on Active Server Pages on a PC? ...
    (microsoft.public.mac.office.excel)
  • Re: Importing data From Word Form to Access
    ... you have DAO and ADO. ... > access database. ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.docmanagement)