Re: Can SQL Server 2005 SP1 'mirror' and Access database?
- From: "Jonathan Psaila-Depasquale" <jpd underscore ng at hotmail dot com>
- Date: Thu, 31 Jul 2008 15:44:48 +0200
Hi Mark,
Unfortunately you cannot mirror an Access database. Mirroring uses
underlying mechanisms in SQL Server that simply do not exist in Access. So
the reason you cannot mirror your Access database is not a matter of
Microsoft choosing not to make that functionality available. It is just
impossible.
The same applies for functionality such as log shipping. Again it would be
impossible to implement. Similarly replication is not going to be much use
to you because Access can only be a subscriber in SQL Server replication and
what you need is to publish FROM Access.
You could use linked servers but that is really using DSNs. I'm not sure
what your motivation for not using DSNs is. Perhaps you can elaborate on
that.
Another option maybe to use SSIS packages to transfer/update your data from
Access to SQL Server on a regular basis. In this case you will need to have
an existing database structure on SQL Server before you can do this. To
this end you may want to investigate the upsize wizard that comes with
Access as it will create you Access database structure in SQL Server. Be
warned that this could be a messy solution. You will need a good mechanism
for tracking which data has been added/updated/deleted on the Access side to
make the right changes on the SQL Server side. Alternatively if your Access
database is not large and your users can live with having data up-to 24
hours old, you could truncate all your SQL Server data nightly and reload it
using your SSIS package(s).
Hope this helps.
Regards,
Jonathan
"Mark B" <marximus@xxxxxxxxxxx> wrote in message
news:eG3yOIw8IHA.3848@xxxxxxxxxxxxxxxxxxxxxxx
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
.
- References:
- Prev by Date: Can SQL Server 2005 SP1 'mirror' and Access database?
- Previous by thread: Can SQL Server 2005 SP1 'mirror' and Access database?
- Index(es):
Relevant Pages
|
