System.NullReferenceException

[proteome]

I continue to get the above mentioned error even though the file is located where it is supposed to be. My code is listed below.

Dim ws As DAO.Workspace
Dim db As DAO.Database

Try
db = ws.OpenDatabase("C:\LogIn_Samples.mdb")
Catch f As NullReferenceException
Throw New NullReferenceException("The database could not be found!!", f)
End Try

Does anyone have any suggestions. Please forgive me if this has already been answered but the search dialog is down at the moment

Thanks

 

[JohnYingling]

You are getting the exception on ws because DAO.Workspace has no reference in it.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing

http://www.VBCompare.com

Compare Code

http://www.VBSortGen.com

Generate Sort Class in VB

http://www.Vbcompare.com/Check.Htm(1979

Check To MS)

 

[proteome]

Could you please explain a bit further by what you mean

"DAO.Workspace has no reference

 

[JohnYingling]

Dim ws As DAO.Workspace ' ws = Nothing
There is no instance of a DAO.WorkSpace object in ws, just space for the reference. Somebody has to create an instance of a DAO.WorkSpace.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing

http://www.VBCompare.com

Compare Code

http://www.VBSortGen.com

Generate Sort Class in VB

http://www.Vbcompare.com/Check.Htm(1979

Check To MS)

 

[chiph]

In other words, create a new Workspace using the "new" keyword. You've reserved memory for a Workspace, but haven't actually populated it with one.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first