By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,407 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Linked database - mysql & msaccess - autonumber problems.

P: n/a
Hi There,

I hope you can help with this problem I have been having. I have linked
tables from a mysql database and an access database. One of the fields (my
primary key field) is an auto increment in mysql but once I link it to the
access the auto increment field property is lost. This is the case with all
the autoincrement fields that I have linked tables with.
When I add a new record, I have to manually put in the autonumber field and
this is problemetic when I have a lot of tables that are related and many
records. I wanted to know what are the work arounds for this.
Is their something I can put in the access field if a new record is entered
so that I can get the next value ( orginal # + 1) to appear for the new
record.

Looking forward to hearing from you.
Smriti


Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ss
I'm curious about the same thing.
"Smriti Dev" <sm****@sympatico.ca> wrote in message
news:2j*******************@news20.bellglobal.com.. .
Hi There,

I hope you can help with this problem I have been having. I have linked
tables from a mysql database and an access database. One of the fields (my
primary key field) is an auto increment in mysql but once I link it to the
access the auto increment field property is lost. This is the case with all the autoincrement fields that I have linked tables with.
When I add a new record, I have to manually put in the autonumber field and this is problemetic when I have a lot of tables that are related and many
records. I wanted to know what are the work arounds for this.
Is their something I can put in the access field if a new record is entered so that I can get the next value ( orginal # + 1) to appear for the new
record.

Looking forward to hearing from you.
Smriti

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.