Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default read access db using excel vb

I have the following code. I keep getting a type mismatch (run time error
13). Could somebody tell me what I'm doing wrong.

Sub Button1_Click()

Dim DbRpt As Database
Dim RsRpt As Recordset


Dim Message As String

Dim strSelPh As String

Dim strSqlCdRpt As String
Dim strOpPath As String


strSelPh = Range("E8").Value
Range("e17").Value = " "

Set DbRpt = _
OpenDatabase("c:\Documents and
Settings\c18850\mvsa\rec04\RecRegistration.mdb")
MsgBox "Database opened"


Set RsRpt = DbRpt.OpenRecordset("combined_ph")
MsgBox "Recordset opened"

End Sub
--
Ron
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query from Access into Excel cause Access to go to read only T Stephens Excel Discussion (Misc queries) 0 March 24th 09 04:17 PM
When opening Excel - get Access (Read-Only) file and error DeltaDagger Setting up and Configuration of Excel 1 October 31st 06 10:22 AM
In EXCEL, access denied when deleting read only Richard G. Excel Discussion (Misc queries) 0 December 31st 05 05:54 PM
Sumproduct in Excel Spreadsheet to read Access db table Jules Excel Worksheet Functions 1 November 9th 04 02:50 PM
Read / compare MS Access data in excel Bob[_34_] Excel Programming 2 September 12th 03 03:02 AM


All times are GMT +1. The time now is 06:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"