473,322 Members | 1,719 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Linked tables


Hi There,

I sent this last friday & I haven't heard from anyone. I would really
appreciate anyfeedback regarding this problem
I'm having. Your help is much appreciated!!!

Take care,
Smriti

"Smriti Dev" <sm********@utoronto.ca> wrote in message news:...

Hi,

I have a ms access table table which is linked to a mysql database table. I have used a ms access form
to edit records. However, when I attempt to edit a record I get a write
conflict error in ms access. I am using MS ACCESS 2002. The error is 'the
record has been changed by another user since you started editi it.
If you save the record, you will overwrite the changes the other user made'. The Save record button
is greyed out so I can't select that.

I am the only user on editing this record. I would really appreciate some
guidence on how I can go about editing the records.
The mysql database table has the design and field types below.
Thanks so much,
smriti

disability_organization_id mediumint(8) UNSIGNED No
auto_increment
address_id mediumint(8) UNSIGNED Yes 0
name varchar(200) Yes NULL
contact_name varchar(100) Yes NULL
contact_title varchar(50) Yes NULL
mandate text No
target_population text No
affiliations text Yes NULL
disability_assessment tinyint(4) UNSIGNED Yes 0
update_status tinyint(4) UNSIGNED Yes 0
changed tinyint(4) UNSIGNED Yes 0
last_updated date Yes 0000-00-00
abilities_magazine tinyint(4) UNSIGNED Yes 0
needs_checking tinyint(4) UNSIGNED Yes 0
approved tinyint(4) UNSIGNED No 0
added datetime No 0000-00-00 00:00:00
user_id mediumint(8) UNSIGNED No 0
community_id mediumint(8) UNSIGNED No 0
notes text Yes NULL
logo varchar(200) No
CAF_id mediumint(8) UNSIGNED Yes NULL

--
--

Nov 13 '05 #1
1 1701
Smriti Dev wrote:
Hi There,

I sent this last friday & I haven't heard from anyone. I would really
appreciate anyfeedback regarding this problem
I'm having. Your help is much appreciated!!!

Take care,
Smriti

"Smriti Dev" <sm********@utoronto.ca> wrote in message news:...

Hi,

I have a ms access table table which is linked to a mysql database
table. I have used a ms access form
to edit records. However, when I attempt to edit a record I get a
write conflict error in ms access. I am using MS ACCESS 2002. The
error is 'the record has been changed by another user since you
started editi it.


Here is the main issue. In an ODBC link when Access is determining whether
the record has been edited or not it will compare the "before" value of
EVERY field in the table to the value of the fields in the edit buffer. For
certain data types Access can have rounding or other issues that will "fool"
it into thinking a field has been changed even when it has not. This will
cause the message you are seeing. In your case I suspect that it is the text
fields that are causing the problem (if they are similar to a SQL Server
text field (CLOB)).

Now...if you were using SQL Server as a back end you could add a Timestamp
field to the table on the server. A Timestamp is a special binary field
that is updated with a system unique value whenever the record is changed.
When such a field is present Access will only compare the Timestamp column
value instead of comparing all of the other columns and thus the problem is
avoided. The problem is that this work-around is only available for SQL
Server back ends (at least as far as I am aware).

I sometimes get the problem you describe when linking to our UDB400
database, but I do not see it in forms, only when doing an edit directly
against the table link so I have never really investigated how to resolve it
(since I don't normally do edits directly in the link anyway).

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
5
by: pinballjim | last post by:
Hello everyone, I'm looking for a simple way to create a local copy of a linked table. I've got a database that links about 10 tables from other databases. This works fine on my machine, but I...
2
by: Robert McGregor | last post by:
Hi all, I've got a Front End / Back End database that was working just fine. One day i opened the FE to find that if I tried to open one of the linked tables from the database window, nothing...
5
by: b b | last post by:
I created the following code to delete all linked tables in my database (Access 200): -------------------------------------------------------- Dim tbl As TableDef Dim dbs As Database Set dbs...
4
by: Neil Ginsberg | last post by:
I have ODBC linked tables to a SQL 7 database in an A2K database. The linked tables do not have the password stored in them, so the first time the user accesses them, they need to enter the SQL...
7
by: Joe | last post by:
I am using Access 2003 and are linking to an Oracle 9i ODBC datasource (using Oracle ODBC drivers). After linking the tables in Access, I inspect the data contained in the linked tables. For...
3
by: Zlatko Matić | last post by:
Hi! What happens with linked tables if they were linked using File DSN, when I copy the Access file on some other PC without File DSN ? What is the difference between DSN on linked tables and...
2
by: Jill Elaine | last post by:
I am building an Access 2002 frontend with linked tables to an encrypted Paradox 7 database. When I first create these linked tables, I'm asked for the password to the encrypted Paradox database,...
10
by: Jim Devenish | last post by:
I have a split front end/back end system. However I create a number of local tables to carry out certain operations. There is a tendency for the front end to bloat so I have set 'compact on...
25
by: bubbles | last post by:
Using Access 2003 front-end, with SQL Server 2005 backend. I need to make the front-end application automatically refresh the linked SQL Server tables. New tables will be added dynamically in...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.