|
ISTech Support Forum
http://www.istechforum.com/YaBB.pl Crystal Reports, ODBC & Access >> Access General Issues >> Data Access in MS Access 2002 http://www.istechforum.com/YaBB.pl?num=1067295643 Message started by JamesTaylor on 10/27/03 at 15:00:43 |
|
Title: Data Access in MS Access 2002 Post by JamesTaylor on 10/27/03 at 15:00:43 Hi All, I have been using MS Access 2002 to attach (link) to DBA tables for the past 6 weeks with great success via ODBC. This morning, I tried to access a table I have already linked to, MTICMSTR and I receive this error message; “MTIC_PROD_SPECS[ 1] is not a valid name. Make sure that it doesn’t include invalid characters or punctuation and that it is not too long.” I have rebooted the server, CHKDSK'd it and run DISKEEPER (a defrag ustility). I have also re-indexed that particular file in DBA to no avail. The really wierd thing is I have used this exact configuration for 6 weeks without a problem. I can still access all the other files in DBA without a problem. Has anyone seen this eror B4 and can you help me fix it? Thanks! James Taylor http://www.AICompany.com Web Design, Web Hosting and Search Engine Optimization |
|
Title: Re: Data Access in MS Access 2002 Post by Tommy Johnson on 10/27/03 at 16:04:10 DBA is not very good at not allowing invalid data input sometimes. That in combination with constant betrieve issues can cause problems. I have not ran into that problem with Access. You might try dropping the table link and reattaching, but more than likey you have some bad data in that table. You might also try to use the DBA Maintain Database or export MTICMSTR to a text file, then scan that field for odd data. Then edit in DBA to correct. |
|
Title: Re: Data Access in MS Access 2002 Post by JamesTaylor on 10/27/03 at 16:29:04 Thanks Tommy, Is there a way to clean the table up in Bulk? Whenever I export to a text file, I get errors, that is why I use Access. I never change the data, only link to the tables and look at the data through queries. I have tried re-attaching to no avail as well. I will try to take a look at the physical data tonight to see if I can spot something. Thanks! |
|
Title: Re: Data Access in MS Access 2002 Post by aricon on 10/27/03 at 17:33:28 Instead of doing a link table, do it as a Pass-Through Query which you should then funnel to a Make-Table Query and then run your specific query off the the new table in Access that results from the make-table query. This has gotten us around almost all of the screwy data dictionary problems in DBA's non-standard data dict. formats. |
|
Title: Re: Data Access in MS Access 2002 Post by JamesTaylor on 10/29/03 at 15:27:28 Thanks! What eventually fixed it here was to replace all of the "File*" files except for the FILLOC files with the new ones off of the CD and then destroy and rebuild the ODBC drivers. Everything looks great after that. Thanks for your suggestions and patience. James A. Taylor Jr. http://www.AICompany.com web design, web hosting and search engine optimization |
|
Title: Pass-Through query failing Post by heliosquare on 02/24/04 at 13:36:54 aricon wrote:
Trying to do a Pass-through Query on BKARHIVL.B but the query is failing as Access is not able to dertermine what table I am trying to query. Code:
The above query gives me this error msg: ODBC--call failed Syntax Error: SELECT ...........FROM (#0) How do I get it to realize what table I want? |
|
Title: Re: Data Access in MS Access 2002 Post by heliosquare on 02/24/04 at 14:05:39 Figured out my syntax error. Should have been: Code:
|
|
Title: Re: Data Access in MS Access 2002 Post by aricon on 02/24/04 at 23:15:09 You know....the questions where someone answers their own question are the BEST ones..... ;D (Really easy, ya know....LOL!!) |
|
ISTech Support Forum » Powered by YaBB 2.1! YaBB © 2000-2005. All Rights Reserved. |