OLE object or file location?

[supa_sumo]

Heres the situation, im making a web site (one that is layed out like the columnar report from the wizard) using data stored in an access database including a photo of the item I need to sell, would it be easier to store the picture as an OLE object in the database or save the picture location, The web site needs to be updated daily, I was thinking about using a transaction file so that not all items need to be changed, is this more complicated and pointless considering the database will only hold abour 50 items that need to be placed online.

 

[WayneRyan]

supa,

Generally, you don't want to store graphical objects in an
Access database. Just store the location.

Don't understand the second part about the Trans file.
What is changing about the database objects?

50 items is not a limiting factor at all.

Wayne

 

[supa_sumo]

Each day maybe one bike is sold and one bike is purchaced,these bikes would need to be added and deleted from the database, a transaction file would store this information instead of updatind the main access database. then at the end of the day the update information is uploaded instead of the complete edited database.

 

[WayneRyan]

supa,

With that volume, I'd make it simpler and avoid the use of the Trans
file. Why complicate things?

Wayne

 

[supa_sumo]

That makes sence but has any1 got any idea how I can do this ? not too experienced with web site design. How the hell do I get the pictures and the information to be layed out one after another? any ideas?