Access accessing SQL {}

Im using Access to access a SQL database. For one of the queries i see the following under column:

{ fn month(dbo.TableName.Date) }

Ive never used this structure before but im confused to what it is? Can anyone explain please?

Thanks

The curly braces and 'fn' server to denote a OBDC level function.

The T-SQL equilivent would be:

month( YourDateColumn )

|||

Hello

Thanks for that. Could you explain a bit more on that please? As far as im concerned i didnt think there would be an ODBC link as it was connecting straight to a SQL database (checking ODBC theres no link to a SQL database either). Maybe an example if you can on what this user could have been trying to achieve would be great?

Thanks

Access 2k adp

Hi,

I posted this in an access adp newsgroup, but there don't seem to be any
messages there since 9-06.

I am accessing an online SQL Server (2k) database with an Access adp (also
2k). I'm new to doing this.

Does anyone know if I can append records to a SQL Server table thru access?
Will they "mesh"?

Thanks!JA wrote:

Quote:

Originally Posted by

Hi,
>
I posted this in an access adp newsgroup, but there don't seem to be any
messages there since 9-06.
>
I am accessing an online SQL Server (2k) database with an Access adp (also
2k). I'm new to doing this.
>
Does anyone know if I can append records to a SQL Server table thru access?
Will they "mesh"?
>
Thanks!
>
>

Yes, you can. It is just a SQL statament.. I usually use the ADP
functionality if I need a quick/dirty front-end.

Accesing offline cubes with MS Excel 2003

Hi,

I created offline cube (.cub file) with SQL Server 2005 Analysis Services. Accessing the offline cube with MS Excel 2003 I get an error message: "Unable to obtain list of tables from the data source".

I can access the offline cube with MS Excel 2003 only when MS Excel 2007 is instaled. After uninstaling MS Excel 2007 the same error ocures.

I have MS Excel 2003 (11.8146.6568) SP2, Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider, Microsoft Core XML Services (MSXML) 6.0 instaled.

Thanks for help,

Martin

Hello! This is only from what I have read.

To create local cubes you can write XMLA commands in Management Studio or write code by using the SSAS2005 object model called AMO.

I do not think that these two possibilities are part of Excel 2003.

HTH

Thomas Ivarsson