Recent content by bill66man

Nevermind. I got it fixed. I had added an additional table to the parameter query several days ago and even though none of the columns from that additional table had been added to the query, it still went read only on me. Removed the table and all is well.

Hmmm...my query doesn't have a 'group by' or 'transform' clause, nor does it have 'distinct' in it , and it isn't a union query. I checked the permissions and it doesn't appear to be read-only. Recordset type is set to DynaSet. It is not a subquery. Any other suggestions?

Hello, I have an Ms-Access db that I use daily. It's not very big (4 mgs), and I have run into a problem. Every week or so I run a parameter query and once it returns the results, someone goes in and modifies some of the data. However, today it was discovered that the results are not...

No, not doing anything of that nature.

Okay, me and one of my IT guys just determined this--whenever I add a 27th column to a certain table, it crashes (when I launch the particular form). Is there some limit with forms or combo boxes that relates to columns in a referenced or bound table?

Maybe--I'm still looking into this; I just re-added the columns again and can't seem to make it crash now. It may have something to do with actually having data in those columns, which is what I will be doing here shortly.

I think I tried that back when I first had this problem. Oh--at the suggestion of someone else I also split the database into two dbs--a front end and a backend db. This problem is bizarre--I just deleted the new extra columns from the table and everything is fine now--no crashes when I...

Oh yes, I've already done that. I also set a stop on the first line of the 'form load' code event in vb just to see if it makes it that far. It doesn't.

Okay, MS Access crashes even when I attempt to open the form up in Design view! What next?

Wow--quick responses! The forms are based on a combo box selection/query. Select something from the combo box and the form populates it with the rest of the record data. I'll try adding the newly added columns as items on the form and see what that does.

I am having a peculiar problem with Access (2003). The database is a meager 4mbs in size and I use several forms to access my tables. Recently I found a need to add more columns (currency data) to one of my tables. So when I did, then tried to open my one of my forms, Access says 'MS Access...