Politics
Wed, 05 Nov 2008 15:03:37 -0800
columns sunos tricktheeye beebord binding hairier yields unpopularity iyfeg ...
|
select unique field when linking to a sqlserver view by code
Sun, 2 Nov 2008 09:10:21 +0200
When manually creating a linked table whose source table is a sqlserver
view, Access prompts for the unique field, without which the linked table
isn't updatable.
I need to create such updatable linked tables by code (with CreateTableDef).
Access doesn't allow adding indexes to linked tables, so my tables a ...
|
Politics
Fri, 31 Oct 2008 04:08:49 -0700
sfs unmatched nooperation lchaim cm points exchanges infected hogans ...
|
Using a table-valued function of a linked SQL Server database
Thu, 30 Oct 2008 13:16:08 +0100
Hello,
is there a way, to use a table-valued function stored in an SQL Server
database, to get the results into a MS Access database?
It should also be possible to pass parameters to the function.
As the function is not listed in the linkable table list, I'm not sure how
to do that.
Is there a way to s ...
|
my odbc connection drops after a while.
Wed, 29 Oct 2008 03:41:01 -0700
I am using Access 2007 to connect via ODBC (SQL Native Client driver) to our
MSSQL server 2005.
Nothing wrong with the connection except that it drops after about 8 to 10
minutes.
Is there a time out / keep-alive on SQL or ACCESS that needs to be set?
Thanks.
...
|
Using Active Directory Data in Access
Wed, 22 Oct 2008 09:20:05 -0700
I need to document permissions on my network and would like to link Access to
Active Directory data so that I can build Access reports using Active
Directory data. Is there any simple way to do this? ...
|
Question about 2 functions
Thu, 16 Oct 2008 14:43:18 -0500
Hello all, Maybe I am not understanding how calling a function is
supposed to work or just doing something silly. I am linking to SQL
tables in Access.
Here is my code and i will try and explain it step by step as I see it
Function LinkTables()
Dim db As Database, rs As Recordset, tblName As String
Se ...
|
|
|
ODBC, FoxPro, WinXP, WinVista, Off2003, Off2007: testing...
14 Oct 2008 16:56:44 +0200
x-post to microsoft.public.access.odbcclientsvr, microsoft.public.access,
microsoft.public.it.office.access
follow-up to microsoft.public.access
ยง
Hello
The procedure is currently running on Windows XP, with Access 2003, ODBC
driver to access some external databases VisualFoxPro, driver v.
6.01.862 ...
|
How best to trap for errors, things like required fields that are null?
Fri, 3 Oct 2008 10:33:11 -0700
Is there any systematic way in which one can handle odbc data errors on
Access 2003 forms? sql 2005 is the backend.
Example is if a user does not enter a value into a required field in a
subform. If they click the save button, which runs code to save the
record, I can trap for error 3146. But if the user cl ...
|
ODBC Link Question
Wed, 1 Oct 2008 13:42:00 -0700
I have a database that is used by multiple users. I have added a new ODBC
table that is link to a table on Oracle. It is the only ODBC table on my
Access 97 database. Is there a way to code the link between Oracle and my
database without having each one of my users manually add the link so it will
refresh ...
|
