> Help!!!!

> 

> The following statement produces the error message that also follows:

>  objRS1.Open "SEGMENT_INS", strConnect, adOpenForwardOnly, 

adlockReadOnly, 

> adCmdTable

> 

> I am able to open other tables and I have tried various things like 

making 

> a new table and porting some data into it.  No matter what, the same 

> message keeps re-occurring.  I think I have the right permissions set.  

> Please identify for me the reason and thank you for the resolution.

> 

> 

> Error Type:

> Microsoft OLE DB Provider for SQL Server (0x80040E37)

> Invalid object name 'SEGMENT_INS'.

> /BTTC/WebSite/BTTC folder/BTTC/Pages/CheckAccess.asp, line 47

> 

Try owner.Table in your SQL statement....



p. ej,      "SELECT * FROM JSmith.Clients"





I hope it helps you



Sergio Q.