SQL Server

[Jay]

Sorry if this is the wrong place to post this.

I am using Access/SQL server and have a problem with SQL Server.

I can not make a new table, or design any table because I get an ODBC error
207 that states I have four invalid column names. Invalid column name status,
constid, id and status (again). It says this same message for ANY table I try
to design. I did a restore from before this started and it still happens. I
am at a stand still if any one can provide me direction. Thank you

 

[Arvin Meyer [MVP]]

Have you tried building the tables in SQL-Server, then connecting to them
with ODBC?

 

[Jay]

What is strange is this just started last Friday, I am using to Enterprise
Manager to design or create any table, Not though access at all. and it gives
me the same error
of

Table (What evertable I am trying to design) could not be loaded
ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] invalid column
name 'status'. [Microsoft][ODBC SQL Server Driver][SQL Server] invalid column
name 'constid'. [Microsoft][ODBC SQL Server Driver][SQL Server] invalid
column name 'id'. [Microsoft][ODBC SQL Server Driver][SQL Server] invalid
column name 'status'.

I can also no view any of my diagrams or make any SQL scripts.

Thank you.

 

[Arvin Meyer [MVP]]

Enterprise Manager doesn't use ODBC, so the error is within SQL-Server
itself. My guess is a permissions error. If not, you should be directing
further questions to a SQL-Server newsgroup.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

What is strange is this just started last Friday, I am using to Enterprise
Manager to design or create any table, Not though access at all. and it
gives
me the same error
of

Table (What evertable I am trying to design) could not be loaded
ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] invalid column
name 'status'. [Microsoft][ODBC SQL Server Driver][SQL Server] invalid
column
name 'constid'. [Microsoft][ODBC SQL Server Driver][SQL Server] invalid
column name 'id'. [Microsoft][ODBC SQL Server Driver][SQL Server] invalid
column name 'status'.

I can also no view any of my diagrams or make any SQL scripts.

Thank you.





--
Jay

Have you tried building the tables in SQL-Server, then connecting to them
with ODBC?

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com