Tables inaccessible

[Kherozen]

Hi, I just transfer my Database from my computer(with a Sql server on it) to the server (with SQL server on it too) I got access to it that's ok I can play with the forms and data. but I can't open most of the tables, there's no Error message most of the time but some tables show that message "the field index is read-only" any ideas what could cause that?! if I reconnected the db to the SQL server on my computer, tables open fine ...


jul ^_^
"Computer Science is no more about computers than astronomy is about telescopes"
E. W. Dijkstra.

 

[smedvid]

Most likely a permissions issue on the new SQL Server. Check USer ID and Roles assigned. Can the User ID SELECT, INSERT, UPDATE against the tables? htwh,

Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[Kherozen]

Well I got some query in the form ( custom search form) and they are working fine ...
and it's weird, I got some table opening fine but that's like the none related one( tables that list things,etc...)
so I thought the commun denominator was the "Project-related" tables but there's one that open ...weird



jul ^_^
"Computer Science is no more about computers than astronomy is about telescopes"
E. W. Dijkstra.

 

[Kherozen]

hum I got a new error message
which doesn't make sense to me

when I double-click on a table to open it it something give me that message : The StoredProcedure executed successfully but didn't return any result

oh yeah that make me think ... the tables are empty
no data in it yet.


jul ^_^
"Computer Science is no more about computers than astronomy is about telescopes"
E. W. Dijkstra.