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 |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2006-03-22 : 00:35:31
|
| As I cite in my previous post, we are restricted access to the live databases which my department uses intensively. We are only provided either access via Microsoft Access(by means of linked tables) or by exporting the tables or sections of the tables. As a result I am working in generating DTS packages to automaticlly import from the Access linked tables to our sql server tables every say one week. I would appreciate suggestions on what is the best approach to do so, by running an sql script (insert into MyTable from LiveTable where ....) or use the transformation task of DTS, or even others..thank you |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-22 : 09:36:28
|
| The best approach is, (duh!), to implement actual security logins and roles on your SQL server. By not doing this, you are creating a hack system worthy of kudos from Rube Goldberg, that I guarantee is not going to help your data security or data integrity one bit.Whatever.I guess if you have to do this, you could load data from your Access tables into linked staging tables and have the server verify and process the loaded data. |
 |
|
|
|
|
|
Alternatives to restricted database access