Date: February 19, 2006 05:20PM Aaron, I have had and resolved the same problem that you had, but now when I delete a record from the MS Access front end, I get the following message and cannot delete the record: The Microsoft Jet database engine stopped the process because you and ...
Date: September 06, 2005 07:32AM Hi, I have an Access 2000 App linked to a mySQL 5.0 backend. Every time I insert a new record (not using code mind you, but native Access methods), every column shows up as #Deleted. I'm using MDAC 2.8, the latest Jet Service Pack and myODBC ...
April 10, 2007 09:25AM Re: Solution What's Up with this #Deleted Thing 2182 Doug Lourey April 10, 2007 12:08PM Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advan...
Date: November 10, 2005 08:24AM Thank you for the correction, Ingo. :) After a little fun with limits.conf and ulimit I was able to go beyond 16k tables in the Merge spec on the box I'm using for testing. We'll never do this in production, it was more to see if I *could*...
Re: what's the limit on number of tables in MERGE table?Posted by: Ingo Strüwing Date: November 10, 2005 05:17AM I might have overlooked some important information from your posting. Because I stopped reading when I saw: ./foo/bar_99.MYD' not found (Errcode: 24) I issued the...
April 10, 2007 09:25AM Re: Solution What's Up with this #Deleted Thing 2182 Doug Lourey April 10, 2007 12:08PM Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advan...
Date: September 06, 2005 07:32AM Hi, I have an Access 2000 App linked to a mySQL 5.0 backend. Every time I insert a new record (not using code mind you, but native Access methods), every column shows up as #Deleted. I'm using MDAC 2.8, the latest Jet Service Pack and myODBC...
Date: September 06, 2005 07:32AM Hi, I have an Access 2000 App linked to a mySQL 5.0 backend. Every time I insert a new record (not using code mind you, but native Access methods), every column shows up as #Deleted. I'm using MDAC 2.8, the latest Jet Service Pack and myODBC ...
Date: April 10, 2007 09:25AM Using the time stamp option will not work if many records are appended to a table because the field will not be unique.. Here is a simple solution in access that is pretty generic so you can use it in all the input forms where fresh data is added. ...
Date: April 10, 2007 12:08PM I create the [TimeStamp] field in Access and set the value initially to #01-01-2000#, and then again to [TimeStamp] + [RecordID]/86400, making it unique to the second. [RecordID] is an auto-number field. By dividing by 86400, the number of second...