[dba-SQLServer] linking back...

Hi Gustav,

>> The only thing I miss is how to open those links non-exclusively

Don't know if this is applicable in your case. But I've noticed the same behaviour when linking an Access database to Excel: the Access database will be read only as long as Excel holds the connection.
A workaround to this is to edit the connection string in Excel and change the setting "Mode=Share Deny Write" to "Mode=Share Deny None". This will make the db full editable in Access even if it's opened in Excel.
Maybe you can make a similar setting in your app.

Asger

-----Oprindelig meddelelse-----
Fra: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Gustav Brock
Sendt: 12. september 2011 10:52
Til: dba-sqlserver at databaseadvisors.com
Emne: Re: [dba-SQLServer] linking back...

Hi Mark

It certainly can, both for read and write. It is explained in the BOL and in daily use at one of our clients linking two Access 2.0 database and one Access 97 database in use by third party apps.

The only thing I miss is how to open those links non-exclusively; right now the users have to step out of the apps using the Access databases (no big deal, three users only) before transfer can take place between SQL Server 2005 and the linked databases. The transfer is controlled from my C# WinForms app which uses DataTableAdapters to connect to the databases, then custom code performs one-way or two-way appending or updating of records (I don't delete anything) 

Another option I have yet to test is the Sync Framework of Visual Studio. This should take care of the table plumbing to enable you to code on a higher level.

/gustav


>>> marklbreen at gmail.com 12-09-2011 10:03 >>>
Hello Francisco,

Do you mean that SQL Server can link to a Jet db?  If so, I did not know that.

Or are you attempting something else?  I presume that you do not want to install Office ?

Mark


On 6 September 2011 22:27, Francisco Tapia <fhtapia at gmail.com> wrote:

> I thought I had a grasp of this but there is something wrong with my machine
> and the new sql server 2008 r2 cluster :-|.  I have a vendor specific Access
> Database which I must link down to vs Upsizing, the vendor doesn't support
> the upsize, but being that I'm on a new OS and the culster is on 2008, I
> don't see the drivers for the jet engine... :-| anyone been through this hoop?
>
> arg!
>
>
> -Francisco
> http://bit.ly/sqlthis   | Tsql and More...


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com