MySQL/ Access newbie problem: Access DB not editable - please help

OK, I'm very new to this so please be patient.

I posted this to the forums as well. I hope I'm not cross-posting.

I've been using MySQL for about a month using the command line and phpMyAdmin
and that hasn't been to much of a problem so far.

I want to be able to access the MySQL DB from Microsoft Access and add/alter
information. So ...

I downloaded and installed the ODBC driver and made the connection between
Access and my MySQL DB. All well so far.

Then I imported data into my MySQL DB from a csv file. That went OK. However
when I access the data from Access I can view it but I can't add a record or
make alterations. When I try to do it an error box pops up. I'd like to tell you
exactly what it says but I'm working in a Japanese environment and I can't find
the English error message on the Net, but the gist of it is as follows:

Error window title: Data Conflict
Error Message: "This record is being amended by another user. Select 'Save
Record', ignore the other user's amendment and update your amendment"

There's more in the error message underneath but I can't even select the 'Save
Record' dialogue box as it's greyed out.

The strange thing is that I can amend data on other tables and those amendments
are reflected in the MySQL DB.

I have no idea what the problem is.

If you made it this far, thanks for reading and any advice from a more seasoned
MySQL/Access user would be very gratefully received.

Ian

MySQL 5.0.45 on CentOS 5.2; Access 2000 (9.0.8948 SP-3) on Windows XP Pro SP3


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MySQL/ Access newbie problem: Access DB not editable - please

--0016361649e7492e0304704dc096
Content-Type: text/plain; charset=KOI8-R
Content-Transfer-Encoding: quoted-printable

Do you have primary key id (unsigned autoincrement) in your MySQL table?
If not try to add it.

2009/8/4 Ian Masters

> OK, I'm very new to this so please be patient.
>
> I posted this to the forums as well. I hope I'm not cross-posting.
>
> I've been using MySQL for about a month using the command line and
> phpMyAdmin
> and that hasn't been to much of a problem so far.
>
> I want to be able to access the MySQL DB from Microsoft Access and
> add/alter
> information. So ...
>
> I downloaded and installed the ODBC driver and made the connection betwee=
n
> Access and my MySQL DB. All well so far.
>
> Then I imported data into my MySQL DB from a csv file. That went OK.
> However
> when I access the data from Access I can view it but I can't add a record
> or
> make alterations. When I try to do it an error box pops up. I'd like to
> tell you
> exactly what it says but I'm working in a Japanese environment and I can'=
t
> find
> the English error message on the Net, but the gist of it is as follows:
>
> Error window title: Data Conflict
> Error Message: "This record is being amended by another user. Select 'Sav=
e
> Record', ignore the other user's amendment and update your amendment"
>
> There's more in the error message underneath but I can't even select the
> 'Save
> Record' dialogue box as it's greyed out.
>
> The strange thing is that I can amend data on other tables and those
> amendments
> are reflected in the MySQL DB.
>
> I have no idea what the problem is.
>
> If you made it this far, thanks for reading and any advice from a more
> seasoned
> MySQL/Access user would be very gratefully received.
>
> Ian
>
> MySQL 5.0.45 on CentOS 5.2; Access 2000 (9.0.8948 SP-3) on Windows XP Pro
> SP3
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=3Dvladimirbright@gmail.c om
>
>


--=20
åÓÌÉ ÅÓÔØ ÔÒÕÄÎÏ=C5 ÄÅÌÏ, ÐÏÒÕ=
ÞÉÔÅ ÅÇ=CF ÌÅÎÔÑÀ: ÏÎ ÎÁÊÄÅÔ ÂÏ=
ÌÅ=C5 ÌÅÇËÏÅ ÒÅÛÅÎÉ=C5.

--0016361649e7492e0304704dc096--

RE: MySQL/ Access newbie problem: Access DB not editable - please help

>-----Original Message-----
>From: Ian Masters [mailto:ian@acces.co.jp]
>Sent: Tuesday, August 04, 2009 12:46 AM
>To: myodbc@lists.mysql.com
>Subject: MySQL/ Access newbie problem: Access DB not editable - please
>help
>
>
>Then I imported data into my MySQL DB from a csv file. That went OK.
>However
>when I access the data from Access I can view it but I can't add a
>record or
>make alterations. When I try to do it an error box pops up. I'd like to
>tell you
>exactly what it says but I'm working in a Japanese environment and I
>can't find
>the English error message on the Net, but the gist of it is as follows:
>
[JS] I am not sure if this is the exact problem you are having, but I have
had an issue with Access not allowing me to run update queries against MySQL
until I have opened at least one table. Try that.


Regards,
 
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
 
860.674.8796 / FAX: 860.674.8341
 
www.the-infoshop.com







