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 |
|
mgoergl
Starting Member
2 Posts |
 Posted - 2004-06-20 : 16:19:37
|
| Hi!I've got the following problem and would like to know if there is any solution to it:I developed a web application (ASP) using ms access as db on my webspace. Now I've also got an MS Access db on my desktop which I want to use to access the data stored in the db on the webspace. I thought of using the functionality in Access which alows to import/connect tables from other databases. But this seems only to work on my home pc - not via web.Before changing to MS SQL - can anybody tell me, if it is easier to connect my desktop-acces-db to a sql-server on the webspace?kr, Michael |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-06-20 : 19:54:40
|
| Just to clarify:You've got an Access db sitting on your ISP's servers and you want to maintain the data via your home PC?I don't think you can link tables this way - it would present a security problem for the ISP. Some ISP's offer import/export functionality to allow clients to update their databases. You'll need to check with them on how you'd do this.You could possibly create some Admin ASP scripts that allow you to upload/download MDB files to your web database, but this may also depend on how much freedom your ISP gives you.HTH,Tim |
 |
|
|
mgoergl
Starting Member
2 Posts |
Posted - 2004-06-21 : 01:09:18
|
Hey! thanks for the info!I'll check with my ISP. Still the problem is, that it should work as easy as possible (for my client) and it should not need too much manual interaction...kr, Michaelquote:
Originally posted by timmy
Just to clarify:You've got an Access db sitting on your ISP's servers and you want to maintain the data via your home PC?I don't think you can link tables this way - it would present a security problem for the ISP. Some ISP's offer import/export functionality to allow clients to update their databases. You'll need to check with them on how you'd do this.You could possibly create some Admin ASP scripts that allow you to upload/download MDB files to your web database, but this may also depend on how much freedom your ISP gives you.HTH,Tim
|
|
|
|
|
|
|
Connect MS Access to SQL Server