![]() |
Hello , how can i have access Ex:select on view/table from a local database server to a distant database server, with same session ? thanks
10 Jul 2015
| 1 comment
,
|
![]() |
I have a linked table from a teradata server database in accees database. i need to get from teradata table all records where in teradata filed table DATE1>01/01/2000 how to format the date 01/01/2000 in sql string? note: Tks.
20 Jan 2014
| 1 comment
,
|
![]() |
Hi
06 Dec 2013
| 2 comments
,
|
![]() |
I have succesfully set up an Access front-end that links tables from a Teradata database. Everything works fine when I have the tables linked through a DSN. I am trying to set up a DSN-less connection, but I am encountering the following error: "Reserved Error (-7778): there is no message for this error"
07 Nov 2013
| 1 comment
,
|
![]() |
Hi Masters, I have some questions on how user access works with respect to object and database level We have a database where all reporting views are residing. All users were granted Select access at the database level (through role or explicit grant) so they can query any view residing in this database. Now we want to revoke access on a particular view but still let them have access to rest of the views. Below are my questions
11 Jan 2012
| 3 comments
,
|
![]() |
Hello, I have been able to set up a connection to the Teradata DB using the following code, but an unable to insert the data from the teradata table to the Acesss Table ( Access Table is a replica of the Teradat Table, in terms of structure). Dim cn As ADODB.Connection Dim rs As ADODB.Recordset
06 Dec 2010
| 3 comments
,
|