Forum Moderators: open
CREATE TABLE [dbo].[Fail-Status] (
[ID] [nvarchar] (20) COLLATE NOT NULL ,
[Row (X)] [nvarchar] (50) COLLATE NULL ,
[Column (Y)] [nvarchar] (50) NULL
And yes, those are spaces in the column names. Between spaces, parenthesis, and about 40 tables with [ID] as a column name, I've pulled a lot of hair out since taking over this project. And just for the record, I did NOT design this database.
Thanks in advance for any input.
If the parens and spaces do become an issue, I thought about creating queries in Access which have the same names as original tables. Then I could rename the tables and columns as needed and use aliases to keep things from breaking. But I'll cross that bridge when I come to it.