<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=125072019-18032003><FONT face=Arial color=#0000ff size=2>Sounds
like OS security. When I gen a system for my home network, I go around and
disable all the security gotchas that I know of. If you're on your work
network, you want to be more careful. In your case, the os on the machine
with the Access data mdb has to either allow anyone coming in from
the network to make changes or it has to have a login/password for the
client and you have to either supply it when accessing the data mdb or
build it into your links and OpenRecordset commands. If you don't
care about security, I suggest the following:</FONT></SPAN></DIV>
<DIV><SPAN class=125072019-18032003><FONT face=Arial color=#0000ff
size=2>1. On the data machine, enable the guest account. How you do
that is os dependent. On W2k, go to Control Panel/Administrative
Tools/Computer Management/Local Users and Groups. Select User: "Guest", click
"Account is Disabled" off, and for good measure, add the Guest and Everyone to
the Administrators Group.</FONT></SPAN></DIV>
<DIV><SPAN class=125072019-18032003><FONT face=Arial color=#0000ff
size=2>2. On the folder containing the data mdb, right click, choose
security, and give everyone listed full permissions for the
folder.</FONT></SPAN></DIV>
<DIV><SPAN class=125072019-18032003><FONT face=Arial color=#0000ff
size=2>3. Either wait a day to give someone who knows more about security
to advise you not to do this, OR, take careful notes so you can undo
it.</FONT></SPAN></DIV>
<DIV><SPAN class=125072019-18032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com]<B>On Behalf Of
</B>Hollis,Virginia<BR><B>Sent:</B> Tuesday, March 18, 2003 1:34
PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Can't Delete on Network Drive<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=910302118-18032003>I need to delete a
record using a form (this is 97). The strange thing is if I copy the
database to my hard drive I can delete the record, but when the database is on
the network drive (where it lives) I get the error message "2046, The Command
or Action DeleteRecord is not Available Now". </SPAN></FONT><FONT face=Arial
size=2><SPAN class=910302118-18032003>I use the same code in another database
on the same network drive and folder & it works fine - I can delete the
record. </SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=910302118-18032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=910302118-18032003>I tried copying
the database to my hard drive & copying it back to the network. I even
imported everything into a new database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=910302118-18032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=910302118-18032003>What should I be
looking for in this database that would prevent deletions just because it is
on the network drive?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=910302118-18032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=910302118-18032003>On the command
button I have:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=910302118-18032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=910302118-18032003>Me.AllowDeletions
= True</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=910302118-18032003>RunCommand
acCmdDeleteRecord</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=910302118-18032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=910302118-18032003>Virginia</SPAN></FONT></DIV></BLOCKQUOTE></BODY></HTML>