How to Open MS Access File

**DevDaniel** · August 9th 06, 09:41 PM posted to microsoft.public.outlook.program_vba

Using VBA, how do I open a Microsoft Access file from within Outlook.

**Michael Bauer [MVP - Outlook]** · August 10th 06, 06:51 AM posted to microsoft.public.outlook.program_vba

Am Wed, 9 Aug 2006 12:41:53 -0700 schrieb DevDaniel:

Sample with ADO:

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "D:\database.mdb"
.CursorLocation = adUseClient
.Mode = adModeShareDenyNone
.Open
End With

Set rs = New ADODB.Recordset
With rs
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockOptimistic
Set .ActiveConnection = cn
.Open ("select * from [Tabellenname]")
End With

' close record and connection
rs.Close
cn.Close

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --

Using VBA, how do I open a Microsoft Access file from within Outlook.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
OUTLOOK 2002 - No Option to Open an Outlook data file under the file open menu.	[email protected]	Outlook - General Queries	2	August 6th 06 03:49 AM
How do I open personal folders in outlook web access?	JEANDEJL	Outlook - Calandaring	9	June 23rd 06 07:29 PM
The process cannot access the file because it is being used by another	Jacobo	Outlook - General Queries	2	March 7th 06 07:52 PM
Can't Access OE File Folder When Importing into Outlook	cnysteve	Outlook - Installation	2	January 14th 06 08:26 PM
Open Access DB from Outlook	Richard	Outlook and VBA	2	January 10th 06 09:46 AM