Storing files in an Access DB

[ChrisP]

I have a Access 2002 db that is storing scheduling for a
small business I have. I wanted to know how to store
files in the database in a specific table. The only field
I seen was ole/object that probably is the only field
that may let me do this.

I would like to know which field and anything I have to
do to the specific table.

Also what would my INSERT statement look like to attach a
file to this field.

I also have SQL 2000 server, but I won't be moving the
application for scheduling over to another DB for a
while. Is SQL server better for storing files of any size?

Thanks alot for your help and info ahead of time.
Chris

 

[Arvin Meyer]

There is a 2 GB limit to the size of an Access database, although the
practical limit is smaller. You can attach multiple databases to a single
front-end (forms, etc.) to increase the size, but this is a kludge.

You don't *need* to use insert statements with bound fields/tables, but if
you do, they look like any ANSI 89 or 92 compliant SQL.

My suggestion would be to store the files externally, then store a path to
them. I have an example of that on my website for Word and txt files:

http://www.datastrat.com/Download/DocMgr_2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access