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

RECORDSET NOT UPDATABLE

P: n/a
Hi,

I made a database and split it to one back end and one front end. I am
using Access 2000. I put the front end db on my co workers' computers
and the back end on the server. The problem is some of them are not
working because of "recordset is not updatable". Looks like VB is not
working. I don't understand on most of my co workers' computers, the
same database is working fine. On 2 machines, the DB has the same
problem. The Access they are using are all Access 2000, on Win 2000. I
am tinking some of them have Access 2000 SR-1, some not. Is this the
problem? THanks

Jim
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
I'm not 100% certain, but I have gotten that recordset not updateable
message also. I seem to get that message in 2 different circumstances. 1)
when I'm referencing data that is using a crosstab query as it's source and
2) when I open a form that references more than 2 tables (i.e. a query that
pulls data from 3 or more tables). Could it be that your users were looking
at different forms (hence why some can update and some can't?) Just a
suggestion.
<cr*****@msn.com> wrote in message
news:23**************************@posting.google.c om...
Hi,

I made a database and split it to one back end and one front end. I am
using Access 2000. I put the front end db on my co workers' computers
and the back end on the server. The problem is some of them are not
working because of "recordset is not updatable". Looks like VB is not
working. I don't understand on most of my co workers' computers, the
same database is working fine. On 2 machines, the DB has the same
problem. The Access they are using are all Access 2000, on Win 2000. I
am tinking some of them have Access 2000 SR-1, some not. Is this the
problem? THanks

Jim

Nov 12 '05 #2

P: n/a
Yes, I am using the form references a query which pulls 2 tables
together. I tested all dbs on different users, some can, some can't.
One of the users reinstalled Access 2000 SR-1, still not working. It
is weired.

My 2 tables did not have primary key. I just changed that. Still not
working.

"prodirect" <pr*******@comcast.net> wrote in message news:<c5******************************@news.terane ws.com>...
I'm not 100% certain, but I have gotten that recordset not updateable
message also. I seem to get that message in 2 different circumstances. 1)
when I'm referencing data that is using a crosstab query as it's source and
2) when I open a form that references more than 2 tables (i.e. a query that
pulls data from 3 or more tables). Could it be that your users were looking
at different forms (hence why some can update and some can't?) Just a
suggestion.

Nov 12 '05 #3

P: n/a
fp
Just off the top of my head, make sure the non-working users have write
access to the server location that the database resides.

--
******************************
Fred Parker
Lynn Consulting Group, L.L.C.
http://www.lynnconsultinggroup.com
******************************

<cr*****@msn.com> wrote in message
news:23**************************@posting.google.c om...
Hi,

I made a database and split it to one back end and one front end. I am
using Access 2000. I put the front end db on my co workers' computers
and the back end on the server. The problem is some of them are not
working because of "recordset is not updatable". Looks like VB is not
working. I don't understand on most of my co workers' computers, the
same database is working fine. On 2 machines, the DB has the same
problem. The Access they are using are all Access 2000, on Win 2000. I
am tinking some of them have Access 2000 SR-1, some not. Is this the
problem? THanks

Jim

Nov 12 '05 #4

P: n/a
I am sure everybody get the correct path to the back end database. (I
splitted the DB to 2 DBs). The only difference I can see is that the
persons who get Access 2000 installed recently, on their computers,
the DB is working fine. The 2 persons have Access 2000 before, it is
not working. I checked the version, they are all Access 2000 SP-3, I
really don;t know what happened. One guy even tried uninstall Access
2000 and reinstalled using the CD I have, still not working.
"fp" <et****************@hotmail.com> wrote in message news:<7%******************@nwrddc01.gnilink.net>.. .
Just off the top of my head, make sure the non-working users have write
access to the server location that the database resides.

--
******************************
Fred Parker
Lynn Consulting Group, L.L.C.
http://www.lynnconsultinggroup.com

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.