<!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 5.00.3314.2100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=410300312-19032003>The
databases are in the same folder on the same drive, they have the same startup
properties. When I bypass the startup properties, I can delete the record. I
have the AllowBuiltinToolbars = False & AllowFullMenus = False. I
thought this was the problem so I changed them to True, no luck
there.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=410300312-19032003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=410300312-19032003>What
else should I be looking for? I can't understand why the same code, etc would be
so different in 2 separate databases that are basically the
same.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=410300312-19032003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=410300312-19032003>Virginia</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> John Frederick
[mailto:j.frederick@att.net]<BR><B>Sent:</B> Tuesday, March 18, 2003 3:20
PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD]
Can't Delete on Network Drive<BR><BR></DIV></FONT>
<DIV><SPAN class=988351521-18032003><FONT color=#0000ff face=Arial size=2>If
you have two mdbs on the same machine that behave differently, look at their
security settings. Point to the folder, right click, select the security
tab. Something must be different at the folder level. Even if
you can't change it, you might be able to tell IT what is
needed.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><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 3:16
PM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE:
[AccessD] Can't Delete on Network Drive<BR><BR></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=760221020-18032003>I
do not understand why it works (can delete) in one database & not
another. They are both on the same drive.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=760221020-18032003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=760221020-18032003>I
do not use the built-in Access security.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=760221020-18032003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=760221020-18032003>I
am not able to change the security settings for the folder - that is done
through IT. So nothing has changed lately. It just has be so puzzled that it
works on one database & not the other???</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=760221020-18032003></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=760221020-18032003>Virginia</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> John Frederick
[mailto:j.frederick@att.net]<BR><B>Sent:</B> Tuesday, March 18, 2003 1:38
PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] Can't Delete on Network Drive<BR><BR></DIV></FONT>
<DIV><SPAN class=125072019-18032003><FONT color=#0000ff face=Arial
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 color=#0000ff face=Arial
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 color=#0000ff face=Arial
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 color=#0000ff face=Arial
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 color=#0000ff face=Arial
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><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></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>