> Hi,

> I am having a problem with connecting to the Access 2000 database.  Here's
> my situation.

> I have a VB6 frontend using Access 2000 with linked tables to SQL Server
> 2000
> Before I moved the tables to Sql Server the code works fine.

> Here is some of my code:

> daoDB36 as Database
> rs as DAO.recordset

> ....
> set rs = [datUsers].Database.OpenRecordset("Log", dbOpenTable,
dbAppendOnly)
> ...

> If the Access 2000 database doesnt have linked tables to SQL Server 2000,
it
> works fine.  If I have linked tables then I get the following error:

> Run-time error '3219'   Invalid Operation.

> Is there something special I need to do to be able to access linked tables
> in SQL Server 2000??
> Could you please help??
> Thanks,
> Will

> Try different recordset type (instead of dbOpenTable try dbOpenDynaset)
and
> see if you still get the error

> Raf

> --

> Rafael Szuminski
> www.BDCSoftware.com

> > Hi,

> > I am having a problem with connecting to the Access 2000 database.
Here's
> > my situation.

> > I have a VB6 frontend using Access 2000 with linked tables to SQL Server
> > 2000
> > Before I moved the tables to Sql Server the code works fine.

> > Here is some of my code:

> > daoDB36 as Database
> > rs as DAO.recordset

> > ....
> > set rs = [datUsers].Database.OpenRecordset("Log", dbOpenTable,
> dbAppendOnly)
> > ...

> > If the Access 2000 database doesnt have linked tables to SQL Server
2000,
> it
> > works fine.  If I have linked tables then I get the following error:

> > Run-time error '3219'   Invalid Operation.

> > Is there something special I need to do to be able to access linked
tables
> > in SQL Server 2000??
> > Could you please help??
> > Thanks,
> > Will