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

Trouble with MsAccess and records above 13000

P: n/a
We run a postgres database (7.4) with an MsAcces(2000) frontend, and since
our last upgrade from 7.2 I have the following problem:
When I try to edit a record in msacces with a high recordnummer, like a
record with a primary key field value of 13000, msacces gives me the error
message that another user has already changed this record...etc.
This happens with and without any triggers on the table.
When I update this record directly on the commandline, there is no problem.
Does anybody know of this problem?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Found it. It's in the dsn-file, I checked the option "Row versioning", and
now it works.

"Gerwin Philippo" <ge****@vernet.nl> schreef in bericht
news:3f*********************@news.xs4all.nl...
We run a postgres database (7.4) with an MsAcces(2000) frontend, and since
our last upgrade from 7.2 I have the following problem:
When I try to edit a record in msacces with a high recordnummer, like a
record with a primary key field value of 13000, msacces gives me the error
message that another user has already changed this record...etc.
This happens with and without any triggers on the table.
When I update this record directly on the commandline, there is no problem. Does anybody know of this problem?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.