Download Access DB
-
I have an ASP.NET website created, code behind is in C#. It talks to an access DB (I know I know... should be using SQl, but the U.S. Govt. wont let me!) is there anyway to give a user and option to download my database? I keep having issues, because the LDB file created...
-
I have an ASP.NET website created, code behind is in C#. It talks to an access DB (I know I know... should be using SQl, but the U.S. Govt. wont let me!) is there anyway to give a user and option to download my database? I keep having issues, because the LDB file created...
Create a directory outside of your application and copy the Access database there. Give the ASPNET userid on the server just short of FULL NTFS access to that directory. That should take care of the LDB problem.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
-
Create a directory outside of your application and copy the Access database there. Give the ASPNET userid on the server just short of FULL NTFS access to that directory. That should take care of the LDB problem.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
I wont have an option to do a copy of the DB over, the database is being used as a data collection event, my functional users are going to be out of the U.S. to collect data, as well as I the computer programmer, will be out of the country, now our website since it's on a govt server, I cannot FTP, ftp is disabled, while the possiblity of having VPN back to our servers, is a possibility we can't gurrantee that.
-
I wont have an option to do a copy of the DB over, the database is being used as a data collection event, my functional users are going to be out of the U.S. to collect data, as well as I the computer programmer, will be out of the country, now our website since it's on a govt server, I cannot FTP, ftp is disabled, while the possiblity of having VPN back to our servers, is a possibility we can't gurrantee that.
Well, you can have the Access database file uploaded. However, if your users need to make modifications and download it back. That sounds like a synchronization nightmare.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
-
Well, you can have the Access database file uploaded. However, if your users need to make modifications and download it back. That sounds like a synchronization nightmare.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
No they will not need to upload anything. They will have access to our website, that is were my data collectors are inputing data, then, through out the event, we have to provide a copy of the data that we have collected so far, to some of the anaylst from another company, they are then going to take our DB, and do some analyst stuff on it. They will never give it back, and they will need a fairly constant update of it.
-
No they will not need to upload anything. They will have access to our website, that is were my data collectors are inputing data, then, through out the event, we have to provide a copy of the data that we have collected so far, to some of the anaylst from another company, they are then going to take our DB, and do some analyst stuff on it. They will never give it back, and they will need a fairly constant update of it.
-
Hi, Insted of allowing user to download live database you can provide facility to dowonload backup. You can write code to take backup at every some period of time and store that to some place on the server and provide the user with link to that location to download the database. I hope this will help you.
Thanks and Regards, Chetan Ranpariya