Accessing OLE data object

[ralfymac]

OLE data type is used to store word file since memo data type has the character limit constraint. I could store the word file successfully. Accessing this word files on a button click is a problem. The table structure is as follows:
ID - Primary Key - Auto Number
RegistartionID - Foreign Key - Number
Notes - OLE Object

Any help will be really appreciated

 

[petehilljnr]

Do you really need to store the entire Word file in your database?
Why not just a path to the word file?

 

[ralfymac]

Do you really need to store the entire Word file in your database?
Why not just a path to the word file?

Now the problem is storing the path to String data type. I have written the query as follows
path = "C:\SLS\" + StudentID + ".doc"

"UPDATE tblRegCSLword SET Link='" & path & "'" _
& "WHERE tblRegCSL.RegistrationID=tblRegCSLword.RegistrationID AND tblRegCSL.SID = " & StudentID & ";"

This gives error as "Error storing the link" Error number: 3219

Thanks for all your help

 

[petehilljnr]

I'm assuming the field Link is a Text field large enough to hold full path.

How are you looping through your recordset to run that script?

Path = "C:\SLS\" & StudentID & ".doc" perhaps?