Posted by Yoda on 11/22/07 13:29

Hi,
i'm working on a project for convert from a mdb AccessXP(2002)
application backend to SQL Server Express 2005.

In the past i convertend a similar backend to SQL Server 2000.

My problem is: I have many fields on mdb backend with spaces in field
name (i know bad thing)

With SQL Server 2000 I had no problem because it recognize the field
correctly with syntax [field name]

but now with SQL Server Express 2005 i'm experiencing problems....in
fact it wants to write the field in this way 'field name'.

Now...what do u suggest me?

Go back to SQL Server 2000 or change all the field names? this is
because with the character ' apex i have many problem in SQL syntax.

Thank u in advance

Bye
Rob

• Next in forum: Re: SQL neewbie - looking for windows front-end app for SQL database backend
• Prev in forum: Re: using modify table command
• Thread view: Upsize from mdb to SQL Express 2005

[Reply to this message]