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 |
|
daniel.newman@bis-web.net
Yak Posting Veteran
71 Posts |
 Posted - 2001-08-06 : 07:09:42
|
| I have a slight problem with an applictaion I've inherited from another developer (if I can call him that!! :-)The web site uses three databases, one that is a combination of the other two using linked tables, which is used for all ASP page access. One database is for book details, and the other database is for web details (orders, CC numbers eek!, etc.)I have a problem in that the clinets wants to add illustrations to the web details db. I can't really allow them to download the db, make changes and send it back up, as this'll lose any orders made after their download.I want to give them access direct to the required tables using the linked tables accessed via FTP locations. Trouble is, everytime I select the database in question, I keep getting an error message that the file can't be found! Probably a prmissions problem in that it's being used by the main database.Does anyone have any ideas how I can upload new data from a few selected tables. I don't know Access, and would love to move the whole thing into SQL, but don't think they could afford that.Can I run an Update query or something remotely? So If they upload the whole database to another directory, and then run the update into the existing database. Bit of a mess as it means two databases on the server?Any ideas will be great.Thanks for your time,Daniel Newman. |
|
|
|
|
|
|
|
Linked tables across the Net.