--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MySQL/ Access newbie problem: Access DB not editable - pleasehelp

Vladimir

Thanks for the reply.

I tried that but it didn't help.

I can add new entries to the Access table which are reflected in the=20
corresponding MySQL table but I can't amend any data that I have imported=
from=20
the original CSV file.

Ian

> Do you have primary key id (unsigned autoincrement) in your MySQL table=
?
> If not try to add it.
>=20
> 2009/8/4 Ian Masters >
>=20
> OK, I'm very new to this so please be patient.
>=20
> I posted this to the forums as well. I hope I'm not cross-posting.
>=20
> I've been using MySQL for about a month using the command line and
> phpMyAdmin
> and that hasn't been to much of a problem so far.
>=20
> I want to be able to access the MySQL DB from Microsoft Access and
> add/alter
> information. So ...
>=20
> I downloaded and installed the ODBC driver and made the connection
> between
> Access and my MySQL DB. All well so far.
>=20
> Then I imported data into my MySQL DB from a csv file. That went OK=

> However
> when I access the data from Access I can view it but I can't add a
> record or
> make alterations. When I try to do it an error box pops up. I'd lik=
e
> to tell you
> exactly what it says but I'm working in a Japanese environment and =
I
> can't find
> the English error message on the Net, but the gist of it is as foll=
ows:
>=20
> Error window title: Data Conflict
> Error Message: "This record is being amended by another user. Selec=
t
> 'Save
> Record', ignore the other user's amendment and update your amendmen=
t"
>=20
> There's more in the error message underneath but I can't even selec=
t
> the 'Save
> Record' dialogue box as it's greyed out.
>=20
> The strange thing is that I can amend data on other tables and thos=
e
> amendments
> are reflected in the MySQL DB.
>=20
> I have no idea what the problem is.
>=20
> If you made it this far, thanks for reading and any advice from a
> more seasoned
> MySQL/Access user would be very gratefully received.
>=20
> Ian
>=20
> MySQL 5.0.45 on CentOS 5.2; Access 2000 (9.0.8948 SP-3) on Windows
> XP Pro SP3
>=20
>=20
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: ï¿=BD
> ï¿=BDhttp://lists.mysql.com/myodbc?unsub=3Dvladimirbrigh t@gmail=
com
>=20
>=20
>=20
>=20
> --=20
> ���� ����=
ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿ =BD ï¿=BD=
��ï¿=BD, ����ï¿=BD=
��ï¿=BD ��ï¿=BD ��=
����: �� ��=
���� ����=
ï¿=BD ������ ï¿=BD=
������.




--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: MySQL/ Access newbie problem: Access DB not editable - pleasehelp

Jerry

Thanks fr the reply.

> [JS] I am not sure if this is the exact problem you are having, but I have
> had an issue with Access not allowing me to run update queries against MySQL
> until I have opened at least one table. Try that.

Do you mean I should create a table in Access and link that with MySQL?

Thanks

Ian


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MySQL/ Access newbie problem: Access DB not editable - please help

I had some problems as well if there was no field of type TIMESTAMP in the
table. Try to add one (call it 'timestamp') and see if that helps

regards,
Markus

----- Original Message -----
From: "÷ÌÁÄÉÍÉÒ ÷ÌÁÄÉÍÉÒÏ×ÉÞ"
To: "Ian Masters"
Cc:
Sent: Tuesday, August 04, 2009 11:45 AM
Subject: Re: MySQL/ Access newbie problem: Access DB not editable - please
help


Do you have primary key id (unsigned autoincrement) in your MySQL table?
If not try to add it.

2009/8/4 Ian Masters

> OK, I'm very new to this so please be patient.
>
> I posted this to the forums as well. I hope I'm not cross-posting.
>
> I've been using MySQL for about a month using the command line and
> phpMyAdmin
> and that hasn't been to much of a problem so far.
>
> I want to be able to access the MySQL DB from Microsoft Access and
> add/alter
> information. So ...
>
> I downloaded and installed the ODBC driver and made the connection between
> Access and my MySQL DB. All well so far.
>
> Then I imported data into my MySQL DB from a csv file. That went OK.
> However
> when I access the data from Access I can view it but I can't add a record
> or
> make alterations. When I try to do it an error box pops up. I'd like to
> tell you
> exactly what it says but I'm working in a Japanese environment and I can't
> find
> the English error message on the Net, but the gist of it is as follows:
>
> Error window title: Data Conflict
> Error Message: "This record is being amended by another user. Select 'Save
> Record', ignore the other user's amendment and update your amendment"
>
> There's more in the error message underneath but I can't even select the
> 'Save
> Record' dialogue box as it's greyed out.
>
> The strange thing is that I can amend data on other tables and those
> amendments
> are reflected in the MySQL DB.
>
> I have no idea what the problem is.
>
> If you made it this far, thanks for reading and any advice from a more
> seasoned
> MySQL/Access user would be very gratefully received.
>
> Ian
>
> MySQL 5.0.45 on CentOS 5.2; Access 2000 (9.0.8948 SP-3) on Windows XP Pro
> SP3
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=vladimirbright@gmail.com
>
>


