FAQ Database with images

T

TheNovice

hey all,

I have a odd question. I am in the process of creating an Access database
that will maintain all of our FAQ for the IT department. what we want to do
is something like what "Help" does. Let me explain.

I am copying a table that has all of the info needed, but the problem is I
want to paste information that is either in a working document (MS Word) and
is does not maintain the images.

So the question is, can that be done?

Also the manager wants the capability to create FAQ's on the fly so that
other divisions can contribute to it.

As always your guidance is greatly appreciated,

I have searched and searched for the means but have not been able to find
the solution.

Regards,

Charles Davis
 
T

TheNovice

Arvin,

Thanks, I was looking just to paste the information to the Access Databse
that does not require having so many files linked to it.

any other ideas?
--
-The Novice
Learn Today, Teach Tomorrow

Great Success is ones ability to ask for Help.
 
J

John W. Vinson

Thanks, I was looking just to paste the information to the Access Databse
that does not require having so many files linked to it.
Click to expand...

You're out of luck, unless you have A2007. Previous versions of Access handled
image data VERY inefficiently - a 50k .jpg file would be stored, but Access
would convert it to .bmp format and store that TOO, so each 50k image might
bloat the database by 500k. It only takes a modest number of such records to
exceed the 2 GByte limit on total database size.

The problem is fixed in 2007, though I haven't worked with it enough to
suggest how to manage it.

John W. Vinson [MVP]
 
A

Arvin Meyer [MVP]

Help files are also external to the programs they provide help for. Usually
there are multiple help files for each program. Searching is done within the
help file itself. You can make Office and Access help files that do that,
but I understand that you want a simpler system that is searchable from
within the database instead of the help file itself. I suggest that you
still use links, and put the files within a single folder. That way it's
still easy to organize, catalog, and use, and you can still have the
advantage of backup and independent authorship.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
Top