Hello all,

I have a form I designed for data entry. However, when I set the form
properties to Data Entry mode, the form completely disappears for
Access 2000 users. All they see is a white blank space. What could be
causing this?

Thanks!

(E-Mail Removed) wrote:
> Hello all,
>
> I have a form I designed for data entry. However, when I set the form
> properties to Data Entry mode, the form completely disappears for
> Access 2000 users. All they see is a white blank space. What could be
> causing this?
>
> Thanks!

That is the expected result when the RecordSource the Form is bound to is
read only. If you have bound the form to a query rather than a table then
the query might not allow edits.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Hi Rick,

This form is bound to a table. How do I check the table for read only
Access?

(E-Mail Removed) wrote:
> Hi Rick,
>
> This form is bound to a table. How do I check the table for read only
> Access?

By that do you mean that you see the name of the table in the RecordSource
property or do you mean that you specified a table when using the form
wizard to create the form? The latter will still create a query (SQL
Statement String) that your form is bound to.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

When I look at the RecordSource I see the name of my table.

(E-Mail Removed) wrote:
> When I look at the RecordSource I see the name of my table.

Strange. I don't think you can make a table read only (at least not a local
one). It's not an ODBC linked table is it?

What is the RecordSourceType property of the form? It should not be
Snapshot.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

I discovered what was causing this problem thanks to a hint from you.

It appears that the Windows permissions on this file were not set to
write, only read. I changed the all users permissions to read/write and
now everything seems to be working great!

Thanks for the help