--
åÓÌÉ ÅÓÔØ ÔÒÕÄÎÏÅ ÄÅÌÏ, ÐÏÒÕÞÉÔÅ ÅÇÏ ÌÅÎÔÑÀ: ÏÎ ÎÁÊÄÅÔ ÂÏÌÅÅ ÌÅÇËÏÅ ÒÅÛÅÎÉÅ.


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MySQL/ Access newbie problem: Access DB not editable - please help

>
>> [JS] I am not sure if this is the exact problem you are having, but I
>have
>> had an issue with Access not allowing me to run update queries against
>MySQL
>> until I have opened at least one table. Try that.
>
>Do you mean I should create a table in Access and link that with MySQL?
>
[JS] Are you using ODBC so that Access can update a MySQL database? That is
the situation I have. To do that, you have to import the MySQL tables into
Access as linked tables. That's where I found that I had to open one of the
linked tables before running an Access query to update anything in MySQL. I am
using macros or VB code anyways, so I just open the smallest linked table in
regular data view mode before running any queries that update MySQL tables.

I found this solution by accident. I think it must be a bug in Access,
although I have not had the time or inclination to pursue it.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com







--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MySQL/ Access newbie problem: Access DB not editable - please help

Make sure you unlink/relink the MySQL table in Access after you make =
structural changes to the MySQL table before trying again. I personally =
have never found the TIMESTAMP to be necessary providing the MySQL table =
has a primary key defined.

John Bonnett=20

-----Original Message-----
From: Markus Grossrieder [mailto:markus.grossrieder@tele2.ch]=20
Sent: Thursday, 6 August 2009 10:03 PM
To: myodbc@lists.mysql.com
Subject: Re: MySQL/ Access newbie problem: Access DB not editable - =
please help

I had some problems as well if there was no field of type TIMESTAMP in =
the table. Try to add one (call it 'timestamp') and see if that helps

regards,
Markus

----- Original Message -----
From: "÷ÌÁÄÉÍÉÒ ÷ÌÁÄÉÍÉÒÏ×ÉÞ" =

To: "Ian Masters"
Cc:
Sent: Tuesday, August 04, 2009 11:45 AM
Subject: Re: MySQL/ Access newbie problem: Access DB not editable - =
please help


Do you have primary key id (unsigned autoincrement) in your MySQL table?
If not try to add it.

2009/8/4 Ian Masters

> OK, I'm very new to this so please be patient.
>
> I posted this to the forums as well. I hope I'm not cross-posting.
>
> I've been using MySQL for about a month using the command line and=20
> phpMyAdmin and that hasn't been to much of a problem so far.
>
> I want to be able to access the MySQL DB from Microsoft Access and=20
> add/alter information. So ...
>
> I downloaded and installed the ODBC driver and made the connection=20
> between Access and my MySQL DB. All well so far.
>
> Then I imported data into my MySQL DB from a csv file. That went OK.
> However
> when I access the data from Access I can view it but I can't add a=20
> record or make alterations. When I try to do it an error box pops up.=20
> I'd like to tell you exactly what it says but I'm working in a=20
> Japanese environment and I can't find the English error message on the =

> Net, but the gist of it is as follows:
>
> Error window title: Data Conflict
> Error Message: "This record is being amended by another user. Select=20
> 'Save Record', ignore the other user's amendment and update your =
amendment"
>
> There's more in the error message underneath but I can't even select=20
> the 'Save Record' dialogue box as it's greyed out.
>
> The strange thing is that I can amend data on other tables and those=20
> amendments are reflected in the MySQL DB.
>
> I have no idea what the problem is.
>
> If you made it this far, thanks for reading and any advice from a more =

> seasoned MySQL/Access user would be very gratefully received.
>
> Ian
>
> MySQL 5.0.45 on CentOS 5.2; Access 2000 (9.0.8948 SP-3) on Windows XP=20
> Pro
> SP3
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=3Dvladimirbright@gmail.c om
>
>


--=20
åÓÌÉ ÅÓÔØ ÔÒÕÄÎÏ=C5 ÄÅÌÏ, =
ÐÏÒÕÞÉÔÅ ÅÇ=CF ÌÅÎÔÑÀ: ÏÎ =
ÎÁÊÄÅÔ ÂÏÌÅ=C5 ÌÅÇËÏÅ =
ÒÅÛÅÎÉ=C5.



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: MySQL/ Access newbie problem: Access DB not editable - pleasehelp

Markus

Thanks for the reply.

> I had some problems as well if there was no field of type TIMESTAMP in
> the table. Try to add one (call it 'timestamp') and see if that helps

I tried that but it didn't help.

As I mentioned, I'm a MySQL newbie so it's possible that I'm missing something else.

At the moment my work around is to create an empty table in MySQL, link it to
Access, then paste the data into Access. If I do it that way, I can edit all the
data afterwards.

Thanks anyway.

Ian


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MySQL/ Access newbie problem: Access DB not editable - pleasehelp

> [JS] Are you using ODBC so that Access can update a MySQL database?

Yes, exactly.

> That is
> the situation I have. To do that, you have to import the MySQL tables into
> Access as linked tables. That's where I found that I had to open one of the
> linked tables before running an Access query to update anything in MySQL. I am
> using macros or VB code anyways, so I just open the smallest linked table in
> regular data view mode before running any queries that update MySQL tables.

I'm not sure if I completely understand you but it was by opening one of the
linked tables that I discovered that I couldn't amend data in the table but I
could add new entries.

Thanks

Ian


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MySQL/ Access newbie problem: Access DB not editable - pleasehelp

John

Thanks for the reply.

> Make sure you unlink/relink the MySQL table in Access after you make
> structural changes to the MySQL table before trying again. I personally have
> never found the TIMESTAMP to be necessary providing the MySQL table has a
> primary key defined.

Yes, I always re-link the tables after MySQL structural changes.

Thanks

Ian





--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: MySQL/ Access newbie problem: Access DB not editable - SOLVED!

Markus and everyone who made suggestions.

> I had some problems as well if there was no field of type TIMESTAMP in
> the table. Try to add one (call it 'timestamp') and see if that helps

I thought I had tried the TIMESTAMP fix but I looked at my table and although I
had created a field named Timestamp, it was set to the wrong data type. After I
changed the type to TIMESTAMP and re-imported my data, I was able to edit it!

Thanks everyone. All your help much appreciated.

Ian


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MySQL/ Access newbie problem: Access DB not editable - please help

>> [JS] Are you using ODBC so that Access can update a MySQL database?
>
>Yes, exactly.

>
>I'm not sure if I completely understand you but it was by opening one of
>the
>linked tables that I discovered that I couldn't amend data in the table
>but I
>could add new entries.
>
[JS] Well, that is certainly a major clue! Anything you can do in datasheet
view, you should be able to do with a query, so that's an easy way to test.

I think you have a permissions problem for this user. INSERT permission does
not grant UPDATE permission.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com



>Thanks
>
>Ian





--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MySQL/ Access newbie problem: Access DB not editable - please help

-----Original Message-----
>From: Bonnett, John [mailto:John.Bonnett@vision.zeiss.com]
>Sent: Thursday, August 06, 2009 7:13 PM
>To: markus.grossrieder@tele2.ch; myodbc@lists.mysql.com
>Subject: RE: MySQL/ Access newbie problem: Access DB not editable -
>please help
>
>Make sure you unlink/relink the MySQL table in Access after you make
>structural changes to the MySQL table before trying again. I personally
>have never found the TIMESTAMP to be necessary providing the MySQL table
>has a primary key defined.
>
[JS] I agree with John on both points, except that you don't have to unlink
the tables: just use the link manager to refresh the link. I'm not even sure
you need a primary key, although I've never had any reason to test that.

Regards,
š
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
š
860.674.8796 / FAX: 860.674.8341
š
www.the-infoshop.com



