"segue" wrote:

>
> Thank you for your responses.
>
> I'm now getting the error:
> System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot
> find the input table or query 'Reports'. Make sure it exists and that its
> name is spelled correctly.
>
> From:
>
> Dim olestring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=c:\db\db2000_1_client.mdb;Persist Security Info=False;"
> Dim qstring As String = "SELECT * FROM Reports" ' & pwTable & ""
>
> "Michael Nemtsev [MVP]" wrote:
>
> > Hello segue,
> >
> > Are u sure that u are using the right connection string? U can check it there
> > http://connectionstrings.com/
> >
> > I recommend u to use the following OLEDB sample how to work with Access DB
> > in C# http://msdn2.microsoft.com/en-us/library/aa288452(VS.71).aspx
> >
> > ---
> > WBR,
> > Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour
> >
> > "The greatest danger for most of us is not that our aim is too high and we
> > miss it, but that it is too low and we reach it" (c) Michelangelo
> >
> >
> > s> I'd greatly appreciate suggestions on a better method for cursing
> > s> through access database tables or why I'm getting the following error
> > s> at oleConnection.Open().
> > s>
> > s> Do I need an odbc syntax instead of oledb?
> > s> Much thanks.
> > s> System.Data.OleDb.OleDbException: The database has been placed in a
> > s> state on machine 'IO' that prevents it from being opened or locked.
> > s>
> > s> Dim olestring As String =
> > s> "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > s> Source=c:\db\db2000_1_client.mdb"
> > s> Dim qstring As String = "SELECT * FROM " & aTable & ""
> > s> Try
> > s>
> > s> oleConnection = New OleDbConnection(olestring)
> > s> 'oleDataAdapter = New oledataadapter
> > s> oleConnection.Open()
> >
> >