cant type in form

[Army MI]

I have a problem i need some help with. I have a User lvl secured database
on a network. I have a form my users use to input derogatory information
into so that it can be save to a table named "DEROG". But ever since i
enabled the security and put it on the network I can not type data into the
form or into the table all i get is the windows "dur da dur" ping when i try
to input data. I cant even add a new record because all it does is retrieve
and use the existing data in the table. Any ideas?

 

[John W. Vinson]

I have a problem i need some help with. I have a User lvl secured database
on a network. I have a form my users use to input derogatory information
into so that it can be save to a table named "DEROG". But ever since i
enabled the security and put it on the network I can not type data into the
form or into the table all i get is the windows "dur da dur" ping when i try
to input data. I cant even add a new record because all it does is retrieve
and use the existing data in the table. Any ideas?

All I can suggest based on the little you have posted is that you made an
error implementing security. Was this Windows security, or Access workgroup
security on the database? do users have full read, write, create and delete
permissions to the folder containing the database?

 

[Army MI]

it was the user security within access, all users have read, write create,
and delete permissions on the DB and the folders on the network. The very
weird thing is i have full permissions on my computer where the DB is stored
and even i can not change or type within the form. Even weirder is i have
another form that is based exactly the same but works perfectly fine and all
the settings are the same.

 

[Ken Snell MVP]

Check that the form's AllowEdits and AllowAdditions properties are set to
Yes.

 

[John W. Vinson]

it was the user security within access, all users have read, write create,
and delete permissions on the DB and the folders on the network. The very
weird thing is i have full permissions on my computer where the DB is stored
and even i can not change or type within the form. Even weirder is i have
another form that is based exactly the same but works perfectly fine and all
the settings are the same.

Can you edit the Query upon which the form is based? Maybe there's some
corruption: try tools... database utilities... compact and repair (make a
backup first just in case).

 

[Army MI]

i did not base the form off a query i bades it off a table like my other
forms that do work which is why i can understand why this one form is the
only one that doesnt work.

 

[Army MI]

yes they are

Check that the form's AllowEdits and AllowAdditions properties are set to
Yes.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/