Search results

Cannot do ANYTHING with the db...always says "The microsoft jet database engine stopped the process because you and another user attempted to change the same data at the same time." Cannot unlock, access, export, import, NOTHING,, Locked up so tight, no one can get any further than the error...

ghudson, What can you do if you do not have an .ldb file and the database is locked. Cannot open, retrieve the data or even copy tables, etc from it We are powerless to get into it in any way....Dont know for sure what is happening to cause this... Any suggestions would be appreciated...

Thanks studenn I cant open the db and no I didnt have a lot of macros....It wont let me do anything w/o giving me the message above...

Ours is a Windows 2000 server...Any ideas on how to repair/access the db? This has happened 3 times in the last week and we dont know 1) how it is happening and 2)how to retrieve or repair the db so we can access the data... Could someone give me an idea? Thanks in advance Noreene

I am having the same problem!!!! Some one must be locking up the db at night and cannot find a locked db file but it gives message "The microsoft jet database engine stopped the process because you and another user attempted to change the same data at the same time." Cannot get into the db...

Thank you so much Pat, for your response....Never would have thought of that. Noreene

I want to know if I change the menu bar in an Access db (such as take out every thing, edit, view, format, tools, etc. except file and exit) would it remain that way in every other db that was opened on that pc? I want to restrict access to every tool except file, exit on only one pc (a public...

Thank you, modest...I am going to file this code so if I do something like this again, then I wont panic... Thanks, Noreene

Well, I finally figured out how to get the startup menu by going into design of form and putting in this code: docmd.runcommand.accmdstartupproperties and clicking allow full menus. So at least now I can get into my own db!!! Wont do that again. But, now I have to have some security to keep...

I did such a stupid thing..I went into the startup of my database and chose to not show full menus...we are having some "wanna be's" messing around in the database so I was going to restrict their ability to "roam". Now, I cant get in to undo the procedure...I tried by holding down shift key...

Thank you so much for your help. I would not have come up with the answer on my own. Noreene

Thank you for your help Noreene

Thank you, boblarson!!!! That was perfect! But, what does cstr actually do?

I have a form that requires date, picker id, no of pallets, and a unique identifier (which is date + no of pallets). On my form, there is an unbound text box (displaydate) that takes the date field and converts it into a number, format([date], "mmddyy") so that 04/15/05 looks like 041505. And...

Rich, I tried your suggestion and it works great....there are a few quirks to work out, but it does what I need. Thanks so MUCH!!! And thanks to you also, pbaldy, I appreciate all your time and thought... Thanks, Noreene

pbaldy. The Microsoft Object DAO library has been checked now...and it goes past that line without stopping, But, now it stops on first line that has VALUES and says "rs!deliverydatefieldname = <Item not found in this collection>" Thanks, Noreene

Rich, I did start out with an append query suggested by SJ McAbney...and it does work... however, by using the dayofweek query as my controlsource on the form(Deliverydate criteria in the query is [Enter day of week]) it would ask me for dayofweek again when I tried to run the append query and...

Private Sub cmdrunqry_Click() Dim sqlstr As String Dim rs As DAO.Recordset Set rs = Me.RecordsetClone Do While Not rs.EOF sqlstr = "INSERT INTO tblcustomerhistory (txtdeliveryday,txtcustomerid, txtdeliverytime, txtcarrier, txtontime, txtproblem, txtcomments, txttoday)" sqlstr = sqlstr &...

This code works fine except it only "rolls over" the first record. I need it to roll over all records that show up in my form. The recordsource for my form is a query that asks for day (Mon, Tue) and then pulls out those records... On clicking the command button, I want it to insert all records...

I posted a question last week in query section that SJ MCAbney answered for me. SJ suggested that I use an append query(which, by the way, does exactly what I need it to do) but still having a small problem. So, here goes. Used a select query to open form by making deliverydate criteria as...