Error: Reference to a non-shared member requires an object reference.

[Everton1Blue]

Hello

I am trying to create a log-in page (MS Access) for the first time, and I am getting this error (among others!):

Dim conn As New OleDbConnection(ConnectionString)

Compilation Error: BC30469: Reference to a non-shared member requires an object reference.

The error (blue underline) specifically refers to 'ConnectionString'.

Aren't I saying that OleDbConnection = ConnectionString, and isn't that correct?

Thanks!

 

[Everton1Blue]

This is resolved now.

Cheers!

 

[SkipVought]

...and you resolved it how?

Other members who browse these forums want to know how you resolved your issue(s). Tek-Tips is not a one-way street. We ask questions and share solutions.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Everton1Blue]

The problem was not 'ConnectionString' as such, but the line above it. The error disappeared when I used:

Dim ConnectionString As String = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=|DataDirectory|students.mdb;"

        Dim conn As New OleDbConnection(ConnectionString)

That is, I had not declared 'ConnectionString'
Hope this helps.