Reference to filename in Access table field?

[Paul Schrum]

I want to have a field in a table refer to a file on my computer or on
the network. What is the best way to accomplish this?

- Paul Schrum

 

[Arvin Meyer [MVP]]

How do you want to refer to it? Do you want to open it? Try:

http://www.mvps.org/access/api/api0018.htm

 

[Paul Schrum]

Arvin,

Thanks for the link. That will be very useful.

It is not what I am asking about, though. I would like to be able to
create a table which is a link to a directory. It would be just like
a link to, say, XL, but the "application" it is linking to is the file
system. The rows in this table would be the file names in the
directory. The user could use that linked table as a lookup in other
tables.

- Paul

P.S. Sorry if you see two replies. I typed one reply in but it seems
to be lost, so this is my second attempt.

 

[Arvin Meyer [MVP]]

You could use a hyperlink, but I find that a plain text field is sufficient
and offers less chance of a problem. If it is a text field, you can also
index it and use it as a lookup value. For speed of execution, I'd also add
a autonumber primary key field which will allow even easier lookups.

 

[Paul Schrum]

Arvin,

Again, thanks for your help. I did not want to be rude and just stop
posting, but I think we should move on from this topic. I can tell
from what you are saying that you still do not take my meaning, and it
is the kind of thing in which, if it could be done, you would have
known about it and understood what I was waying. I suspect there is
no way to do this in MS Access.

Thanks. No need to reply.

- Paul

 

[Arvin Meyer [MVP]]

I'm sorry that we're not communicating. As I understand it you want to store
the path and file name in a database. That can easily be done with a text
field or fields, if you want them stored separately.. Using the field(s) you
can manipulated the data (Copy, Move, Rename, Delete, etc) using Visual
Basic commands. Using the API that I mentioned, you can open the file. If
that is not what you meant, I must apologize. That is how I interpreted this
post:

"I want to have a field in a table refer to a file on my computer or on the
network. What is the best way to accomplish this?"