Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BlueBell
Starting Member
4 Posts |
 Posted - 2013-12-18 : 08:09:00
|
| I have upsized an access database and the date fields were set as DATE/TIME fields in the format of shortdate mm/dd/yy input masks of 99/99/00;0having upsized all the queries/forms which involve dates are giving me OBDC errors as the date format has changed to datetime2 with the format of year first followed by the time.Is there something I should do to the tables prior to/during upsizing to ensure that the date is kept in the original formatMany thanks |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-12-18 : 10:33:12
|
| in sql server format is not applicable to storing date related data types. format is only applicable to displaying the values and for converting string representations of dates to datetime2 values. I have a feeling you may need an Access person to help with your ultimate solution but in the meantime, please post the specific error you are getting. And if possible post the code that generated the error.EDIT:I see you're posting a lot of Upsizing questions recently. I assume you've seen this:http://office.microsoft.com/en-in/access-help/move-access-data-to-a-sql-server-database-by-using-the-upsizing-wizard-HA010275537.aspxwhich of the three methods are you using to perform the upsizing?Be One with the OptimizerTG |
 |
|
|
|
|
|
Dates