navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

Unable to retrieve schema information

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Unable to retrieve schema information
Page: [1]
 
TaoEntropy

 

Posts: 30
From: Chicago, IL, 60646
Status: offline

 
Unable to retrieve schema information - 11/6/2001 18:06:00   
What are some of the possible reasons why i might recieve this error?

Server error: Unable to retrieve schema information from the record source 'Date' in a database using the connection string:

'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/ScheduleTablesAllObjectsNoGrpSecurity.mdb'.

The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)


I searched through some of the archives and I see that you helped people with this problem when their tables were named incorrectly, but my table is named Date and other tables and queries in the same database work fine.

Thanks again for your help.

Mojo

 

Posts: 2441
From: Chicago
Status: offline

 
RE: Unable to retrieve schema information - 11/6/2001 19:11:00   
Date is a reserved word in Access. Try changing that and see if it helps.

Joe


(in reply to TaoEntropy)
TaoEntropy

 

Posts: 30
From: Chicago, IL, 60646
Status: offline

 
RE: Unable to retrieve schema information - 11/6/2001 21:29:00   
yep! That's it. You guys are amazing. I can't thank you enough.

James


(in reply to TaoEntropy)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Unable to retrieve schema information
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts