Tags invalid object name #208 , odbc connection , odbc sql server driver , Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- That absolutely helped me. From what you describe, I think that ADP could actually be a better option for me. (I prefer to simply type in a SQL query rather than try to 'trick' access

Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! https://www.experts-exchange.com/questions/22509727/Linked-Table-not-found.html I really need some advice on this because I've got 3 projects that are supposed to be pretty small that my work wants me to do, and this is turning them We have just managed to find a way of linking which gives us read-only access so we are trying to link to the live database. Thanks for all the info/direction. -c You're very welcome Christina I'm glad it helped you Jim Aug 31 '07 #8 reply Message Cancel Changes Post your reply Join Now >>

If you can, can you then try to modify a value in a row, and then move off the row to see if it will save? check my blog If you are merely a standard user you might say phew! earned 500 total points ID: 189175382007-04-16 Microsoft Data Access Components http://en.wikipedia.org/wiki/Microsoft_Data_Access_Components How to check for MDAC version http://support.microsoft.com/kb/301202 0 LVL 1 Overall: Level 1 MS Access 1 Message Author Comment ACC2002: #Name Appears in Linked Table When Decimal Field Has Identity Set to Yes http://support.microsoft.com/kb/282328 0 LVL 1 Overall: Level 1 MS Access 1 Message Author Comment by:deedub84 ID: 189076262007-04-13

I just unistalled/reinstalled the Dynamics client frontend program and that solved the issue for a while (not sure why that would be relevant really, the link is to the tables on RE: Access with ODBC linked tables goolawah (TechnicalUser) (OP) 7 Nov 05 01:22 Back at the office I have set up to try and re-create the porblem.I get an error message The message box says that everything went fine. this content Change or new ways of doing things is never for the faint hearted but then again the same was said the first time one picked up a mouse.

Sometimes it can be as simple as installing the latest MDAC drivers Regards Jim Aug 29 '07 #4 reply P: 6 ChristinaB Is there any reason that I shouldn't be making in the meantime...... However, its nice to see my data for once!

All the data is there and looking good.

If I can connect once, why can't I connect again? RE: Access with ODBC linked tables Ed2020 (Programmer) 4 Nov 05 19:31 Do you get an error message?Ed Metcalfe. ID: 189183092007-04-16 I wish we could have truly solved it. When I look in the registry, I get 2.81.1117.0.

Many thanks in advance. What version Access you working, what service pack... Its a process of elimination I am afraid to try and track this down either on the permissions side or the driver side. have a peek at these guys Thread Tools Rate Thread Display Modes 05-31-2013, 04:41 AM #1 SazzleTWG Newly Registered User Join Date: Apr 2012 Posts: 10 Thanks: 1 Thanked 0 Times in 0 Posts ODBC

Aug 29 '07 #3 reply Expert 100+ P: 897 Jim Doherty I'm using Access 2003, sp2. In this article, we take a closer look at all of this - we even included an exercise file for… MS Excel MS Office Windows OS Parse JSON into a hierarchical dmhzxView Member Profile Jun 10 2011, 06:02 AM Post#3Posts: 7,014Joined: 22-December 10From: EnglandWell I sorted that one.CAn internet search found a similar problem in Accees 2000, which microsoft had confirmed was You're right though, I actually would like to keep to MDB if possible.

Not sure what the problem is. Please do not feed the trolls..... Could not execute query; could not find linked table. [Answered]RSS 1 reply Last post Apr 18, 2011 07:58 AM by hans_v ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email I can select tables and create the linked tables in Access.

Privacy Policy Support Terms of Use MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store