By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Blob in Access

P: n/a
Hi,

I have MS Access 2002. I want to make create a table with a blob field
but I don't see that option when creating a table. I want to store
text in the blob field.

How do I do this?

Thanks,
Lee G.
Mar 7 '08 #1
Share this Question
Share on Google+
8 Replies


P: n/a
On Thu, 6 Mar 2008 18:51:25 -0800 (PST), leegold58 <go******@worldpost.com>
wrote:
>Hi,

I have MS Access 2002. I want to make create a table with a blob field
but I don't see that option when creating a table. I want to store
text in the blob field.

How do I do this?

Thanks,
Lee G.
Try the "memo" data type.

Wayne Gillespie
Gosford NSW Australia
Mar 7 '08 #2

P: n/a
"leegold58" <go******@worldpost.comwrote
I have MS Access 2002. I want to make create a
table with a blob field but I don't see that option
when creating a table. I want to store
text in the blob field.
As Wayne said, a Memo Field will work; so will an OLE field. There's an
example of using a BLOB in Access in the Imaging Examples you'll find at
http://accdevel.tripod.com -- note those examples and article have not yet
been updated for Access 2007.

Larry Linson
Microsoft Office Access MVP
Mar 7 '08 #3

P: n/a
Bob Quintal <rq******@sPAmpatico.cawrote:
>I actually copy the file to an attachments subdirectory on the
server, renaming it to the primary key of the attachment's record,
then set it (the copy) to read-only.
I do that as well. 00000001.<file extension>, etc.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Mar 8 '08 #4

P: n/a
Bob Quintal <rq******@sPAmpatico.cawrote:
>then set it (the copy) to read-only.
Now that's an idea I hadn't thought of.

Thanks, Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Mar 8 '08 #5

P: n/a
"Tony Toews [MVP]" <tt****@telusplanet.netwrote in
news:b3********************************@4ax.com:
Bob Quintal <rq******@sPAmpatico.cawrote:
>>I actually copy the file to an attachments subdirectory on the
server, renaming it to the primary key of the attachment's record,
then set it (the copy) to read-only.

I do that as well. 00000001.<file extension>, etc.

Tony
Great minds think alike :-)

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Mar 9 '08 #6

P: n/a
Per Bob Quintal:
>I did one application where the attachments table did originally
include the ole field, and was not impressed.

The DBA admin at work won't allow blobs in SQL Server.
I think a pattern is beginning to emerge.... -)
--
PeteCresswell
Mar 9 '08 #7

P: n/a

"(PeteCresswell)" <x@y.Invalidwrote in message
news:93********************************@4ax.com...
Per Bob Quintal:
>>I did one application where the attachments table did originally
include the ole field, and was not impressed.

The DBA admin at work won't allow blobs in SQL Server.

I think a pattern is beginning to emerge.... -)
There are good, knowledgeable, reasonable, and secure DBAs who are easy to
get along with. I have been lucky to deal with many in this category.

Then there are the others... not so knowledgeable, and thus insecure, and
decidedly unreasonable trying to cover their behinds. I've have a good many
customers and clients and people asking questions who had to deal with that
kind... and neither they nor the DBAs had any fun at all.

Larry Linson
Microsoft Office Access MVP
Mar 9 '08 #8

P: n/a
"Larry Linson" <bo*****@localhost.notwrote in
news:GPJAj.658$Qy3.632@trnddc03:
>
"(PeteCresswell)" <x@y.Invalidwrote in message
news:93********************************@4ax.com...
>Per Bob Quintal:
>>>I did one application where the attachments table did originally
include the ole field, and was not impressed.

The DBA admin at work won't allow blobs in SQL Server.

I think a pattern is beginning to emerge.... -)

There are good, knowledgeable, reasonable, and secure DBAs who are
easy to get along with. I have been lucky to deal with many in
this category.
I'd put the DBA at work in the above category, not the one below.
Then there are the others... not so knowledgeable, and thus
insecure, and decidedly unreasonable trying to cover their
behinds. I've have a good many customers and clients and people
asking questions who had to deal with that kind... and neither
they nor the DBAs had any fun at all.

Larry Linson
Microsoft Office Access MVP



--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Mar 9 '08 #9

This discussion thread is closed

Replies have been disabled for this discussion.