Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking Foxpro table in Access 2000

Status
Not open for further replies.
nanic

nanic

IS-IT--Management
Dec 11, 2001
5
CA
I am using Access 2000 and linking to 20 foxpro tables (foxpro 3.0b). These are corporate tables and properties cannot be modified. My problem is as follows:

any foxpro tables that have blank date/time field get converted to december 30, 1899 in Access 2000. Never had this problem with Access 97. Is there a way of fixing this?
 
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Field size limit Access 365
Replies
5
Views
2K
TrekBiker
TrekBiker
raywood1
  • Locked
  • Question
Reducing a Massive Linked Table
Replies
4
Views
428
dhookom
dhookom
Anthony343242
  • Locked
  • Question
MS ACCESS UNION ALL with Attachment data type 1
2
Replies
29
Views
3K
Anthony343242
Anthony343242
03Explorer
  • Locked
  • Question
Refreshing a linked table (housed on MS SQL Server) now breaks
Replies
3
Views
333
dhookom
dhookom
JayRo71
  • Locked
  • Question
Importing only unique records from excel tables 1
Replies
10
Views
523
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top