Re: in query expression 'MSysAccounts.name'. ERROR

Tech-Archive recommends: Fix windows errors by optimizing your registry

Groan.

Well, if it was me, I'd keep playing, because I don't have an IS/IT group,
but I wouldn't expect to get it fixed any faster.

You can try the MDAC checker,

http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&DisplayLang=en

and you can try re-registering VBA and DAO

"You might want to go ahead and try re-registering your DAO360.dll file. It
won't hurt anything to
re-register it if it's already properly registered. To register this file,
first find it on your
hard drive.  Close Access (and any other software that might be using this
..dll file). Then click
Start > Run and enter the command "Regsvr32" (without the quotes). Drag the
DAO360.dll file that
you found to the end of this line, making sure that there is a single space
inbetween the name of
the executable and the filename. This way, you won't need to deal with
typing in the long path.
Alternatively, use Method 1 in the resolution section of this KB article:


http://support.microsoft.com/?id=248790
"
both dao and vba are in the /common files/microsoft shared/ path

(david)



"Andrew L via AccessMonster.com" <u10491@uwe> wrote in message
news:5b373e96f12b5@xxxxxx
> Update:
> Per my post above, I couldn't use the utility suggested.  However...
>
> 1)  I uninstalled the Oracle 10g Client.  This was the last significant
thing
> done or installed prior to the problem.  However access ran quite fine
after
> the Oracle install.  I know because I later used Access to manipulate data
> retrieved by the Oracle Client.
>
> 2)  I ran the Office2000Pro install and chose to completely uninstall
office.
> Note:  At first it wouldn't let me.  Either the setup.exe gave an error
> (sorry, I didn't copy it down) or the add/remove programs said some path
was
> too deep.  So I used the add/remove programs to "repair" Office.  Then I
used
> the setup.exe and chose to remove Office.  Also note that I did not remove
> FrontPage.  I just now thought about it.
>
> 3)  Then I ran CCleaner and RegCleaner, a few times, until both said all
was
> clean.  Note: CCleaner picked up that the MDW file was not associated to
> anything and cleaned the entry.
>
> 4)  I re-installed Office.  I have not re-installed the Oracle Client.
>
> 5)  I tried Access.  Same problem.  Aaaarrrrgghh!!!
>
> Any ideas?  Anything that would save me sending in the PC to our IS/IT
group
> would be a terrific help, as I'm a remote user and I have to mail it back,
> let them redo the drive, and mail it back to me.  (It would be a nice paid
> vacation, if I didn't have to make up the lost work later.)
>
> Thanks again,
> Andrew
>
> david epsom dot com dot au wrote:
> >I think I sent you to the wrong place. Try this:
> >
> >Utility to completely remove remaining Office CD1 files and registry
entries
> >http://support.microsoft.com/kb/239938/EN-US/
> >
> >(david)
> >
> >> Hi again,
> >>
> >[quoted text clipped - 28 lines]
> >>>>>Then copy system.mdw from another PC.
> >>>>>(david)
>
> -- 
> Affordable Content Managed Web Site Setup
> http://www.ezysetup.com
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200602/1


.

Relevant Pages

  • Re: Unable to update
    ... Some have reported that simply re-registering the MSXML3.DLL seems to fix the ... type: regsvr32 MSXML3.DLL ... | the option to register or re-install them. ... | then throws me back to the express or custom install page. ...
    (microsoft.public.windowsupdate)
  • Re: perl Oracle
    ... > You will need to install the Oracle client on the server you wish to ... > the oracle server? ... If you are not the intended recipient, ...
    (perl.dbi.users)
  • Re: Connection to ORACLE: Need some explanations
    ... The Oracle client is installed because it has been installed on purpose ... ¤ ... Oracle OLEDB Provider is a separate install and it is the one to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error while executing DBI module
    ... current Oracle client or DBD:Oracle did now install correctly or is not ... Can you tell us what version of DBI, DBD:Oracle, Oracle Client and Oracle ... I get the following errors while executing the DBI module of perl. ... shared object file: No such file or directory at ...
    (perl.dbi.users)
  • Oracle client install?
    ... I have been trying for two weeks to install an Oracle client ... I don't have a working installation on a Linux machine to copy ... Is there information and files available to easily install an Oracle client ... on a Fedora Core 2 machine? ...
    (Fedora)