Access: it reads: "Data sheet not updatable

[Art]

When opening a newly built database, the program responds with the following
message; "data sheet not updatable." Is this due to the space available on
the drive or a formatting that needs to be applied in the security section?

 

[Vincent Johns]

When opening a newly built database, the program responds with the following
message; "data sheet not updatable." Is this due to the space available on
the drive or a formatting that needs to be applied in the security section?

I haven't seen your database, but this could be the result of displaying
a read-only Query in datasheet view. (You can make a Query be read-only
by declaring it to be "Snapshot" instead of "Dynaset", or by including
calculated fields in it which interfere with updating.)

What type of object is it displaying when you get that message?

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Art]

:

Good morning...

If I’m correct in understanding you on this, the object being displayed is;
Table or Form view... which ever I pull up first. I’m new with the access
and have started having problems since I converted to Windows-XP
(Professional) by way of the DC Government. Recently, after being upgraded
with a new Dell and Program, I completely lost a database to unknown reasons
and decided to build another for replacement. Now [that] I have built a new
one, I’m still having problems.

 

[Art]

John:

The actual saying is; "The Record set is not updatable". I've also gone
into the security tab and made sure the features were set.

 

[Vincent Johns]

:

Good morning...

If I’m correct in understanding you on this, the object being displayed is;
Table or Form view... which ever I pull up first. I’m new with the access
and have started having problems since I converted to Windows-XP
(Professional) by way of the DC Government. Recently, after being upgraded
with a new Dell and Program, I completely lost a database to unknown reasons
and decided to build another for replacement. Now [that] I have built a new
one, I’m still having problems.

I assume here that you didn't get a message when you opened the file
that said "The database 'xxxxx' is read-only. You won't be able to save
changes made to data or object definitions in this database."

Regarding losing your database, I hope that whatever you do now, you are
making frequent backup copies.

Can you display the contents of the Table that you pulled up? Can you
open it in Table Design View? (I assume you get a message when you try
to do that.) What message do you see?

Can you construct a new Table, using Table Design View, and then add
data to it? If so, I suggest you copy the Table that you couldn't
update and paste its contents into a new one that you can update.

If not, can you open a new database, save it as an empty file, and
create a new, empty Table? Having done so, can you add data to it?

If not (and I'm afraid I'm not an expert on this), I'd guess that you
have a flawed copy of Access and might need to re-install it. But you
should get another opinion before doing that.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Art]

I can actually pull up the form view, table view and Queries. The only
problem I have is; can't edit or enter new data into the table or [enter
data] by way of the form. It's more like being locked out but can still read
the data that has already been inserted.

I have, at this time generated a new table and will copy and paste the table
into a new database window along with other tables that I use in the
relationship.

I'll see how that works and... need to (in the future) set myself up to
take an advanced course in Access... compliments of the DC Government...

:

Good morning...

If I’m correct in understanding you on this, the object being displayed is;
Table or Form view... which ever I pull up first. I’m new with the access
and have started having problems since I converted to Windows-XP
(Professional) by way of the DC Government. Recently, after being upgraded
with a new Dell and Program, I completely lost a database to unknown reasons
and decided to build another for replacement. Now [that] I have built a new
one, I’m still having problems.

I assume here that you didn't get a message when you opened the file
that said "The database 'xxxxx' is read-only. You won't be able to save
changes made to data or object definitions in this database."

Regarding losing your database, I hope that whatever you do now, you are
making frequent backup copies.

Can you display the contents of the Table that you pulled up? Can you
open it in Table Design View? (I assume you get a message when you try
to do that.) What message do you see?

Can you construct a new Table, using Table Design View, and then add
data to it? If so, I suggest you copy the Table that you couldn't
update and paste its contents into a new one that you can update.

If not, can you open a new database, save it as an empty file, and
create a new, empty Table? Having done so, can you add data to it?

If not (and I'm afraid I'm not an expert on this), I'd guess that you
have a flawed copy of Access and might need to re-install it. But you
should get another opinion before doing that.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Vincent Johns]

I can actually pull up the form view, table view and Queries. The only
problem I have is; can't edit or enter new data into the table or [enter
data] by way of the form. It's more like being locked out but can still read
the data that has already been inserted.

I have, at this time generated a new table and will copy and paste the table
into a new database window along with other tables that I use in the
relationship.

You may not even need a new database file, though that probably won't
hurt. If you copy to another Table in the same database, just use Edit
--> Copy and Edit --> Paste. If you use a new database file, go to File
--> Get External Data --> Import and copy the Table that way.

I'll see how that works and... need to (in the future) set myself up to
take an advanced course in Access... compliments of the DC Government...

To some extent, just banging against problems like this, reading Help,
and solving the problems is like an advanced course in Access.

Good luck!

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.