[AccessD] OLEDB connection string - Help please

Andy,

Can you type in the Immediate Window 
Currentdb.TableDefs("TableName").Connect?

Are you using Management Studio?
Someone on the web suggested restarting the service, if that's possible for
you.

Michael R Mattys
Mattys Consulting, LLC
www.mattysconsulting.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andrew Lacey
Sent: Friday, June 01, 2012 8:32 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OLEDB connection string - Help please

Heeeeellllllpppp please


On 01 June 2012 at 08:17 Andrew Lacey <andy at minstersystems.co.uk> wrote:

> Sorry, the error I'm getting is actually "Could not find installable
ISAM".
>
> Andy
>
>
> On 01 June 2012 at 08:06 Andrew Lacey <andy at minstersystems.co.uk> wrote:
>
> > Morning all
> >
> >
> >
> > I know I'm late to this but I'm trying to setup an OLEDB connection 
> > string to SQL Server. I've found info on the web for this but I'm 
> > not having any joy.
> > This
> > is a code snippet of what I have.
> >
> >
> >
> > strConnect = "Provider=SQLOLEDB;Data Source=FRGRAAPP02;Initial 
> > Catalog=TALEG_CI;IntegratedSecurity=SSPI;"
> >
> > tdf.Connect = strConnect
> >
> >
> >
> > where tdf is defined as DAO.Tabledef and is sitting on a table 
> > definition of a table currently linked to an MDB. The code fails, 
> > however, with "Error Attaching tablename". Can anyone see what I'm 
> > doing wrong? The Data Source is the server name and TALEG_CI is the 
> > SQL Database which has no security on it. We're wanting to use 
> > Windows authentication.
> >
> >
> >
> > Help please. I really need this.
> >
> >
> >
> >
> >
> >
> >
> > Cheers
> >
> >
> >
> > Andy
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com