>John Bonnett
>
>-----Original Message-----
>From: Markus Grossrieder [mailto:markus.grossrieder@tele2.ch]
>Sent: Thursday, 6 August 2009 10:03 PM
>To: myodbc@lists.mysql.com
>Subject: Re: MySQL/ Access newbie problem: Access DB not editable -
>please help
>
>I had some problems as well if there was no field of type TIMESTAMP in
>the table. Try to add one (call it 'timestamp') and see if that helps
>
>regards,
>Markus
>
>----- Original Message -----
>From: "÷ÌÁÄÉÍÉÒ ÷ÌÁÄÉÍÉÒÏ×ÉÞ"
>To: "Ian Masters"
>Cc:
>Sent: Tuesday, August 04, 2009 11:45 AM
>Subject: Re: MySQL/ Access newbie problem: Access DB not editable -
>please help
>
>
>Do you have primary key id (unsigned autoincrement) in your MySQL table?
>If not try to add it.
>
>2009/8/4 Ian Masters
>
>> OK, I'm very new to this so please be patient.
>>
>> I posted this to the forums as well. I hope I'm not cross-posting.
>>
>> I've been using MySQL for about a month using the command line and
>> phpMyAdmin and that hasn't been to much of a problem so far.
>>
>> I want to be able to access the MySQL DB from Microsoft Access and
>> add/alter information. So ...
>>
>> I downloaded and installed the ODBC driver and made the connection
>> between Access and my MySQL DB. All well so far.
>>
>> Then I imported data into my MySQL DB from a csv file. That went OK.
>> However
>> when I access the data from Access I can view it but I can't add a
>> record or make alterations. When I try to do it an error box pops up.
>> I'd like to tell you exactly what it says but I'm working in a
>> Japanese environment and I can't find the English error message on the
>> Net, but the gist of it is as follows:
>>
>> Error window title: Data Conflict
>> Error Message: "This record is being amended by another user. Select
>> 'Save Record', ignore the other user's amendment and update your
>amendment"
>>
>> There's more in the error message underneath but I can't even select
>> the 'Save Record' dialogue box as it's greyed out.
>>
>> The strange thing is that I can amend data on other tables and those
>> amendments are reflected in the MySQL DB.
>>
>> I have no idea what the problem is.
>>
>> If you made it this far, thanks for reading and any advice from a more
>> seasoned MySQL/Access user would be very gratefully received.
>>
>> Ian
>>
>> MySQL 5.0.45 on CentOS 5.2; Access 2000 (9.0.8948 SP-3) on Windows XP
>> Pro
>> SP3
>>
>>
>> --
>> MySQL ODBC Mailing List
>> For list archives: http://lists.mysql.com/myodbc To unsubscribe:
>> http://lists.mysql.com/myodbc?unsub=vladimirbright@gmail.com
>>
>>
>
>
>--
>åÓÌÉ ÅÓÔØ ÔÒÕÄÎÏÅ ÄÅÌÏ, ÐÏÒÕÞÉÔÅ ÅÇÏ ÌÅÎÔÑÀ: ÏÎ ÎÁÊÄÅÔ ÂÏÌÅÅ ÌÅÇËÏÅ
>ÒÅÛÅÎÉÅ.
>
>
>
>--
>MySQL ODBC Mailing List
>For list archives: http://lists.mysql.com/myodbc
>To unsubscribe: http://lists.mysql.com/myodbc?unsub=jerry@gii.co.jp





--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MySQL/ Access newbie problem: Access DB not editable - SOLVED!

>-----Original Message-----
>From: Ian Masters [mailto:ian@acces.co.jp]
>Sent: Thursday, August 06, 2009 8:59 PM
>To: Markus Grossrieder
>Cc: myodbc@lists.mysql.com
>Subject: Re: MySQL/ Access newbie problem: Access DB not editable -
>SOLVED!
>
>Markus and everyone who made suggestions.
>
>> I had some problems as well if there was no field of type TIMESTAMP in
>> the table. Try to add one (call it 'timestamp') and see if that helps
>
>I thought I had tried the TIMESTAMP fix but I looked at my table and
>although I
>had created a field named Timestamp, it was set to the wrong data type.
>After I
>changed the type to TIMESTAMP and re-imported my data, I was able to
>edit it!
>
[JS] I believe you have solved your problem accidentally. You do not need a
TIMESTAMP field to edit MySQL data from Access. I suspect that re-linking
your table is what actually solved the problem.

Regards,
 
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
 
860.674.8796 / FAX: 860.674.8341
 
www.the-infoshop.com







--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: MySQL/ Access newbie problem: Access DB not editable - please help

