6 messages in com.mysql.lists.win32Re: Table name problem
FromSent OnAttachments
Ata ur Rehman04 Oct 2006 23:49 
Tata Respecia05 Oct 2006 00:27 
Randy Clamons05 Oct 2006 11:04 
Charles Mabbott05 Oct 2006 14:07 
Chuck05 Oct 2006 14:23 
Armando05 Oct 2006 17:54 
Subject:Re: Table name problem
From:Armando (diji@shaw.ca)
Date:10/05/2006 05:54:29 PM
List:com.mysql.lists.win32

Access allows you to do all sorts of things that you shouldn't be allowed to do where databases are concerned. When it allows you to make a column named '+/-' you know there's going to be trouble if you ever try to move the data into another platform.

Simple rule of thumb, the only special character you should ever use is an underscore. It will save you tons of headache. Cheers.

Armando

Charles Mabbott wrote:

Can I suggest using the '_' for example Book_Record

Because spaces in Access are treated internally a little Different. Look at the queries in SQL mode and you'll see what I mean. The easiest way is use the '_' rather than a a space.