#Deleted Error

------=_NextPart_000_006B_01C52883.1AA142D0
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Hi,
Are there any updates to the listed of fixed for the #Deleted error when
using MySQL ODBC with Access? I've followed all the instructions listed in
the online manual on two machines, one with Access 2000 and the other with
Access 2003 with the same results - all fields of all tables in table view
or forms comes up as #Deleted.
Thanks!

Dav Banks
Center for Applied Biomechanics
<http://www.centerforappliedbiomechanics.org>
University of Virginia
1011 Linden Ave.
Charlottesville, VA 22902
(o) 434.296.7288 ext.160
(f) 434.296.3453



------=_NextPart_000_006B_01C52883.1AA142D0
Content-Type: text/plain; charset=us-ascii

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
------=_NextPart_000_006B_01C52883.1AA142D0--
Dav Banks [ Mo, 14 März 2005 16:46 ] [ ID #694815 ]

Re: #Deleted Error

If you are talking about records with an autoincremental key the
solution is quite simple. In the Access form put a default value of zero
in the key field.

But you have the problem with table view too. Maybe is something else, I
don't know. I have Access 97, Access 2000 and Access XP machines and all
works fine.

Dav Banks wrote:

>Hi,
> Are there any updates to the listed of fixed for the #Deleted error when
>using MySQL ODBC with Access? I've followed all the instructions listed in
>the online manual on two machines, one with Access 2000 and the other with
>Access 2003 with the same results - all fields of all tables in table view
>or forms comes up as #Deleted.
>Thanks!
>
>Dav Banks
>Center for Applied Biomechanics
><http://www.centerforappliedbiomechanics.org>
>University of Virginia
>1011 Linden Ave.
>Charlottesville, VA 22902
>(o) 434.296.7288 ext.160
>(f) 434.296.3453
>
>
>
>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
Juan Pedro Reyes Moli [ Mo, 14 März 2005 20:32 ] [ ID #694816 ]
Datenbanken » gmane.comp.db.mysql.odbc » #Deleted Error

Vorheriges Thema: Question????
Nächstes Thema: FW: MS ACCESS and mySQL - MYODBC - Polish Chars Problem