Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Chris120590
Starting Member
4 Posts |
 Posted - 2008-06-18 : 09:49:52
|
| We are an accountanting firm who wants to upload tax returns in the .pdf form for our clients. We want them to be able to login, receive that status of their return, and if completed download the .pdf. But what we cannot have is everybody having access to everybody's returns, it has to be exclusive to that client and their username and password. It also has to be a simplified process where once a .pdf is made, one of the employees will have administration access to upload the file to the website corrolating with a clients information. I'm assuming that would be done by a web application?? I have already set up a a login control, on the login.aspx page, along with the ASPNETDB.MDF through the ASP.NET Configuration tool. Also, I'm assuming the file naming process of the tax returns would fall into play somewhere?? I some how need to take the login information from the ASPNETDB.MDF and relate it to their PDF's. What I have explained is the major purpose of the site and if I could find the right help I would greatly appreciate it because I've been stuck on this road block for awhile. Thanks,Chris120590 |
|
|
mckreddy
Starting Member
2 Posts |
Posted - 2008-06-18 : 14:45:30
|
| Relate the TaxFile information to the enduser in one of the table. If the logged in user is administrator then display all the files. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-18 : 14:56:36
|
| For a process that needs to be very secure, why don't they hire someone who has programming experience and SQL Server experience?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
Chris120590
Starting Member
4 Posts |
Posted - 2008-06-23 : 17:38:30
|
| Thanks mckreddy, I understand I have to create a relational database but I am unaware of how to place the .pdfs in the table. Not only that but how to simplify the process.tkizer, because that would be just too easy and there is always more room to learn something new. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-23 : 18:53:12
|
| It is recommended to store the files on disk rather than in the database, then store the path and filename in the database. There is plenty of information out there about this type of design, just do some searching on storing images or blogs in the database and you'll see the debates about this plus how to code it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
Chris120590
Starting Member
4 Posts |
Posted - 2008-06-24 : 09:43:09
|
| I understand storing the location and storing the files on the server. But is there a way a designated employee can upload the file not have to worry about coding or anything like that. Just some kind of web application. Because the database will constantly having these files added and I wont always be available. I just need it where one of the employees can login and upload the file to a user through the site or something like that.Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Chris120590
Starting Member
4 Posts |
Posted - 2008-06-24 : 12:16:17
|
| Thank you for your time |
|
|
|
|
|
|
|
|
Order Status like Webpage