Can SQL Server 2005 SP1 'mirror' and Access database?
- From: "Mark B" <marximus@xxxxxxxxxxx>
- Date: Thu, 31 Jul 2008 21:39:17 +1000
Hi experts,
As per the subject, can SQL Server 2005 SP1 'mirror' an Access database?
We have an Access database (associated with a commercial software product)
that is not particularly programmer friendly, and uses its own custom
written interface (non web).
Our staff would like to access some of the data in this database, as a web
client, and read-only (ie, they just want to check data, from within and
outside the LAN).
So, we figure a web page is the way to go, but we'd like to have our
ASP/Java/HTML get data from an SQL database - not via a DSN to the Access
DB.
Can it be done? How would I do it? "Mirroring" in SQL 2K5 only refers to
mirroring another SQL server - not an Access DB...
Thanks,
Mark
.
- Follow-Ups:
- Re: Can SQL Server 2005 SP1 'mirror' and Access database?
- From: Jonathan Psaila-Depasquale
- Re: Can SQL Server 2005 SP1 'mirror' and Access database?
- Prev by Date: Re: SQL Browser on Windows Server 2008 with 2 networkcards
- Next by Date: Re: Can SQL Server 2005 SP1 'mirror' and Access database?
- Previous by thread: SQL Browser on Windows Server 2008 with 2 networkcards
- Next by thread: Re: Can SQL Server 2005 SP1 'mirror' and Access database?
- Index(es):
Relevant Pages
|
