Browse actual file vba (1 Viewer)

Ridders, how can the file be linked to the network copy? Any suggestions /? Thanks

Ridders, had a word with my boss and according to him we will be using a separate backend to store the import files so there is no limitation in regards to the max space in the database if we actually import files in it.

Can anyone please help me with importing files into database rather than linking ?

Thanks

Just read your last two posts and am unclear whether you want to
1. Link to a network copy of the file
2. Import the file using the attachment field datatype

If its the first option, I'll upload some code you can adapt.
If its the second option, I will just repeat that I don't recommend it as it will cause your db to get much bigger, slow down and eventually reach 2GB limit

To set what I mean, add a couple of embedded images to a form e.g BMP files
Note the db size before and after doing this. Its likely that the increase will be more possibly much more than the size of the added images.
When he has time, I expect Doc Man will be able to explain why...

Now imagine importing multiple files .... bad news

Thanks Ridders, that makes sense. Can you pls upload code to link to a network copy of the file ?

Will do so this evening UK time. Out all day


Sent from my iPhone using Tapatalk

I already uploaded the code in post #7 of this thread:

https://www.access-programmers.co.uk/forums/showpost.php?p=1536601&postcount=7

The procedure is:

Private Sub fraLinkFile_AfterUpdate

Click to expand...

Screenshot of that part of a form:


I have just edited the code in post 7 so hopefully you won't get any compile errors.
If you do get errors, define any additional variables used at the start of the code module

If a variable starts with 'str' its a string
e.g. Dim strFilePath As String

I have also added module code for 2 functions used in the frame code so with luck you now have all you need