473,320 Members | 2,041 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,320 software developers and data experts.

ADP Cannot update table, but Enterprise Manager can!

dp
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
Nov 12 '05 #1
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

Nov 12 '05 #2
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


Nov 12 '05 #3
"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
Nov 12 '05 #4
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.
Nov 12 '05 #5

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

Similar topics

2
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...
9
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...
2
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...
2
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...
6
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: ...
4
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". ...
0
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...
22
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 : ...
1
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
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)...
0
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: 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....
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...
0
isladogs
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...

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.