|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Friday, February 22, 2013 9:30 PM
Points: 912,
Visits: 198
|
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 10:43 AM
Points: 287,
Visits: 213
|
|
I ran into a problem several years ago with the upsizing wizard. I don't remember the exact details but it had something to do with date/time fields. The problem was either caused by SQL Server having a more limited range of dates available in the datetime field that Access has in its equivalent or the Upsizing Wizard chose the smalldatetime when it should have picked the datetime data type. Regardless of the cause, the result was overflow-type errors when the wizard ran. So, if you run into errors like this, look at the data fields in the table that errors out and you'll probably find some data that won't fit into SQL Server for one of the above reasons.
Bryant E. Byrd, BSSE MCDBA MCAD Business Intelligence Administrator MSBI Administration Blog
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, March 13, 2006 9:44 AM
Points: 1,
Visits: 1
|
|
This article has useful information, but aren't there article editors at SQL Server Central that review articles before they are posted for public consumption? The grammar is this article is very stilted, and in some cases completely inaccurate, making it difficult to read. While I certainly don't fault the author for not being totally fluent in English, I do think it reflects badly on the quality of the site. Even a cursory read-through should have resulted in the vast majority of mistakes being fixed by an editor.
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Thursday, June 04, 2009 1:56 AM
Points: 2,
Visits: 4
|
|
| Have read about six articles on this over the years. The English in this article is weak, but a lot better than my Chinese. The writer has done a good job of summarising the issues and two available upsizing tools with lots of practical information. Thanks to him for writing it. It helps.
|
|
|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: 2 days ago @ 11:14 AM
Points: 440,
Visits: 478
|
|
The one that I found in upgrading is that the Yes/No has to translate to the smallint (not bit) if you are front-ending with Access 97. It may have changed in Acc2K. But the values for boolean field are 0 and -1. The bit is 0 to 255 with no negatives.
---------------- Jim P.
A little bit of this and a little byte of that can cause bloatware.
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 10:43 AM
Points: 287,
Visits: 213
|
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Friday, February 22, 2013 9:30 PM
Points: 912,
Visits: 198
|
|
Very sorry for my porr english. I try to minize those in my next articles. Thank you very much for the comments. Its really helps me
My Blog: http://dineshasanka.spaces.live.com/
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Tuesday, May 07, 2013 10:43 AM
Points: 287,
Visits: 213
|
|
No need to apologize, we all appreciate your effort and contribution to the community. I think Dave was a little harsher than he intended and his criticism was primarily aimed at our generous hosts. I think we need to step back and consider what has gone into building this community and give credit to our hosts for all the time and money they have put into this so that we can all benefit at no cost to us. I am sure that if some folks want to volunteer their time to do the proofreading the SQLServerCentral guys woud love the help. Thanks Dinesh, keep the articles flowing!
Bryant E. Byrd, BSSE MCDBA MCAD Business Intelligence Administrator MSBI Administration Blog
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Friday, February 22, 2013 9:30 PM
Points: 912,
Visits: 198
|
|
Thankx Tatsu
My Blog: http://dineshasanka.spaces.live.com/
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Wednesday, February 21, 2007 2:03 AM
Points: 3,
Visits: 1
|
|
| As I understand it, Access IS a RDBMS, but it is based on the JET engine rather than SQL and is only intended for a small number of users. Please correct your article, which states that Access is a "flat file" database.
|
|
|
|