Access 2007 to SQL server file upload?!

[Rebecca McCallan]

I have an Access 2007 database with an attachments facility. Currently the client may upload files locally but the files cannot be accessed elsewhere. I have been able to carry out a similar operation when developing on a web based system however I cannot seem to do it on an Access 2007 database and I am unsure as to whether it is even possible. Basically the system needs to connect to the SQL server online and upload the file although the database is not online itself. I would be grateful for any pointers!

[ck9663]

Which part of the application belongs to SQL Server? You mentioned connection, is that all the SQL Server part is?

~~ CK

[Rebecca McCallan]

It is not actually me working on it to be honest, I am researching for someone else. I believe none of the application is on the SQL server currently but we are looking to put files on it for the client to access anywhere they wish. Thanks for the reply!


Rebecca

[ck9663]

You might want to get the requirements completely first before you proceed with your project. You can give your friend this link so that he can give more details. We might be able to give some info but it might not be the most efficient solution for his need. The solution will always depend on the objective of the application.

Good Luck!!!

~~ CK

[Rebecca McCallan]

Well I'm researching it for my boss so it's a bit pointless giving him this link as then I won't be researching it for him! But anyway I will ask him for further clarification when he is back in the office.

Thanks for your replies,


Rebecca

[ck9663]

Let's start with the basics...

When you say,

with an attachments facility

Are you uploading a file via an ftp protocol or just copying the attached file into a folder within the PC?

Assuming nothing, what you need is a web and ftp server. You're going to have to convert your application into a web-based application that can accept input/attachments from the user. Your application then has to grab that file and upload it to your ftp server, all in the background and handled by your app. That file may now be accessible everywhere. Subject to your security policy.

Happy Coding!!!

~~ CK

[Rebecca McCallan]

At the moment as it is local the database records the path of the file which the user has selected and stores it in a table then opens it from that location when the users wants it. Thanks for the advice.

Rebecca

[ck9663]

Yes, that would be the same technique that you can use using a web+mssql application. However, to transfer the data from your client to your host, it would be better to use an ftp server. Then you store the path on your table where the app can also see it.

There will be other consideration (securities, housekeeping process, etc), but that will be the overview, over-simplistic explanation :)

Good Luck!!!

~~ CK