Graphic Files in DB

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hello everybody...question:
I have many forms with the company logo which is linked to
the graphic file to a specific location. Now, MIS needed
to move the folder (actually, the network share is no
longer available). Is there a way to tell Access to look
for the graphic files wherever the database resides? No
matter what drive it is? Thanks, Tony
 
One possible solution would be to create some sort of
Properties table, where you would store the path to this
image file in a column called "LogoPath". Then, whenever
your application loads, in some sort of initialization
routine, you can use the "Dir" command to check this path
(LogoPath) to see if it exists. If it does, then do
nothing, if not, prompt the user to search for the new
path and store it in this Properties table. Then, for
each form or report where this logo appears, you would
have an unbound Image control whose "Picture" property
would be set in code, by looking up this value from the
Properties table.

One other thought is, if this is a database where you have
linked tables, then you can easily change this path in
the "LogoPath" column to some new value in the back-end
table.

Just a thought...
 
Back
Top