New Discussion Forum
-
We had a request to create a new forum to cover Access related issues - took a while to get there, but here it is. See the original discussion here:
Let the questions begin!
Andy
-
Subcription possible?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
20 minutes to figure that one out! Snitz, gotta love it. You have to insert rows into the subscripion table. Why would it be an attribute of the category or forum after all?
Andy
-
quote:
20 minutes to figure that one out! Snitz, gotta love it. You have to insert rows into the subscripion table. Why would it be an attribute of the category or forum after all?
Suboptimal DB Design ?Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Can we talk about Excel too? I would like to set a pivotcache to an ADO recordset from my SQL Server database but all the syntax I have found in books fails.
J. Moseley
[font="Courier New"]ZenDada[/font]
-
We'll give it a shot if it connects to SQL. No guarantees we'll do any good, but we'll try.
Andy
-
Microsoft Access.. Here is one for ya..
Address Book, Contacts Listing
Goal
Create a linked table with all the contact information from my address book
Code
Dim dbs As Database
Dim tdf As TableDef
Dim str As String
Const conTableExists = 3012
On Error GoTo Link_Err
' Set a reference to the current database.
Set dbs = CurrentDb
' Build the connection string.
str = "Exchange 4.0;MAPILEVEL=Outlook Address Book\;TABLETYPE=1;TABLENAME=Contacts;DATABASE=C:\Temp\;TABLE=Contacts"
' Create a TableDef object. The name specified for the
' TableDef object is displayed as the name of the link
' in the Database window.
Set tdf = dbs.CreateTableDef("Contacts")
' Set connection information and specify
' a personal address book.
tdf.Connect = str
tdf.SourceTableName = "Contacts"
' Append the TableDef object to create the link.
dbs.TableDefs.Append tdf
' Refresh the database window and clear
' the database object variable.
RefreshDatabaseWindow
This works really good, hope it helps someone.. 🙂
Will
screen name: womalley
-
We've used that driver a few times for projects, often easier than CDO - depending on what you need to do of course!
Andy
Suboptimal DB Design ?Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply