Re: ms access quirey question

nialltimpson" <niall_mulhare@xxxxxxxxxxx> wrote:

>Hi I was wondering is it possible to read write to a memo field in ms
>access, the same way you would read write to a text field?
It is.

"Microsoft Access provides two field data types to store data with
text or combinations of text and numbers: Text or Memo.

Use a Text data type to store data such as names, addresses, and any
numbers that do not require calculations, such as phone numbers, part
numbers, or postal codes. A Text field can store up to 255 characters,
but the default field size is 50 characters. To control the maximum
number of characters that can be entered in a Text field, set the
FieldSize property.

Use the Memo data type if you need to store more than 255 characters.
A Memo field can store up to 64,000 characters. If you want to store
formatted text or long documents, you should create an OLE field
instead of a Memo field.
> I have my
>database set up and reading writeing to the databse ok using text field
>but I have to now store strings which will contain 316 characters e.g
>
>1315259804765771089746208008724780151971640940654061
>5945089711350055105440014387233852223755558178959373
>5901729523358226196346901333363266720160161567476750
>8698500810033377223926558621622404221161922571217657
>5908662820038302522362188659394554116014527409368579
>573295108852401025657242056374503972313949815709
>6436944847683848865450458408521580987232589912971236
>713653320010771954202838636539445174893761859498584761
>774348548858284051610193336458404802244737321229315795
>259346400597219730922809042994571064196264789556436973
>256754063980517342616225212190669661339367714653468330
>0777901869239185845560584199360795573155
>
>I need to do it beacuse Im encrypting ever thing in the database,
>
>Thank if you can help
>Niall


Thanks, I think Ill need to be useing the memo or the ole type you
mentioned the only thing is my standard querieys that I was useing tih
text field's are not working, there not throwing an error's but are
simpley not working. do know that could be wrong here's an examp of what I
mean,

con = DriverManager.getConnection(conStr);
Statement stmt = con.createStatement();
ResultSet row = stmt.executeQuery(
"SELECT Username, surname FROM Login");
correctLogin = row.getString("Username");


This along with ,update, insert statements.

Thanks for you help.

.

Relevant Pages

  • Re: ms access quirey question
    ... Use a Text data type to store data such as names, addresses, and any ... A Text field can store up to 255 characters, ... Use the Memo data type if you need to store more than 255 characters. ... A Memo field can store up to 64,000 characters. ...
    (comp.lang.java.programmer)
  • Re: ? about data type.
    ... the Memo Field can store up to 2 G of characters ... TextBox Control, however, can only display 64 K of characters. ... > The data type Memo only allows you to store 65000+ characters. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Need a larger data type than string
    ... Another alternative, besides using the Memo field, would be to write the ... statement and I need a larger data type to hold the INSERT/UPDATE ... Does anyone know how I can get this to handle more than 255 characters? ... The String data type in VBA is able to hold up to approximately 2 billion ...
    (microsoft.public.access.modulesdaovba)
  • Re: Character count in field
    ... In one place in the Help file, it says "A Memo field can store up to 64,000 ... I don't suppose anyone knows off hand how many characters a memo field ...
    (microsoft.public.access.formscoding)
  • Re: Memo Field Limits???
    ... A Memo field can store up to 65,536 characters, right? ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.forms)