Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Storing Documents

Status
Not open for further replies.
txaccess

txaccess

Technical User
Jul 21, 2004
91
US
Can anyone please tell me the equivalent of an Acces OLE data type in SQL Server so that I can attach documets to records?

Thanks

I haven't failed, I have just found 10,000 ways that it won't work!
 
Sort by date Sort by votes
The data types text and varbinary will hold 2x31-1 characters. You should be able to go with the text data type. ntext is the equivalent for unicode characters.

 
Upvote 0 Downvote
Thank you

I haven't failed, I have just found 10,000 ways that it won't work!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

frankhdata
  • Locked
  • Question
storing pictures in data base
Replies
0
Views
26
frankhdata
frankhdata
jcg6
  • Locked
  • Question
Storing Listbox selections in table 1
Replies
4
Views
40
jcg6
jcg6
bwshawn
  • Locked
  • Question
linking documents
Replies
0
Views
14
bwshawn
bwshawn
Cheryl3D
  • Locked
  • Question
Storing the Current System User in SQL Server DB via Form
Replies
6
Views
28
tlbroadbent
tlbroadbent

Part and Inventory Search

Sponsor

Back
Top