SQL Server problem

This is my first foray into ASP and I'm having some difficulties setting up the forums.

For testing purposes i'm running IIS and Sql Server Express on my pc while i develop the site then will move it to a webhost when complete.

My problem is this error I get when i try and open the index.asp page after completing setup:

---------------------------

Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'tblDateTimeFormat'.

/functions/functions_date_time_format.asp, line 78

-----------------------------

the line mentioned is:

rsDateTimeFormat.Open strSQL, adoCon

The table 'tblDateTimeFormat' exists in the sql db, so whats the problem with it?

Is this the first place where the website connects to the website?

I'm completely lost here!

OK I searched threads and tested a few of the ideas i found.

If i setup the ForumUser account with DBO schema and access permissions I get the same error as above. If I give it Administrator access the forum works.

Any handy hints on why the DBO access wasn't working? I would really rather not have the user details sitting in code for an account with admin privileges for the db.