Database

I am using VB.Net and have recently started working with databases. I hae managed to connect to and manipulate databases done in access that hae already been built, but I am currently trying to use a database I have built but get errors when I try to generate a dataset. The error reads "Retreiving the schema for OleDbDataAdapter1 failed. IErrorInfo.GetDescription failed with E_FAIL(0x80004005)" I think it has something to do with how I am building the database, all I hae done is create a new database and put a table in it with the headings that I require. I wold be greatfull if anyone cold tell me what else I need to do to the database to make it work.

<br />
public void ExecuteStoredProcedure(string pStoredProcedureName, <br />
                                       object[] pReturnValue)<br />
    {<br />
      if(dbConnection.IsConnected())<br />
      {<br />
        bool outputValue = false;<br />
        command.Parameters.Clear();<br />
        try<br />
        {  <br />
        foreach(IDbDataParameter parameter in parameterCollection)<br />
        {<br />
          if(parameter.Direction != ParameterDirection.Input)<br />
            outputValue = true;<br />
          command.Parameters.Add(parameter);      <br />
        }<br />
        command.CommandText = dbConnection.FormatStoredProcedureCall<br />
                                                           (pStoredProcedureName, <br />
                                                            command.Parameters);<br />
<br />
        //command.CommandType = System.Data.CommandType.StoredProcedure;           <br />
	if(outputValue)<br />
	{<br />
		IDataReader reader = command.ExecuteReader();<br />
		reader.Close();         <br />
						<br />
		int count = 0;<br />
					  <br />
		foreach(IDbDataParameter parameter in command.Parameters)<br />
		{<br />
			Console.WriteLine("Parameter value:" + parameter.Value.ToString());<br />
<br />
			if(parameter.Direction != ParameterDirection.Input)<br />
			{<br />
				pReturnValue[count] = parameter.Value;<br />
				count++;<br />
			}<br />
		}  <br />
	}<br />
	else<br />
		command.ExecuteNonQuery();<br />
        }<br />
        catch(Exception e)<br />
        {<br />
          throw new DbException(ErrorMessage.INVALID_METHOD);<br />
        }       <br />
        parameterCollection.Clear();<br />
      }<br />
      else<br />
        throw new DbException(ErrorMessage.NOT_CONNECTED);<br />
    }<br />

public static string NewId(ICommand pCommand, int pModuleId)<br />
{<br />
        string sqlStatement = "NewRecordId";<br />
	object[] id = new object[1];	<br />
        try<br />
        {		<br />
	  pCommand.DefineParameter("pReturnValue", <br />
	  			  DbType.String, <br />
				  null, <br />
				  ParameterDirection.ReturnValue, <br />
				  30);<br />
	  pCommand.DefineParameter("pCurrentDate", <br />
				  DbType.DateTime, <br />
				  DateTime.Now);<br />
	  pCommand.DefineParameter("pNewId", <br />
				  DbType.String, <br />
				  Guid.NewGuid().ToString());<br />
  	  pCommand.ExecuteStoredProcedure(sqlStatement, id);            <br />
	<br />
	  if (id[0].ToString().Length != 30)<br />
		throw new DatabaseLayerException("Genearated Id doesn't have 30 digits.");<br />
      }<br />
      catch(Exception e)<br />
      {<br />
	throw new DatabaseLayerException("LCMS5000", e.Message);<br />
      }<br />
			<br />
			return(pModuleId.ToString() + id[0].ToString());<br />
		}