conflict with form 1

[ailyn]

Hi!
I have a form that feeds on one table 'table1' and a report that feeds on the same table. On the form I have a button that opens that report, but it never displays because I get a JET error. Anyone knows why? this same method works perfectly with my other tables and reports.

 

[THWatson]

ailyn
What error message do you get?

Tom

 

[ailyn]

That the table is being used by another process or user.

 

[THWatson]

ailyn
I gather this is a single user database? If that's the case, I'm not totally sure what's happening, but it sounds as if there is a conflict somewhere.

You could try making another form from that same table and running the report, and see what happens.

Tom

 

[ailyn]

Yes, it is a single user db.
& I get the same error with another form feeding on the same table when I try openning the report. Do you think that the problem is the report? I also have a nother report that feeds on the same table and it doesn't open either. whatever I do it gives me error. I think the conflict might be on the table itself but how do you find/solve it?

 

[dhookom]

ailyn,
You have told us what doesn't work about reports. To trouble-shoot, you need to find out what does work. For instance:
-do any reports work from other tables
-do new reports work from the "same" table
-do new reports work from queries involving the "same" table

This is basic trouble-shooting. Find what does work and then change and add to what does until it doesn't work. Then you can generally pinpoint the cause of the error.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ailyn]

Sorry, Dhookom but I really cannot see what's wrong. I have 5 tables. one form and one report each. Two of them work perfectly. The other three, the form and the report work but separately. any time I try opening them from the form or query that feeds on the same table I get that error.
Any idea where the error could be? I've been checking them for hours and nothing.

 

[dhookom]

If opening from the button is the only error generating process, you should provide the code from the "button that opens that report".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ailyn]

I did. I made the code myself and I made the code with the wizard. None works. Furthermore, when the form is open I cannot open the report that feeds on the same table from the access menu. It gives me the same error. Thus, the button is not the problem. Although when I open the report first and the form afterwards, they both work.
?.? I'm at a complete loss here. Any ideas?

 

[dhookom]

I am losing track of what works and what doesn't work. Are there any unique control sources or code in your report?

If you can't get this to work, I would suggest making a backup copy of the report. Then remove code/controls etc until the report works as expected. When it finally opens, the last object you removed was the culprit.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ailyn]

Thanks Dhookom, but I did erase everything. All queries, raports, forms, modules and macros. all the code from the form. I even erased all the tables and remade the form and the report. The problem kept appearing. I would say it is an option in Access but then why doesn't it happen with the other 2 tables that work?

Still I made a new database from scratch with a new tables, form, report and the same error again. ?.?

 

[dhookom]

What happens if you open a new, blank mdb and import the objects from your trouble-some mdb?

Have you ever checked the references?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ailyn]

I just did it gives me the same error. & what references are you talking about exactly?
I checked the tables and the forms and the reports erase them and remade them with and without wizard. Everything looks just fine. But as long as a simple query or even the table is opened the report that feeds on the same table won't. I always get an error that comes because the record is locked. I don't know how to unlock/lock records. I tried all the properties of the table and nothing tells me how to undo that.

 

[ailyn]

Ok. I googled a bit and found that changing the Report Properties on Record Locks could solve the problem. Indeed it does! I changed the Report Locks from "All Records" to "No Records". I cannot find another solution to this problem. It turns out that the other reports that worked from the form has this option in "No records" too. I knew it wasn't my code! XD
Thanks a lot for your help

 

[dhookom]

I had never seen that property before and don't understand how it would have been set different than the default.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ailyn]

Well neither do I. But that was the problem now any report I make is with that property set to all records as the default. But now at least I won't forget to turn it off XD