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 4 2436
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.co m> wrote in message
news:23******** *************** ***@posting.goo gle.com... 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
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*******@comc ast.net> wrote in message news:<c5******* *************** ********@news.t eranews.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.
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.co m> wrote in message
news:23******** *************** ***@posting.goo gle.com... 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
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.co m> wrote in message news:<7%******* ***********@nwr ddc01.gnilink.n et>... 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: RP |
last post by:
Hello, in an earlier post I asked about connection.open options. The DSNless
version seemedto work fine, but now I am having trouble getting a record set
to updatable. I am not sure if this has to do with the open method on either
of the recordset or the connection.
I get various version of
"Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Cannot update. Database or object
|
by: Martin van Vliet |
last post by:
Hello,
When I try to run the following code I get an error: "Recordset not
updatable". It is possible to show data from the same table on a webpage, so
the database name and the table nam must be correct. I 've tried several
other things, also leaving out the
adOpenDynamic, adlockOptimistic.
If I run this code as VBA in an Access database, it works without problems.
<%
|
by: Henry Bloom |
last post by:
Hello,
I have two questions:
1. The file-size of my mdb-Database grew extremely large after having
written a lot of VBA-code. I know about the /decompile-option tried it
.... it did not work. Why? what to do now?
2. I have a query producing an updatable dynaset of data. When I tried
opening it in a VBA-routine like
|
by: Bob Darlington |
last post by:
I am using code (simplified for this post) to generate a recordset to which
I want to add a record.
Set rs = db.Openrecordset("SELECT * FROM qVariations WHERE ......")
ws.Begintrans
If rs.Updatable then
rs.AddNew
rs!LAN = vLAN
rs.Update
etc
|
by: kentsoi |
last post by:
i write the code as follow:
when i try to edit text3's content'
the message " this recordset is not updatable" is display.
can anyone tell me what's wrong ???
thanks a lot
*******************************
| |
by: Sim Zacks |
last post by:
I have a postgresql backend with an access front end and I am trying to
redefine the recordset of the form to use an ADO recordset. The problem is
that the CursorType always changes to AdOpenStatic, even if I choose
adOpenDynamic. If anyone has any thoughts, please let me know. The form
works great for viewing, but I cannot update or insert any new records.
Below is the code I am using:
connectstr = "DSN=SAP_PG;uid=postgres"
Set conn...
|
by: zMisc |
last post by:
Are there any tricks in updaitng a JOINed recordset?
I joned to tables and when I try to change a field on the recordset and
update it, I get this error:
"Unknown column 'CCDE' in 'where clause'.
CCDE is a field from one of the table and is not a field I am updating.
I uses MyODBC with VB6 and MySQL 5.
|
by: ZRexRider |
last post by:
I've been reading the newsgroups and most of the solutions for this
message are simple and obvious but unfortunately don't solve my
problem.
I have an MS-Access 2002 ADP application that connects to SQL server.
The application is deployed to 100+ users and in most cases works fine.
I have a sub-set of users (~20) who have an auditing function. They
review transactions entered by the other 100+ and accept or reject
them. There are a...
|
by: ruthboaz |
last post by:
Hi,
I am upgrading the current ms access .mdb file to a .adp with sql server back end.
I have been converted tables, forms, reports to .adp..
The tables are reflected at the server.
a)
I am unable to edit or add any records from the forms, when the data is viewable from sql server connection.
|
by: Charlie |
last post by:
What properties to you set to make a SQL 2005 recordset updatable?
In Access, it's
Recordset.edit
Recordset!FieldName=SomeValue
Recordset.update
Any help is appreciated.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |