Get constant current SQL Server Table data to Access 2000 FE

[corythewiz]

Hello, I have a situation where I need to be able to obtain the current
information at any time from a SQL Server 2000 table. The catch is that the
original SQL Server 2000 database holding this table cannot be touched in any
way. All work must be done in a totally separate SQL Server Group/SQL Server
2000 database and the original data will not be updated in any way. This is
needed to simply be able to pull the information from the original table.
The front end is Access 2000. I know I can use DTS and pull the data that
way but that is not really the answer as I need it constantly current. A
VIEW would be nice but I cannot touch the original database. Thanks in
advance for any suggestions. Cory

 

[Sylvain Lafontaine]

You should really post this in a newsgroup dedicated to SQL-Server such as
microsoft.public.sqlserver.server or m.p.s.programming. You should also
define with precision what you mean exactly by "constantly current".

Possible solutions would be Log shipping, Replication or Database Mirroring
(this one is only available with SQL-Server 2005). In your case, using
Replication is probably out of question; unless you use some external
replication/duplication solution.

 

[DanRoss]

it looks like your reference to "cannot be touched" means "you can not
modify it's data" if that the case and you can query the table (you referd
to a dts package to pull the data) why not just link the SQL table to your
Access Solution and query directly against that as your source.

Perhaps I don't understand your situation completely.

 

[corythewiz via AccessMonster.com]

Hi Dan,
Thanks for your help. I am consulting and running an application entirely
separate from the rest of the companys main application and in no way do I
want to impact anything on the original SQL Server 2000 DB nor do I want to
be accused of effecting it in any way including any slow down in performance.
"Cannot be touched" means any work I do will be external to the original DB.

Cory

it looks like your reference to "cannot be touched" means "you can not
modify it's data" if that the case and you can query the table (you referd
to a dts package to pull the data) why not just link the SQL table to your
Access Solution and query directly against that as your source.

Perhaps I don't understand your situation completely.

Hello, I have a situation where I need to be able to obtain the current
information at any time from a SQL Server 2000 table. The catch is that

[quoted text clipped - 11 lines]

VIEW would be nice but I cannot touch the original database. Thanks in
advance for any suggestions. Cory