Click here to get back home

Access and MySQl
 Home | NewsGroups | Search | About
Login Password
Register Now! Lost Password?
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Access and MySQl shoa 07-05-2005
Get Chitika Premium
Posted by shoa on July 5, 2005, 2:27 pm
Please log in for more thread options
 Hello

I can link MS Access (front) with MySQL (back end). However, when I add a
new record, the previous added record is signed as Deleted record (view in
Access) even I can view this record in MySQL.
Please help to go over this...

Thank you
S.Hoa




Posted by JIM WHITAKER on September 18, 2005, 11:21 pm
Please log in for more thread options
 I am new to mysql, but I figured this one out, please someone correct me if
this is a wrong answer. Here's what you do:
Even though you have an auto increment index in mysql, by incrementing it in
code will solve this. Look at this example.

Private Sub Form_Current()
Dim NEWID As Long, CID As Long
If Me.NewRecord Then
Combo14.Enabled = False 'innore this line, search
disabled here.
CID = DMax("PETID", "PETS") 'get highest id
NEWID = CID + 1 ' increase this id by 1
petid = NEWID ' insert the new id
in the id field.
Else
Combo14.Enabled = True
End If
End Sub

Even though this in an auto incrementing index field in mysql, this works.
I do not get the
#DELETED. If on the other hand i manually enter a number, I get the
#DELETED.
I guess some how it gets updated, and mysql allows for an overide and
doesn't auto increment. Please reply and let me know about this, I am new
to mysql, but I have been programming access databases over 6 years, before
that dbase 3+.

> Hello
>
> I can link MS Access (front) with MySQL (back end). However, when I add a
> new record, the previous added record is signed as Deleted record (view in
> Access) even I can view this record in MySQL.
> Please help to go over this...
>
> Thank you
> S.Hoa
>
>




Posted by Jeff North on September 19, 2005, 8:41 am
Please log in for more thread options
On Tue, 5 Jul 2005 14:27:12 +1200, in mailing.database.mysql "shoa"

>| Hello
>|
>| I can link MS Access (front) with MySQL (back end). However, when I add a
>| new record, the previous added record is signed as Deleted record (view in
>| Access) even I can view this record in MySQL.
>| Please help to go over this...
>|
>| Thank you
>| S.Hoa

Check your datatypes compatibility. MSAccess doesn't understand bigint
types and will show the delete message for the field value.
---------------------------------------------------------------
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------


Similar ThreadsPosted
Access and MYSQL May 31, 2006, 9:22 am
FYI: migration from Access to mySQL June 6, 2005, 1:42 pm
MS Access and MySQL databases July 3, 2005, 8:23 pm
Switching from Ms Access to MySql November 13, 2005, 5:21 am
Importing MySQL in MS Access January 31, 2006, 11:23 pm
MS Access, MySQL & MyODBC ..... March 16, 2006, 9:35 am
Connecting to MYSQL via MS Access April 1, 2006, 1:49 pm
ODBC Access -- MySQL (on the web) December 1, 2006, 7:08 am
Data types when using Access with MySQL August 7, 2005, 2:40 pm
Thinking of Access/jet to SQLServer or MySQL November 16, 2005, 11:19 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap