Unable to add new record to table

[ReneeB]

Good afternoon everyone.
I have been using my db for 3 years without this particular problem: I am now unable to add records to one of my tables - either through the form or in datasheet view. I have a patient table and a visit table. I put in the patient data using a form and then go to the visit form to add all of the visits for the month. I have never had a problem adding data to any of my tables but now I am unable to add data to the visit table. As much as I didn't want to I brought up last month's back up to enter the patients again. Before I did I checked to see if I could add visits - I could not. So I checked January's back up - same issue. I made no changes to the db before trying to add a visit :banghead: It must be a setting somewhere.....?
So, oh smart ones, what say you? (just a basic user)

Thanks,
Renee

 

[CJ_London]

perhaps your db is so large it needs to be compacted?

when you say you can't add data, do you mean you can add data to the controls, but not insert a new record?

It must be a setting somewhere.....? What settings have you changed?

 

[ReneeB]

Thanks CJ --

I can't add a new record, regardless of how I try to approach it. There are 2017 records in the table. Is there a default number of records a table will hold? If so, can I change it? I have not changed any settings. I did compact the database - without success. (see, told ya I was a beginner )

Renee

 

[Solo712]

Good afternoon everyone.
I have been using my db for 3 years without this particular problem: I am now unable to add records to one of my tables - either through the form or in datasheet view. I have a patient table and a visit table. I put in the patient data using a form and then go to the visit form to add all of the visits for the month. I have never had a problem adding data to any of my tables but now I am unable to add data to the visit table. As much as I didn't want to I brought up last month's back up to enter the patients again. Before I did I checked to see if I could add visits - I could not. So I checked January's back up - same issue. I made no changes to the db before trying to add a visit :banghead: It must be a setting somewhere.....?
So, oh smart ones, what say you? (just a basic user)

Thanks,
Renee

When you say 'datasheet view' do you mean entering directly into the table or to a datasheet view of the form ?

Best,
Jiri

 

[Galaxiom]

What messages do you get when trying to add a record?

Can you add records directly to the tables? Which tables don't accept records?

 

[JHB]

Do you have accidentally put your directory to read only condition?

 

[ReneeB]

Ok all - here are your answers.....

JB - I'm not sure what a directory is (If you are referring to the table, doubt I put it in read-only, I was only inputting patients when I went to put in their visits is when the problem began - at least when I noticed it, but if I did I'd certainly like to fix it)

Galaxiom - Datasheet view = table view. Nope, can't enter data in that view either. I'm not at my work computer right now --the message said something very similar to "Cannot navigate to that record". Also the "New*" button in the ribbon and on the bottom of the table screen are gray'd out. This is the only table I'm having difficulty with.

Solo712 - form, table, doesn't matter where I try.

All - I have been considering removing my first two years worth of visits and only working with last year & this year. But I'm afraid that would just be a bandaid and I would be back in this same boat before December. (My visits last year were 465, they are on track for 1,000 this year.)

Thanks!!
Renee

 

[Galaxiom]

Directory is the old term for "Folder".

Try importing everything into a new database.

 

[ReneeB]

Thanks Galaxiom. I am busy with school the rest of the week and will be back in the office on Saturday - I'll give it a try then.
Until then -- thanks!!

 

[Privateer]

I ran into this problem with a client, the primary key was set as an integer and when they hit 32 thousand records it stopped. Make sure the primary key in both the patient (PatientID) and visitor (VisitorID) table is an autonumber and Long Integer and the Index is no duplicates. And I am assuming the tables are linked, so the visitor table has a "foreign key", or a field called PatientID so you know which patient was at which visit. Make sure that field is a long integer number also with indexing set to Yes Duplicates OK. And just to be clear, navigate to the actual patient table and double-click on it. It should display like an Excel spreadsheet. Scroll down to the last row, it should say (New) and type something in one of the fields. Did it accept the information? Move to the record above it, did the number in the first column increment by one? If this works on both the patient and visit tables, then I suspect the problem is with the code on your form and that is another question.

 

[ReneeB]

Galaxiom -

you are amazing!! Thank you so very much, importing the data, etc. to another database did the trick.
Thanks again,

Renee