WWVzLCB5b3UgYXJlIHJpZ2h0IEkgZm9yZ290IGFib3V0IHJlZnJlc2hpbmcg bGlua3MuIFlvdSBk
byBuZWVkIHNvbWUgd2F5IEFjY2VzcyBjYW4gdW5pcXVlbHkgaWRlbnRpZnkg cm93cyBpbiB0aGUg
c2VydmVyIHRhYmxlcyBzbyBpdCBjYW4gcmVsaWFibHkgdXBkYXRlIHRoZW0u IFlvdSBwcm9iYWJs
eSBkbyBub3Qgc3RyaWN0bHkgbmVlZCBhIHByaW1hcnkga2V5LCBqdXN0IHNv bWUgY29tYmluYXRp
b24gb2YgY29sdW1ucyB0aGF0IHVuaXF1ZWx5IGlkZW50aWZpZXMgdGhlIHJv d3MuIEEgcHJpbWFy
eSBrZXkgaXMgdGhlIHNpbXBsZXN0IHdheSBvZiBkb2luZyB0aGF0LiBBIHRp bWVzdGFtcCB3aWxs
IGFsc28gcHJvdmlkZSBhIHVuaXF1ZSBjb2x1bW4gZm9yIHRoaXMgcHVycG9z ZS4NCg0KSm9obiBC
b25uZXR0DQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBq c2Nod2FydHpAdGhl
LWluZm9zaG9wLmNvbSBbbWFpbHRvOmpzY2h3YXJ0ekB0aGUtaW5mb3Nob3Au Y29tXSANClNlbnQ6
IEZyaWRheSwgNyBBdWd1c3QgMjAwOSAxMToxMCBQTQ0KVG86ICdCb25uZXR0 LCBKb2huJzsgbWFy
a3VzLmdyb3NzcmllZGVyQHRlbGUyLmNoOyBteW9kYmNAbGlzdHMubXlzcWwu Y29tDQpTdWJqZWN0
OiBSRTogTXlTUUwvIEFjY2VzcyBuZXdiaWUgcHJvYmxlbTogQWNjZXNzIERC IG5vdCBlZGl0YWJs
ZSAtIHBsZWFzZSBoZWxwDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0t DQo+RnJvbTogQm9u
bmV0dCwgSm9obiBbbWFpbHRvOkpvaG4uQm9ubmV0dEB2aXNpb24uemVpc3Mu Y29tXQ0KPlNlbnQ6
IFRodXJzZGF5LCBBdWd1c3QgMDYsIDIwMDkgNzoxMyBQTQ0KPlRvOiBtYXJr dXMuZ3Jvc3NyaWVk
ZXJAdGVsZTIuY2g7IG15b2RiY0BsaXN0cy5teXNxbC5jb20NCj5TdWJqZWN0 OiBSRTogTXlTUUwv
IEFjY2VzcyBuZXdiaWUgcHJvYmxlbTogQWNjZXNzIERCIG5vdCBlZGl0YWJs ZSAtIA0KPnBsZWFz
ZSBoZWxwDQo+DQo+TWFrZSBzdXJlIHlvdSB1bmxpbmsvcmVsaW5rIHRoZSBN eVNRTCB0YWJsZSBp
biBBY2Nlc3MgYWZ0ZXIgeW91IG1ha2UgDQo+c3RydWN0dXJhbCBjaGFuZ2Vz IHRvIHRoZSBNeVNR
TCB0YWJsZSBiZWZvcmUgdHJ5aW5nIGFnYWluLiBJIHBlcnNvbmFsbHkgDQo+ aGF2ZSBuZXZlciBm
b3VuZCB0aGUgVElNRVNUQU1QIHRvIGJlIG5lY2Vzc2FyeSBwcm92aWRpbmcg dGhlIE15U1FMIA0K
PnRhYmxlIGhhcyBhIHByaW1hcnkga2V5IGRlZmluZWQuDQo+DQpbSlNdIEkg YWdyZWUgd2l0aCBK
b2huIG9uIGJvdGggcG9pbnRzLCBleGNlcHQgdGhhdCB5b3UgZG9uJ3QgaGF2 ZSB0byB1bmxpbmsg
dGhlIHRhYmxlczoganVzdCB1c2UgdGhlIGxpbmsgbWFuYWdlciB0byByZWZy ZXNoIHRoZSBsaW5r
LiBJJ20gbm90IGV2ZW4gc3VyZSB5b3UgbmVlZCBhIHByaW1hcnkga2V5LCBh bHRob3VnaCBJJ3Zl
IG5ldmVyIGhhZCBhbnkgcmVhc29uIHRvIHRlc3QgdGhhdC4NCg0KUmVnYXJk cywNCsWhDQpKZXJy
eSBTY2h3YXJ0eg0KVGhlIEluZm9zaG9wIGJ5IEdsb2JhbCBJbmZvcm1hdGlv biBJbmNvcnBvcmF0
ZWQNCjE5NSBGYXJtaW5ndG9uIEF2ZS4NCkZhcm1pbmd0b24sIENUIDA2MDMy DQrFoQ0KODYwLjY3
NC44Nzk2IC8gRkFYOiA4NjAuNjc0LjgzNDENCsWhDQp3d3cudGhlLWluZm9z aG9wLmNvbQ0KDQoN
Cg0KPkpvaG4gQm9ubmV0dA0KPg0KPi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0t LS0tDQo+RnJvbTog
TWFya3VzIEdyb3NzcmllZGVyIFttYWlsdG86bWFya3VzLmdyb3NzcmllZGVy QHRlbGUyLmNoXQ0K
PlNlbnQ6IFRodXJzZGF5LCA2IEF1Z3VzdCAyMDA5IDEwOjAzIFBNDQo+VG86 IG15b2RiY0BsaXN0
cy5teXNxbC5jb20NCj5TdWJqZWN0OiBSZTogTXlTUUwvIEFjY2VzcyBuZXdi aWUgcHJvYmxlbTog
QWNjZXNzIERCIG5vdCBlZGl0YWJsZSAtIA0KPnBsZWFzZSBoZWxwDQo+DQo+ SSBoYWQgc29tZSBw
cm9ibGVtcyBhcyB3ZWxsIGlmIHRoZXJlIHdhcyBubyBmaWVsZCBvZiB0eXBl IFRJTUVTVEFNUCBp
biANCj50aGUgdGFibGUuIFRyeSB0byBhZGQgb25lIChjYWxsIGl0ICd0aW1l c3RhbXAnKSBhbmQg
c2VlIGlmIHRoYXQgaGVscHMNCj4NCj5yZWdhcmRzLA0KPk1hcmt1cw0KPg0K Pi0tLS0tIE9yaWdp
bmFsIE1lc3NhZ2UgLS0tLS0NCj5Gcm9tOiAiw7fDjMOBw4TDicONw4nDkiDD t8OMw4HDhMOJw43D
icOSw4/Dl8OJw54iIDx2bGFkaW1pcmJyaWdodEBnbWFpbC5jb20+DQo+VG86 ICJJYW4gTWFzdGVy
cyIgPGlhbkBhY2Nlcy5jby5qcD4NCj5DYzogPG15b2RiY0BsaXN0cy5teXNx bC5jb20+DQo+U2Vu
dDogVHVlc2RheSwgQXVndXN0IDA0LCAyMDA5IDExOjQ1IEFNDQo+U3ViamVj dDogUmU6IE15U1FM
LyBBY2Nlc3MgbmV3YmllIHByb2JsZW06IEFjY2VzcyBEQiBub3QgZWRpdGFi bGUgLSANCj5wbGVh
c2UgaGVscA0KPg0KPg0KPkRvIHlvdSBoYXZlIHByaW1hcnkga2V5IGlkICh1 bnNpZ25lZCBhdXRv
aW5jcmVtZW50KSBpbiB5b3VyIE15U1FMIHRhYmxlPw0KPklmIG5vdCB0cnkg dG8gYWRkIGl0Lg0K
Pg0KPjIwMDkvOC80IElhbiBNYXN0ZXJzIDxpYW5AYWNjZXMuY28uanA+DQo+ DQo+PiBPSywgSSdt
IHZlcnkgbmV3IHRvIHRoaXMgc28gcGxlYXNlIGJlIHBhdGllbnQuDQo+Pg0K Pj4gSSBwb3N0ZWQg
dGhpcyB0byB0aGUgZm9ydW1zIGFzIHdlbGwuIEkgaG9wZSBJJ20gbm90IGNy b3NzLXBvc3Rpbmcu
DQo+Pg0KPj4gSSd2ZSBiZWVuIHVzaW5nIE15U1FMIGZvciBhYm91dCBhIG1v bnRoIHVzaW5nIHRo
ZSBjb21tYW5kIGxpbmUgYW5kIA0KPj4gcGhwTXlBZG1pbiBhbmQgdGhhdCBo YXNuJ3QgYmVlbiB0
byBtdWNoIG9mIGEgcHJvYmxlbSBzbyBmYXIuDQo+Pg0KPj4gSSB3YW50IHRv IGJlIGFibGUgdG8g
YWNjZXNzIHRoZSBNeVNRTCBEQiBmcm9tIE1pY3Jvc29mdCBBY2Nlc3MgYW5k IA0KPj4gYWRkL2Fs
dGVyIGluZm9ybWF0aW9uLiBTbyAuLi4NCj4+DQo+PiBJIGRvd25sb2FkZWQg YW5kIGluc3RhbGxl
ZCB0aGUgT0RCQyBkcml2ZXIgYW5kIG1hZGUgdGhlIGNvbm5lY3Rpb24gDQo+ PiBiZXR3ZWVuIEFj
Y2VzcyBhbmQgbXkgTXlTUUwgREIuIEFsbCB3ZWxsIHNvIGZhci4NCj4+DQo+ PiBUaGVuIEkgaW1w
b3J0ZWQgZGF0YSBpbnRvIG15IE15U1FMIERCIGZyb20gYSBjc3YgZmlsZS4g VGhhdCB3ZW50IE9L
Lg0KPj4gSG93ZXZlcg0KPj4gd2hlbiBJIGFjY2VzcyB0aGUgZGF0YSBmcm9t IEFjY2VzcyBJIGNh
biB2aWV3IGl0IGJ1dCBJIGNhbid0IGFkZCBhIA0KPj4gcmVjb3JkIG9yIG1h a2UgYWx0ZXJhdGlv
bnMuIFdoZW4gSSB0cnkgdG8gZG8gaXQgYW4gZXJyb3IgYm94IHBvcHMgdXAu DQo+PiBJJ2QgbGlr
ZSB0byB0ZWxsIHlvdSBleGFjdGx5IHdoYXQgaXQgc2F5cyBidXQgSSdtIHdv cmtpbmcgaW4gYSAN
Cj4+IEphcGFuZXNlIGVudmlyb25tZW50IGFuZCBJIGNhbid0IGZpbmQgdGhl IEVuZ2xpc2ggZXJy
b3IgbWVzc2FnZSBvbiANCj4+IHRoZSBOZXQsIGJ1dCB0aGUgZ2lzdCBvZiBp dCBpcyBhcyBmb2xs
b3dzOg0KPj4NCj4+IEVycm9yIHdpbmRvdyB0aXRsZTogRGF0YSBDb25mbGlj dA0KPj4gRXJyb3Ig
TWVzc2FnZTogIlRoaXMgcmVjb3JkIGlzIGJlaW5nIGFtZW5kZWQgYnkgYW5v dGhlciB1c2VyLiBT
ZWxlY3QgDQo+PiAnU2F2ZSBSZWNvcmQnLCBpZ25vcmUgdGhlIG90aGVyIHVz ZXIncyBhbWVuZG1l
bnQgYW5kIHVwZGF0ZSB5b3VyDQo+YW1lbmRtZW50Ig0KPj4NCj4+IFRoZXJl J3MgbW9yZSBpbiB0
aGUgZXJyb3IgbWVzc2FnZSB1bmRlcm5lYXRoIGJ1dCBJIGNhbid0IGV2ZW4g c2VsZWN0IA0KPj4g
dGhlICdTYXZlIFJlY29yZCcgZGlhbG9ndWUgYm94IGFzIGl0J3MgZ3JleWVk IG91dC4NCj4+DQo+
PiBUaGUgc3RyYW5nZSB0aGluZyBpcyB0aGF0IEkgY2FuIGFtZW5kIGRhdGEg b24gb3RoZXIgdGFi
bGVzIGFuZCB0aG9zZSANCj4+IGFtZW5kbWVudHMgYXJlIHJlZmxlY3RlZCBp biB0aGUgTXlTUUwg
REIuDQo+Pg0KPj4gSSBoYXZlIG5vIGlkZWEgd2hhdCB0aGUgcHJvYmxlbSBp cy4NCj4+DQo+PiBJ
ZiB5b3UgbWFkZSBpdCB0aGlzIGZhciwgdGhhbmtzIGZvciByZWFkaW5nIGFu ZCBhbnkgYWR2aWNl
IGZyb20gYSANCj4+IG1vcmUgc2Vhc29uZWQgTXlTUUwvQWNjZXNzIHVzZXIg d291bGQgYmUgdmVy
eSBncmF0ZWZ1bGx5IHJlY2VpdmVkLg0KPj4NCj4+IElhbg0KPj4NCj4+IE15 U1FMIDUuMC40NSBv
biBDZW50T1MgNS4yOyBBY2Nlc3MgMjAwMCAoOS4wLjg5NDggU1AtMykgb24g V2luZG93cyBYUCAN
Cj4+IFBybw0KPj4gU1AzDQo+Pg0KPj4NCj4+IC0tDQo+PiBNeVNRTCBPREJD IE1haWxpbmcgTGlz
dA0KPj4gRm9yIGxpc3QgYXJjaGl2ZXM6IGh0dHA6Ly9saXN0cy5teXNxbC5j b20vbXlvZGJjIFRv
IHVuc3Vic2NyaWJlOg0KPj4gaHR0cDovL2xpc3RzLm15c3FsLmNvbS9teW9k YmM/dW5zdWI9dmxh
ZGltaXJicmlnaHRAZ21haWwuY29tDQo+Pg0KPj4NCj4NCj4NCj4tLQ0KPsOl w5PDjMOJIMOFw5PD
lMOYIMOUw5LDlcOEw47Dj8OFIMOEw4XDjMOPLCDDkMOPw5LDlcOew4nDlMOF IMOFw4fDjyDDjMOF
w47DlMORw4A6IMOPw44gw47DgcOKw4TDhcOUIMOCw4/DjMOFw4Ugw4zDhcOH w4vDj8OFIA0KPsOS
w4XDm8OFw47DicOFLg0KPg0KPg0KPg0KPi0tDQo+TXlTUUwgT0RCQyBNYWls aW5nIExpc3QNCj5G
b3IgbGlzdCBhcmNoaXZlczogaHR0cDovL2xpc3RzLm15c3FsLmNvbS9teW9k YmMNCj5UbyB1bnN1
YnNjcmliZTogICAgaHR0cDovL2xpc3RzLm15c3FsLmNvbS9teW9kYmM/dW5z dWI9amVycnlAZ2lp
LmNvLmpwDQoNCg0KDQoNCg==