Ms Access Linked Table Manager Application-defined Or Object-defined Error
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Application-defined or object-defined error Want to Advertise Here? Solved Application-defined or object-defined error Posted on 2008-07-02 MS Access 1 Verified Solution 10 Comments 1,211 Views Last Modified: 2011-10-19 When we try to relink a View (from an Oracle database) via the Linked Table Manager in MS-Access97, we get error "Application-defined or object-defined error". It takes about 60 seconds for the error to show. The view would take a bit longer than 60 seconds. Is there an ODBC timeout somewhere that can be reconfigured, it is this unrelated to a timeout? 0 Question by:abrusko Facebook Twitter LinkedIn Google LVL 30 Active today Best Solution byhnasr < "Application-defined or object-defined error".> This error is not related to ODBC, I got it when using a local database in access. So few things to try, !!!!!!!!!!!!!!!!!(Backup-Backup) 1 Create Go to Solution 10 Comments LVL 30 Overall: Level 30 MS Access 28 Message Active today Expert Comment by:hnasr2008-07-03 Poosible reason, an oracle user modifies the object (table or view) by dropping and recreating! This was an issue when using Oracle Forms! 0 LVL 3 Overall: Level 3 Message Author Comment by:abrusko2008-07-03 This View was indeed modified, but it works fine (eg. via SqlPlus). But, relinking it in MS-Access97 generates the error. The schema owner is the one doing the relinking, so the error doesn't make sense. It's a fairly complex View... it uses other views and returns about 1.5M rows after chugging away for about 8 minutes. So, a timeout setting is suspect since t
Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 10-02-2013, 05:09 AM #1 Bilal Newly Registered User Join Date: Sep 2013 Posts: 64 Thanks: 28 Thanked 0 Times in 0 Posts Application-defined or object defined error Ive been having this problem for a few hours now, i cant seem to figure out what the problem or where the problem is for that matter. after https://www.experts-exchange.com/questions/23535023/Application-defined-or-object-defined-error.html the error comes up the form automatically opens up and access takes me out of the VBA section, its really frustrating and i would really apreciate it if somebody could help me. Bilal View Public Profile Find More Posts by Bilal 10-02-2013, 05:21 AM #2 pr2-eugin Super Moderator Join Date: Nov 2011 Location: Bournemouth, UK Posts: 8,496 Thanks: http://www.access-programmers.co.uk/forums/showthread.php?t=254428 68 Thanked 2,050 Times in 2,003 Posts Re: Application-defined or object defined error Okay a bit more information might be handy, At what point did this error occur? When opening the file/Adding a new form? What did you do different since the application worked without any error? Have you tried Compact & Repair? Did you try Compiling the Code for any un handled exception/compiler error? __________________ Regards, Paul Eugin To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. !! Windows 7 Professional, MS Access 2010 --------------------------------------------------------------------------------------------------------------------- If the above post has helped you, please click the scales To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. or click the 'Thumbs up'. Cheers. --------------------------------------------------------------------------------------------------------------------- The Following User Says Thank You to pr2-eugin For This Useful Post: Bilal(10-02-2013) pr2-eugin View Public Profile Visit pr2-eugin's homepage! Find More Posts by pr2-eugin 10-02-2013, 05:53 AM #3 Bilal Newly Registered User Join Date: Sep 2013 Posts: 64 Thanks: 28 Thanked 0 Times in 0 Posts Re: Application-defin
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums http://www.tek-tips.com/viewthread.cfm?qid=913585 Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and https://www.mssqltips.com/sqlservertip/1480/configure-microsoft-access-linked-tables-with-a-sql-server-database/ thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste ms access the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Other topics Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Other topics Forum Problem refreshing linked tables via Link manager thread181-913585 Forum Search FAQs Links MVPs Problem refreshing linked tables via Link manager Problem refreshing linked tables via Link manager qwert62 (Programmer) (OP) 8 Sep 04 11:26 I have an access 97 database that has many ms access linked linked tables (SQL tables).When I try to refersh tables via link manager, I get the following error message:"Application-defined or object-defined error".I am able to refesh some of the tables, but not others.Does anybody know what would cause this error?Thanks in advance for any suggestions.By the way, upgrading to a newer version of Access is not an option. RE: Problem refreshing linked tables via Link manager RickSpr (MIS) 9 Sep 04 21:31 This error means either that a runtime error occurred which Access doesn't recognize, or that a bug in Access is failing to look up the appropriate message.If the error number is also displayed, you can get the proper error message by entering the following in the Debug Window: ?AccessError(nnn)where 'nnn' is the error number.Otherwise, I would try deleting all the table links (or at least the ones giving you a problem) and relinking them, then test the Linked Table Manager again. If that doesn't work, I don't know what to suggest. Rick SpragueWant the best answers? See FAQ181-2886To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames
| Related Tips: More > Microsoft Access Integration ProblemThus far in this tips series on Access and SQL Server, we have created an ODBC Data Source Name (DSN) using the OLEDB driver for connecting to SQL Server 2000, as well as a System DSN to connect to a SQL Server 2005 instance using the new SNAC (SQL Native Client) driver. This was in preparation for using Microsoft Access as a front-end tool for a SQL Server 2005 database. Though Access can be considered a sub-par application by the relational database elitists, it can be a very capable alternative for querying data from SQL Server without the learning curve associated with Visual Studio. In some respects, it is the perfect tool for the casual business user who wants to drill into and share their data. So what's next? SolutionIn order to connect to Microsoft SQL Server from Microsoft Access you need to set up at least one Linked Table. This table is a pointer to a table in a SQL Server database that is associated with a pre-defined System ODBC Data Source Name (referred to as a DSN from this point forward). In truth, you have many options for setting up Linked Tables from Access; many RDBMSs (Relational Database Management Systems) and Microsoft Office applications for example - even SharePoint and Outlook are options for linking tables back to Microsoft Access. For the purpose of this tip however, we're going to focus exclusively on Microsoft SQL Server. The process from this point forward is compatible with all releases of SQL Server since version 7.0. The first step in setting up a linked table is to navigate to the Linked Tables dialog in Access. From the menu bar, select File | Get External Data | Linked Tables as shown below: By default, Microsoft Access will want to link to another Access database for it's Linked Table source. Browsing the 'Files of Type' pull-down menu on the bottom left of the interface will give you a general idea of just how broad of a scope is available for Linked Table sources. Since we are f