Access: SQL Pass-Through Query against Oracle

========= QUESTION --------- When I write a regular query in Microsoft Access against a table in an Oracle Database, and then convert it to a SQL Pass-Through query, it will not run, and shows errors like the following:  --- ODBC--call failed. [Oracle][ODBC][Ora]ORA-00903: invalid table name (#903) OK     Help--- --- ODBC--call failed. [Oracle][ODBC][Ora]ORA-00396: missing expression(#936) OK    [...]

By |2017-12-01T23:47:38+00:00August 9th, 2011|Access, Computers, Documentation, Microsoft, Oracle|Comments Off on Access: SQL Pass-Through Query against Oracle

Access Error: Method ‘CopyFile’ of object ‘IFileSystem3’ failed

========= QUESTION --------- When trying to run an Access Sync operation, I get the following error: --- Microsoft Visual Basic Run-time error '-2147023080 (80070718)': Method 'CopyFile' of object 'IFileSystem3' failed [Continue]  [End]  [Debug]  [Help]---   ========= ANSWER --------- Believe it or not the best we have found on this error has to do with disk [...]

By |2011-08-09T08:23:35+00:00August 9th, 2011|Access, Computers, Documentation, Microsoft|Comments Off on Access Error: Method ‘CopyFile’ of object ‘IFileSystem3’ failed

Outlook: Edit or add notes to email in your Inbox or Personal Folders

========= QUESTION --------- I would like to write some notes, or documentation on an email I received from someone else that is in my inbox, or a folder in my Personal Folders.   ========= ANSWER --------- Double-click, or open the email From the Actions section of the Message ribbon or tab, select Edit Message (Keyboard [...]

By |2017-12-01T23:47:38+00:00August 2nd, 2011|Computers, Documentation, Microsoft, Outlook|Comments Off on Outlook: Edit or add notes to email in your Inbox or Personal Folders

Access: MaxLocksPerFile / File sharing lock count exceeded

========= QUESTION --------- When synchronizing in Microsoft Access, I get the following error: ERROR: -2147467259 - File sharing lock count exceeded. Increase MaxLocksPerFile registry Entry.   ========= ANSWER --------- Adjust the registry entry MaxLocksPerFile to increase the maximum number - see: http://support.microsoft.com/kb/815281 (Method 1) Start button, Run Type: RegEditClick OK--- For Access 2000, Access 2002, [...]

By |2017-12-01T23:47:38+00:00August 1st, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on Access: MaxLocksPerFile / File sharing lock count exceeded

VBA: Loop to create a table with the number of records specified in a field of another table.

========= QUESTION --------- I have a table with one record per entity, and a field with the number drawing entries they have. How do I take this and create a table with one record for each of those drawing entries?   ========= ANSWER --------- Use the code in EXAMPLES below to open each record in [...]

By |2017-12-01T23:47:38+00:00July 29th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off on VBA: Loop to create a table with the number of records specified in a field of another table.

How do I add, edit or delete favorites in Internet Explorer?

========= QUESTION --------- I need to add a new favorite in Internet Explorer. I need to edit a favorite in Internet Explorer. I need to delete a favorite in Internet Explorer.   ========= ANSWER --------- Internet Explorer v8 --- Adding a Favorite Open Internet Explorer Browse to the web site you wish to add to [...]

By |2017-12-01T23:47:39+00:00July 27th, 2011|Computers, Documentation, Internet Explorer, Microsoft|Comments Off on How do I add, edit or delete favorites in Internet Explorer?

Outlook: Shared task list – hide already assigned

========= QUESTION --------- When viewing a list of shared tasks in Microsoft Outlook, how can I make the ones already assigned to or owned by others, not show?   ========= ANSWER --------- When assigning or taking ownership of the task, un-check the "Keep an updated copy of this task on my task list" checkbox just [...]

By |2011-07-20T05:39:06+00:00July 20th, 2011|Documentation, Microsoft, Outlook|Comments Off on Outlook: Shared task list – hide already assigned

OWA: How do I open additional mailboxes?

========= QUESTION --------- When I am logged in to Outlook Web Access, is there a way to access other mailboxes or inboxes like I do when using my Outlook desktop software?   ========= ANSWER --------- Click your name in the upper right corner of the Outlook Web Access window Type the name of the mailbox [...]

By |2017-12-01T23:47:39+00:00July 19th, 2011|Computers, Documentation, Exchange, Microsoft, Outlook Web Access|Comments Off on OWA: How do I open additional mailboxes?

Access Error: Microsoft Access can’t open the Zoom box

========= QUESTION --------- When I right-click a field cell in a query and select Zoom I get the following error in a pop up dialog box with an OK button: Microsoft Access can't open the Zoom box. The Microsoft Access Utility add-in is missing or was modified. Rerun Microsoft Access or Microsoft Office Setup to [...]

By |2017-12-01T23:47:39+00:00July 15th, 2011|Access, Computers, Documentation, Microsoft|Comments Off on Access Error: Microsoft Access can’t open the Zoom box

Access Error: …is not a valid name

========= QUESTION ---------When running  a query in Microsoft Access, I receive the following error in a pop up dialog box with an OK button: 'QUERY NAME HERE' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.    ========= ANSWER --------- This [...]

By |2017-12-01T23:47:39+00:00July 15th, 2011|Access, Computers, Documentation, Microsoft|Comments Off on Access Error: …is not a valid name
Go to Top