Hi,
I'm getting the datetime field overflow error using odbc to connect to an
sql database from access. This happens when I try to enter the date
13/01/1899. It did happen when using smalldatetime, which apparently does
have that problem of only going as far back as 1900, but since changing to
datetime the error still pops up.
Is there anything I can do?
Cheers,
Chris
6  6497 
After you change the datatype to datetime in SQL Server you need to refresh
the linked table in Access.
Terry
"Not Me" <No****@faker.f ake.fa.ke> wrote in message
news:bv******** **@ucsnew1.ncl. ac.uk... Hi,
I'm getting the datetime field overflow error using odbc to connect to an
sql database from access. This happens when I try to enter the date
13/01/1899. It did happen when using smalldatetime, which apparently does
have that problem of only going as far back as 1900, but since changing to
datetime the error still pops up.
Is there anything I can do?
Cheers,
Chris
Thanks, but that didn't work :o( still get the conversion errors
Cheers,
Chris
"Terry Kreft" <te*********@mp s.co.uk> wrote in message
news:aI******** ************@ka roo.co.uk... After you change the datatype to datetime in SQL Server you need to
refresh the linked table in Access.
Terry
"Not Me" <No****@faker.f ake.fa.ke> wrote in message
news:bv******** **@ucsnew1.ncl. ac.uk... Hi,
I'm getting the datetime field overflow error using odbc to connect to
an sql database from access. This happens when I try to enter the date
13/01/1899. It did happen when using smalldatetime, which apparently
does have that problem of only going as far back as 1900, but since changing
to datetime the error still pops up.
Is there anything I can do?
Cheers,
Chris
Strange it worked here.
Which version of Access / SQL are you using ?
Terry
"Not Me" <No****@faker.f ake.fa.ke> wrote in message
news:bv******** **@ucsnew1.ncl. ac.uk... Thanks, but that didn't work :o( still get the conversion errors
Cheers,
Chris
"Terry Kreft" <te*********@mp s.co.uk> wrote in message
news:aI******** ************@ka roo.co.uk... After you change the datatype to datetime in SQL Server you need to refresh the linked table in Access.
Terry
"Not Me" <No****@faker.f ake.fa.ke> wrote in message
news:bv******** **@ucsnew1.ncl. ac.uk... Hi,
I'm getting the datetime field overflow error using odbc to connect to an sql database from access. This happens when I try to enter the date
13/01/1899. It did happen when using smalldatetime, which apparently does have that problem of only going as far back as 1900, but since
changing to datetime the error still pops up.
Is there anything I can do?
Cheers,
Chris
SQL 8, Access 2002.... I guess the problem must be hiding someplace else..
cheers,
Chris
"Terry Kreft" <te*********@mp s.co.uk> wrote in message
news:Ls******** ************@ka roo.co.uk... Strange it worked here.
Which version of Access / SQL are you using ?
Terry
"Not Me" <No****@faker.f ake.fa.ke> wrote in message
news:bv******** **@ucsnew1.ncl. ac.uk... Thanks, but that didn't work :o( still get the conversion errors
"Terry Kreft" <te*********@mp s.co.uk> wrote in message
news:aI******** ************@ka roo.co.uk... After you change the datatype to datetime in SQL Server you need to
refresh the linked table in Access.
"Not Me" <No****@faker.f ake.fa.ke> wrote in message
news:bv******** **@ucsnew1.ncl. ac.uk...
> Hi,
>
> I'm getting the datetime field overflow error using odbc to connect
to an > sql database from access. This happens when I try to enter the date
> 13/01/1899. It did happen when using smalldatetime, which
apparently does > have that problem of only going as far back as 1900, but since
changing to > datetime the error still pops up.
>
> Is there anything I can do?
SQL Server 2000 and Access XP, those are the same versions I used to test
this.
Hmm, strange.
I'd suggest you go back and check through the steps again.
Make sure the field type on SQL is now datetime
Go into Access and use the Tools/Database Utilities/Linked Table Wizard
to refresh the link
Test whether you can add the data through the table
Terry
"Not Me" <No****@faker.f ake.fa.ke> wrote in message
news:c0******** **@ucsnew1.ncl. ac.uk... SQL 8, Access 2002.... I guess the problem must be hiding someplace else..
cheers,
Chris
"Terry Kreft" <te*********@mp s.co.uk> wrote in message
news:Ls******** ************@ka roo.co.uk... Strange it worked here.
Which version of Access / SQL are you using ?
Terry
"Not Me" <No****@faker.f ake.fa.ke> wrote in message
news:bv******** **@ucsnew1.ncl. ac.uk... Thanks, but that didn't work :o( still get the conversion errors
"Terry Kreft" <te*********@mp s.co.uk> wrote in message
news:aI******** ************@ka roo.co.uk...
> After you change the datatype to datetime in SQL Server you need to
refresh
> the linked table in Access.
>
> "Not Me" <No****@faker.f ake.fa.ke> wrote in message
> news:bv******** **@ucsnew1.ncl. ac.uk...
> > Hi,
> >
> > I'm getting the datetime field overflow error using odbc to
connect to an
> > sql database from access. This happens when I try to enter the
date > > 13/01/1899. It did happen when using smalldatetime, which
apparently does
> > have that problem of only going as far back as 1900, but since
changing to
> > datetime the error still pops up.
> >
> > Is there anything I can do?
I think the SQL requires US-format for dates: mm/dd/yyyy and it may be
choking up on a thirteenth month.
Larry Linson
Microsoft Access MVP
"Not Me" <No****@faker.f ake.fa.ke> wrote in message
news:c0******** **@ucsnew1.ncl. ac.uk... SQL 8, Access 2002.... I guess the problem must be hiding someplace else..
cheers,
Chris
"Terry Kreft" <te*********@mp s.co.uk> wrote in message
news:Ls******** ************@ka roo.co.uk... Strange it worked here.
Which version of Access / SQL are you using ?
Terry
"Not Me" <No****@faker.f ake.fa.ke> wrote in message
news:bv******** **@ucsnew1.ncl. ac.uk... Thanks, but that didn't work :o( still get the conversion errors
"Terry Kreft" <te*********@mp s.co.uk> wrote in message
news:aI******** ************@ka roo.co.uk...
> After you change the datatype to datetime in SQL Server you need to
refresh
> the linked table in Access.
>
> "Not Me" <No****@faker.f ake.fa.ke> wrote in message
> news:bv******** **@ucsnew1.ncl. ac.uk...
> > Hi,
> >
> > I'm getting the datetime field overflow error using odbc to
connect to an
> > sql database from access. This happens when I try to enter the
date > > 13/01/1899. It did happen when using smalldatetime, which
apparently does
> > have that problem of only going as far back as 1900, but since
changing to
> > datetime the error still pops up.
> >
> > Is there anything I can do?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: fowlertrainer |
last post by:
Hi !
I think that I have been found a bug in mx.DateTime...
So:
I use FireBird, and in this RDBMS the datetime fields are "doubles".
So if I set them to 0, the values the fields are '1899-12-30 01:00:00'.
When I try to see this datetime as European format (YYYY.MM.DD HH:MM:SS)
I get error.
|
by: MGRIDEOUT |
last post by:
Hello ,
I have a sub that gets all records in a table. Then displays the
times in a drop-down list (ddlStartTime). My problem is that the ddl contain
the date AND time. i.e. 9:00 AM in the table is 1/1/1899 9:00:00 AM in the
ddl.
How do I get JUST the Time in format 9:00 AM??
Please I have been at this now for over 2 days and I can't seem to get
|
by: Mark |
last post by:
I feel embarassed asking such a simple question ---
Year(Date()) returns 2004; I want only the last two digits.
Format(Year(Date()),"yy") returns 05. How do I get 04?
Thanks!
Mark
|
by: La di da Limey |
last post by:
Hi,
I have a field in a database called "Timestamp" which has the date and time
of an event, for example:
"01/02/2002 09:07:59"
The format is MM/DD/YYYY HH:MM:SS
I want to chop the field into six seperate fields of MM, DD, YYYY, HH, MM &
|
by: A.M |
last post by:
Hi,
I know we can assigne year, month and day to a DateTime value by the
constructor like
Dim dt As DateTime = New DateTime(2003,8,1)
How can i assign value by year, month and day? I am looking for a function
like this:
| | |
by: rs |
last post by:
I have a table with a timestamp field which contains the date and time. ie.
9/13/2004 9:10:00 AM.
I would like to split this field into 2 fields, one with just the DATE
portion ie 9/13/2004
and the other with just the TIME portion. ie 9:10:00 AM.
I can make the table view display what I want by placing the same data in 3
fields and setting the display property to 'General Date',' Medium Time' and
'Short Date' but the underlying data...
|
by: Mohan |
last post by:
In the database, we are storing time in 3 columns: hours, Minutes and
AM,PM.
After retrieving it from the database, I want to load these values into
a DateTime variable. I haven't had much success.
I would appreciate if anyone can help me in this matter
thank you
MB
|
by: Pablo |
last post by:
Hello,
I have big problem with method ParseExact from class DateTime.
Here is code sample:
'-----------------------------------------------------------------------------------------------------------------------------------------
Module Module1
Sub Main()
Console.WriteLine("Start...")
Try
|
by: drurjen |
last post by:
Good morning.
I am importing an XLS file into one of my tables. The fields are:
Date Id Time IO
12/22/2006 2 12:48:45 PM 9
12/22/2006 16 5:40:55 AM 1
12/22/2006 16 12:03:59 PM 2
When I do the import, I get the following:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
