Access 2000 Data Entry Form goes invisible

[jhutchings]

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!

 

[Rick Brandt]

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.

 

[jhutchings]

Hi Rick,

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

 

[Rick Brandt]

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.

 

[jhutchings]

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

 

[Rick Brandt]

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.

 

[jhutchings]

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