Anyone have any reason why I can open a table in SQL Enterprise manager,
return all rows, and edit the record set, but when I go in through an ADP,
connect to the database, and try to edit the same table, it tells me that
the table is read only. What gives? There are other tables in this
database that I'm able to modify just fine.
-B 4 2360
"dp" <no****@mrspam.com> wrote in message
news:Xt*******************@nwrddc01.gnilink.net... Anyone have any reason why I can open a table in SQL Enterprise manager, return all rows, and edit the record set, but when I go in through an ADP, connect to the database, and try to edit the same table, it tells me that the table is read only. What gives? There are other tables in this database that I'm able to modify just fine.
-B
Does this table have a primary key? If not, you will not be able to update
via the adp.
Fletcher
On Mon, 12 Jan 2004 16:55:00 +0000 (UTC), "Fletcher Arnold" <fl****@home.com>
wrote: "dp" <no****@mrspam.com> wrote in message news:Xt*******************@nwrddc01.gnilink.net.. . Anyone have any reason why I can open a table in SQL Enterprise manager, return all rows, and edit the record set, but when I go in through an ADP, connect to the database, and try to edit the same table, it tells me that the table is read only. What gives? There are other tables in this database that I'm able to modify just fine.
-B
Does this table have a primary key? If not, you will not be able to update via the adp.
Just to clarify and be nit picky, that actually applies only when updating via
recordsets. If you execute a SQL update statement from an ADP by running a
stored procedure or an ADO Command, updating works.
Fletcher
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:6n********************************@4ax.com... On Mon, 12 Jan 2004 16:55:00 +0000 (UTC), "Fletcher Arnold"
<fl****@home.com> wrote:
"dp" <no****@mrspam.com> wrote in message news:Xt*******************@nwrddc01.gnilink.net.. . Anyone have any reason why I can open a table in SQL Enterprise
manager, return all rows, and edit the record set, but when I go in through an
ADP, connect to the database, and try to edit the same table, it tells me
that the table is read only. What gives? There are other tables in this database that I'm able to modify just fine.
-B
Does this table have a primary key? If not, you will not be able to
updatevia the adp.
Just to clarify and be nit picky, that actually applies only when updating
via recordsets. If you execute a SQL update statement from an ADP by running
a stored procedure or an ADO Command, updating works.
I imagined the OP was trying to update the table directly in the database
window - but, true, that wasn't explicitly stated. Perhaps we will get some
feedback ideally of the form "Thanks - that fixed it".
Not directed at any specific instance, but just as a comment:
If there is one thing that discourages me from posting (more than the
in-fighting and ugly squabbles which occasionally break out) it is the lack
of feedback from OP's. "Thanks in advance" is nowhere near as good as
"Thanks - that fixed it". A large percentage of the time, you never even
know if your advice was even read - let alone heeded - let alone
appreciated.
</rant>
Fletcher
On Mon, 12 Jan 2004 22:38:44 +0000 (UTC), "Fletcher Arnold" <fl****@home.com>
wrote: "Steve Jorgensen" <no****@nospam.nospam> wrote in message news:6n********************************@4ax.com.. . On Mon, 12 Jan 2004 16:55:00 +0000 (UTC), "Fletcher Arnold"<fl****@home.com> wrote:
> >"dp" <no****@mrspam.com> wrote in message >news:Xt*******************@nwrddc01.gnilink.net.. . >> Anyone have any reason why I can open a table in SQL Enterprisemanager, >> return all rows, and edit the record set, but when I go in through anADP, >> connect to the database, and try to edit the same table, it tells methat >> the table is read only. What gives? There are other tables in this >> database that I'm able to modify just fine. >> >> -B > > >Does this table have a primary key? If not, you will not be able toupdate >via the adp.
Just to clarify and be nit picky, that actually applies only when updating via recordsets. If you execute a SQL update statement from an ADP by running a stored procedure or an ADO Command, updating works.
I imagined the OP was trying to update the table directly in the database window - but, true, that wasn't explicitly stated. Perhaps we will get some feedback ideally of the form "Thanks - that fixed it".
Oh, don't get me wrong. I was agreeing with your reply, and I'm certain it is
the appropriate answer in this case. I just wanted to add, for posterity,
that in the rare case where you may want to update a back-end table from and
Access app only via a stored procedure ot Insert/Update statement, a primary
key is not a requirement.
Not directed at any specific instance, but just as a comment: If there is one thing that discourages me from posting (more than the in-fighting and ugly squabbles which occasionally break out) it is the lack of feedback from OP's. "Thanks in advance" is nowhere near as good as "Thanks - that fixed it". A large percentage of the time, you never even know if your advice was even read - let alone heeded - let alone appreciated. </rant>
Agreed. After providing assistance, it's nice to get feedback on whether that
was helpful. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Alex |
last post by:
Hello,
I have a rather large table in MS SQL 2000 that I'm writing reports in
Crystal from, but I'm unsure how to get the various data files (from
different departments) into the table. Below...
|
by: David Berman |
last post by:
I'm having a problem with an update operation in a stored procedure. It
runs so slowly that it is unusable, unless I comment a part out in which
case it is very fast. However, I need the whole...
|
by: Jay Chan |
last post by:
We have just installed a SQL Server 2000 (SP 3A) onto a computer that
has Windows-2003 Server on it. Now, we cannot get access to that
database server from other computers. Seem like this may be an...
|
by: Robert M. |
last post by:
Information:
Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
Enterprise Edition. SQL Service pack is 3a. Member of domain
ABCDomain. Server A is going to function as a...
|
by: MrDom |
last post by:
I am wondering if someone can help solve this question I have a table
in sql server 2000, I setup it using Enterprise manager.
When I generate an SQL Script for this table it scripts as:
...
|
by: Silas |
last post by:
Hi,
I use view to join difference table together for some function. However,
when the "real" table fields changed (e.g. add/delete/change field). The
view table still use the "old fields".
...
|
by: Zorba.GR |
last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
|
by: Smutny30 |
last post by:
Hello,
I am preparing a database that will store 10 n * GBs - 100 n * GBs of data.
I calculated to have 1,2 GB of bufferpools. I run the DB2 v. 8.2.1 alone on
4 GB box.
I obtain :
...
|
by: rubeel |
last post by:
I cannot seem to connect to this Instance locally which was i able to
in the past. I can connect to the instance from out side. The instance
is running and the DBs in the instance are available and...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
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...
|
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)...
|
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...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
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
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
| | |