The ability to paste records is gone? 1

[navigator703]

Good Afternoon-

I am working with a couple of tables that I need to paste data into. When I actually try to paste the data into the table, the normal empty row at the bottom of the table is gone. This limits my ability to paste records into the table from my excel spreadsheet. This feature is gone for these two tables.

Here is what I have tried:
1) restarting my PC
2) creating a new db instance
3) refreshing my db source

Any suggestions?

~ a journey of a thousand miles must begin with a single step ~

 

[Remou]

Is your database read-only by any chance?

 

[navigator703]

No

~ a journey of a thousand miles must begin with a single step ~

 

[dhookom]

Is there an ldb file in the folder when you open the mdb?
Is the table an Access table or is it linked from another system?

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[navigator703]

Is there an ldb file in the folder when you open the mdb? - Yes
Is the table an Access table or is it linked from another system? - Yes it is linked to a sql server db

The problem did not occur until this morning and for only two tables.

~ a journey of a thousand miles must begin with a single step ~

 

[dhookom]

linked to sql server" is fairly significant. If you view the design view of the linked table, are you able to identify the primary key field(s)?

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[navigator703]

According to access, there is no primary key field. This is a problem!

~ a journey of a thousand miles must begin with a single step ~

 

[dhookom]

IIRC, if Access can't identify the primary key of the table, you can't add or edit records.

Does your table have a primary key or unique index?
Have you tried to relink it?
Have you tried creating a pseudo primary key in Access with a DDL query?

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[navigator703]

I relinked the table and double checked that my primary key was accounted for. This is working according to plan.

Thank you for your help

~ a journey of a thousand miles must begin with a single step ~