February 9, 2010 at 1:17 pm
I am trying to move an access table to an SQL server and use the existing form. With Access the textbox controls are not padded, with SQL the textbox is padded to MAX field size so adding text becomes a DELETE old or switch to overtype... neither is user friendly. Does anyone know how to have the Access form work without having the fields padded?
February 9, 2010 at 5:51 pm
Did you perhaps define your SQL columns to be CHAR instead of varchar? Char is a fixed length column, so it will pad out the column to the defined length.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
February 10, 2010 at 8:52 am
Bingo, thanks... missed the obvious....
February 11, 2010 at 11:46 am
I have preformed many Access to SQL server and Oracle Conversions.
I would suggest that you do not use a migration wizard.
You should carefully examine the differences in the data types between SQL Server and Micorsoft Access.
You should not rely upon a migration wizard ti do the work for you whether it be the back end Database or the Front End.
You need at least a three tier or an N-Tier .NET Application and a Database that is in a 3rd normal form. Many Access databases are created by novicesi and the databases that they create are 1st or 2nd normal form at best.
Please exercise with caution.
Do not take any shortcuts in your migration strategy.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply