Cannot enter data into form.

[SMT21]

I have a form that suddenly stopped operating properly. I cannot type in the fields and although the drop down boxes show items, I cannot make a selection....please help.

Any suggestions would be appreciated!

 

[boblarson]

Sounds like either:

1. Your form's Allow Additions and/or Allow Edits property got set to NO

or

2. Your recordsource behind the form became not updateable.

 

[boblarson]

Some info that might help:

http://allenbrowne.com/ser-61.html

 

[SMT21]

Ok...

Bob, my allows are all set to yes, so what would cause ther recordsource to became not updateable? Access has record limit for tables? There are only about 15,000 records in that table.

 

[KeithG]

Is it a single table recordsource? can you add/edit the data in the recordsource

 

[SMT21]

Ok....

Here is my recordsource:

SELECT orders.*, [Lastname] & ", " & [FirstName] AS Contact, Customers.[Organization/Name], Customers.[Address 1], Customers.City, Customers.State, Customers.Zip, Customers.[Phone #], Customers.County, department.Department, Customers.MailAddress, Customers.MailCity, Customers.MailState, Customers.MailZip, contacts.MailAddress, contacts.MailCity, contacts.MailState, contacts.MailZip, contacts.Address, contacts.City, contacts.State, contacts.Zip, contacts.Phone FROM department RIGHT JOIN ((Customers RIGHT JOIN orders ON Customers.[Customer ID] = orders.CustomerID) LEFT JOIN contacts ON orders.contactID = contacts.ContactID) ON department.DepartmentID = Customers.depID;

 

[boblarson]

Based on the link I provided and looking at your SQL, I would say it might have to do with this one:

It uses JOINs of different directions on multiple tables in the FROM clause. Remove some tables.

 

[SMT21]

Ok...

Some info that might help:

http://allenbrowne.com/ser-61.html

This is good information, but what which cause would happen suddenly while entering data?

 

[missinglinq]

In answer to you question about record limits the answer is no, Access has no limit on the number of records. The number of records are limited only by the overall size of the database, which is 2 GBs. To give you an idea, I've heard about many databases running with 300,000+ records and even a few reports of 1,000,000+ dbs.

When things have been running smoothly and suddenly stop you have ask yourself "What has changed?"

Have you made any modifications (no matter how small) to your database design?

Have you made any changes in Access? Installed upgrades/addins? Micro$oft just "upgraded" ACC2003 with SP3 which was (and is) chock full of bugs!

Have you made any changes to your operating system?

Have you physically moved the database to a new machine? Some CD burners automatically set the Read-Only Property to True. You might want to go into Windows Explorer and check this.

Has something changed in your network, if you're on one? Is it possible the IT boys have been playing with things and you no longer have full permissions in the folder your db resides in?

And finally, you have to face the possibility that your database has been corrupted.

Linq

 

[boblarson]

This is good information, but what which cause would happen suddenly while entering data?

I answered this question before you asked it:

http://www.access-programmers.co.uk/forums/showpost.php?p=653466&postcount=7