Database Engine Stopped - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Database Engine Stopped

Dg Ewing

5 years ago

I have a linked access table to a db table at winhost.  I have built an add record form and process that executes from my site.

I added 4 test records, and all is fine, except when I try to delete or change those records in the access linked table.

I can change and or delete any other record from access except the 4 test records that I added from my site.

I close the rs and conn and set to "nothing" after the rs.update has completed.

I tried closing the website, acess, mssm .  I deleted the linked table from access and relinked,

Help

	Dg Ewing OP @Reply 5 years ago

	Dg Ewing OP @Reply 5 years ago
mdkaid is the auto number and 347 and down were uploaded to winhost server, and records 349-353 are the new add test records. I tried to : [again] rs.close Conn.close Set rs = Nothing Set Conn = Nothing but rs and conn were already set to nothing so i get a error.

	Dg Ewing OP @Reply 5 years ago
I can change or delete any old record but I cant deleted records added by my asp process. Also I can not add new records within access

	Dg Ewing OP @Reply 5 years ago

	Scott Axton @Reply 5 years ago
You need to close them in the reverse order that you set them. set rs = "aaaa" set Conn = "bbb" do stuff Conn.close rs.close set Conn = Nothing set rs = Nothing

	Dg Ewing OP @Reply 5 years ago
There is something else going on. When I add a new record in my local Access and leave record I can not delete or change. But I can any of the old records....Something has been set to lock all new records..... how do you unlock records

	Scott Axton @Reply 5 years ago
I agree. Something in your code is causing records to be in edit mode and leaving them "open". I'm not familiar with asp nor do I use an external server so I'm afraid I can't be of more assistance. You may have corrupted the files somehow. I would completely close down and restart. Get into your vba and do a debug an compile. If that doesn't fix it run through Richard's Troubleshooter

	Dg Ewing OP @Reply 5 years ago
Googled and Googled, it sounded like a common theme revolved around tables with bits (yes/no), which I had 4 . changed them to text "yes" or "no" and deleted server table, and the linked local table. recreated and relinked and all is well .....

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View