using Access database to hold daily blog?

[Sidro]

hi,
I was thinking of using access to store daily blogs and was wondering if access is capable of holding blogs?

Are there size limits for holding text strings?
thanks in advance.

 

[Gwena]

Hi Sidro,
As far as I know Memo Data Type can hold Up to 65,536 characters
but OLE Object can hold objects (such as Microsoft Word documents, Microsoft Excel spreadsheets, pictures) Up to 1 gigabyte

 

[willir]

Sidro

Another approach would be to use hyperlinks in Access pointing to your blog.

A recent post...

http://www.tek-tips.com/viewthread.cfm?SQID=854544&SPID=181&newpid=181&page=1

Richard

 

[Sidro]

HI Gwena,
This is regarding the response,

"As far as I know Memo Data Type can hold Up to 65,536 characters...."


My question is, is that 65,536 characters per field?
Example, suppose I have a field called,"Receipe". The "Receipe" field can hold 65,536 charactors? And if I create more fields on the same database, those other fields can hold 65,536 charactors also?

thankx you guys or gals for the help

 

[MikeRBS]

This:

http://www.experts-exchange.com/Databases/MS_Access/Q_20962203.html

reports 778147 characters in a record

 

[Gwena]

Hi Sidro,
As Far as I know... (just kidding)
Well, Scanning MSDN I found this:
Memo size: "Up to 65,535 characters. (If the Memo field is manipulated through DAO and only text and numbers [not binary data] will be stored in it, then the size of the Memo field is limited by the size of the database.)"

A record in Access is limited to 2k, not counting Memo fields.Meaning there is no limit on how many memo fields you have or how big they are because

whenever the 2K limit is reached on a record, Visual Basic automatically puts the Memo field on a separate page in the database file

hope it helped