Re: URGENT !!! Operation must use an updateable quary

joshua siew wrote:
"Bob Barrows [MVP]" wrote:

joshua siew wrote:
"Bob Barrows [MVP]" wrote:

joshua siew wrote:
I got a return error runing a VB6, MDAC 2.5 compile and run on a
WinXP200(SP3) machine.....any way to check if that machine is
using the correct MDAC because I'm facing an error as the above.
My syntax is ADODB.Recordset .... bla bla bla.....
My machine is running fine without any error...sigh

You failed to tell us what database you are using so I will assume
Jet. This article was written with vbscript/asp in mind, but what
it says applies to other programming languages:
http://www.aspfaq.com/show.asp?id=2062

Dear Bob,
Sorry about that. It's access mdb2000 with no security at my user
workstation.

So my previous answer does not change. Check the file system
permissions on the folder containing the database file. ALL users of
the file need read/write authority for that folder. Check the
permissions on the file as well

--
Dear Bob,
I've check but there is no security on the folder as well as the file
itself. How ?

What OS?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Too late for Administrators Password?
    ... if you're going to be messing with permissions then ALWAYS FIRST SET ... folder and click the Security Options folder. ... Next, administrator, you need to have the security tab show when you ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Still Read-only
    ... >That is how XP and W2k3 are. ... >read-only attribute of the folder. ... >and file permissions are different things. ... Security) ...
    (microsoft.public.windowsxp.security_admin)
  • Re: XP File and printer sharing SOLVED!! A HIDDEN FIREWALL!!
    ... Then click a shared folder to open it. ... problem is probably caused by share permissions or NTFS file system ... I decided that it /had/ to be a firewall problem. ... I hadn't used any Symantec security software ...
    (microsoft.public.windowsxp.network_web)
  • Reinstalling WMP
    ... I don't know what the permissions were reset to. ... I tightened up the security on it and figured I'll ... reinstall by editing the .inf files that came with the WMP install package. ... Change the line to the new folder. ...
    (microsoft.public.security)
  • Re: Switched OS and Hard disk and lost access to old files
    ... administrator privileges and right-click the folder, properties, security, ... Owner to take ownership of the files and all subdirectories. ... OK, OK, and go back in to grant yourself permissions. ... being the security freek that I think I ...
    (microsoft.public.win2000.security)