MS ACCESS support needed again :(

Science & Technology Information Technology, Gaming, Machines, Gadgets
1

Is it possible to give user an option to attach a file in msaccess? if yes then how can it be implemented? if no then what other ways we can use to upload the files or attach it using word format?

thank you kindly for your help :slight_smile:

2

Re: MS ACCESS support needed again :frowning:

I gather you wanna use ASP for this???

these might help:

http://www.freevbcode.com/ShowCode.asp?ID=5340

aloha
3

Re: MS ACCESS support needed again :(

umar I can't work with asp, problem is I can't make any connection with any server, since this company doesn't have their server here. And I don't have admin rights. I was wondering if access itself can do something like that; since, we can attach files and send it through an email. I was thinking there has to be some vb prog that would allow me to create something like this.

Thanks for hearing my shout :)

4

Re: MS ACCESS support needed again :(

^^ hmmm... I'm not exactly sure if I'm getting what you wanna do PD. You want a webpage for people to upload their resumes' right and somhow store the files on a server disk, and links to those in an Access DB - right??

You do need some type of Server side technology to do this though...

if you tell me a lil more, maybe I/others here can help more.

5

Re: MS ACCESS support needed again :frowning:

Well I am not exactly making a webpage anymore. At first I wasn’t aware of that they don’t have any server here, but then I did investigate on my own and came to know they don’t have anything here. Yeah I know, its making me suffer. But then since I did promise the HR manager to make her life easy and release her from carrying her notebook stress. I made a database for her and now she was asking me if its possible to attach resume in it, instead of going through copy pasting stuff. I hope you do comprehend me now. So what I am looking for a script or a query that would help me create an option to attach files in database. Is this doable?

6

Re: MS ACCESS support needed again :(

PD, the datatype you are probably looking for is "blob" (in most dbs) in which you can attach binary attachments. I'm afraid that datatype is not available in Access.

You can use the datatype OLE Object and use the Insert/Object in the table. Or you can put in a hyperlink to the file (e.g. resume.doc) in the database and have the file sitting in a specific share on the network.

7

Re: MS ACCESS support needed again :frowning:

I have tried with OLE object and also with linking, I am fine with table properties. But I don’t know how I am suppose to output that on the form. I hope you are getting me. I know I can do it, but its not coming to me for some reason. :(, if you could provide me with an example that would be great. I have looked over blob example too, it didn’t do much for me. I was wondering while you are at this problem, would you be able to tell me how I can sort record manually. I mean I have to put fields in certain order. I am working on it though, hopefully I will be successful. thank you for your response Tofibaba.

CB * mad *