Running SQL 2000 and Access 2000 in Windows 2000 OS.
Using ODBC drivers was able to edit SQL tables in Access
until 2 weeks ago. Servers were forced reboot one weekend
and have not been able to edit SQL tables in Access
since. Server team has limited SQL experience. Suspect
an option/setting in SQL. Where would I look?

First, check out the DSN and see if you can connect at all. If not,
then write down the error message and take it to your dba. If you're
connecting via code using a connection string, then make sure it's
still valid.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Sun, 19 Oct 2003 13:41:35 -0700, "vseale"
<anonymous@discussions.microsoft.com> wrote:

>Running SQL 2000 and Access 2000 in Windows 2000 OS.
>Using ODBC drivers was able to edit SQL tables in Access
>until 2 weeks ago. Servers were forced reboot one weekend
>and have not been able to edit SQL tables in Access
>since. Server team has limited SQL experience. Suspect
>an option/setting in SQL. Where would I look?

Is the only problem that you can't edit data? Is this with
linked tables? If so, did you try refreshing the links? What
specific error do you get?

-Sue

On Sun, 19 Oct 2003 13:41:35 -0700, "vseale"
<anonymous@discussions.microsoft.com> wrote:

>Running SQL 2000 and Access 2000 in Windows 2000 OS.
>Using ODBC drivers was able to edit SQL tables in Access
>until 2 weeks ago. Servers were forced reboot one weekend
>and have not been able to edit SQL tables in Access
>since. Server team has limited SQL experience. Suspect
>an option/setting in SQL. Where would I look?

I've refreshed the linked tables several times with the
Link Table Manager and tried deleting the links and
relinking. The tables themselves are now read-only. I've
tried doing an edit directly into the linked table and
can't. Error message the "record has been updated since
by another user and I can copy it into clipboard for later
update". I am the only working in these tables. (By the
way, we have no DBA to help administrate this, we
installed SQL to stabilize the data that had previously
been created in Access and have limited SQL experience.)
>-----Original Message-----
>Is the only problem that you can't edit data? Is this with
>linked tables? If so, did you try refreshing the links?
What
>specific error do you get?
>
>-Sue
>
>On Sun, 19 Oct 2003 13:41:35 -0700, "vseale"
><anonymous@discussions.microsoft.com> wrote:
>
>>Running SQL 2000 and Access 2000 in Windows 2000 OS.
>>Using ODBC drivers was able to edit SQL tables in Access
>>until 2 weeks ago. Servers were forced reboot one
weekend
>>and have not been able to edit SQL tables in Access
>>since. Server team has limited SQL experience. Suspect
>>an option/setting in SQL. Where would I look?
>
>.
>

This can happen with a few different scenarios. Basically,
ODBC will use a timestamp to determine if the record has
been updated. If there is no timestamp column, it compares
all column values to see if the record has been updated.
Some situations can cause Access to become "confused" as to
whether the record has been update - such as having float
data types. Try adding a timestamp column to the SQL table
and see if the fixes the problem. There should be some
Access knowledge base articles on this subject that you may
want to search for.

-Sue

On Tue, 21 Oct 2003 08:38:27 -0700, "vseale"
<anonymous@discussions.microsoft.com> wrote:

>I've refreshed the linked tables several times with the
>Link Table Manager and tried deleting the links and
>relinking. The tables themselves are now read-only. I've
>tried doing an edit directly into the linked table and
>can't. Error message the "record has been updated since
>by another user and I can copy it into clipboard for later
>update". I am the only working in these tables. (By the
>way, we have no DBA to help administrate this, we
>installed SQL to stabilize the data that had previously
>been created in Access and have limited SQL experience.)
>>-----Original Message-----
>>Is the only problem that you can't edit data? Is this with
>>linked tables? If so, did you try refreshing the links?
>What
>>specific error do you get?
>>
>>-Sue
>>
>>On Sun, 19 Oct 2003 13:41:35 -0700, "vseale"
>><anonymous@discussions.microsoft.com> wrote:
>>
>>>Running SQL 2000 and Access 2000 in Windows 2000 OS.
>>>Using ODBC drivers was able to edit SQL tables in Access
>>>until 2 weeks ago. Servers were forced reboot one
>weekend
>>>and have not been able to edit SQL tables in Access
>>>since. Server team has limited SQL experience. Suspect
>>>an option/setting in SQL. Where would I look?
>>
>>.
>>

Sue

Thank you for that post

I have an Access 2000 Front End using SQL Server 200
database

All simple 'static type' tables could be fully maintained -
insert, delete, update etc.

main tables eg client and staff were giving a 'record
updated' message as you describe - the addition of
timestamp did the trick

thank you for your help in posting the solution - I was
beginning to loose hair :-)

Regards
John McCutcheon
>-----Original Message-----
>This can happen with a few different scenarios. Basically,
>ODBC will use a timestamp to determine if the record has
>been updated. If there is no timestamp column, it compares
>all column values to see if the record has been updated.
>Some situations can cause Access to become "confused" as
to
>whether the record has been update - such as having float
>data types. Try adding a timestamp column to the SQL table
>and see if the fixes the problem. There should be some
>Access knowledge base articles on this subject that you
may
>want to search for.
>
>-Sue
>
>On Tue, 21 Oct 2003 08:38:27 -0700, "vseale"
><anonymous@discussions.microsoft.com> wrote:
>
>>I've refreshed the linked tables several times with the
>>Link Table Manager and tried deleting the links and
>>relinking. The tables themselves are now read-only.
I've
>>tried doing an edit directly into the linked table and
>>can't. Error message the "record has been updated since
>>by another user and I can copy it into clipboard for
later
>>update". I am the only working in these tables. (By
the
>>way, we have no DBA to help administrate this, we
>>installed SQL to stabilize the data that had previously
>>been created in Access and have limited SQL
experience.)
>>>-----Original Message-----
>>>Is the only problem that you can't edit data? Is this
with
>>>linked tables? If so, did you try refreshing the links?
>>What
>>>specific error do you get?
>>>
>>>-Sue
>>>
>>>On Sun, 19 Oct 2003 13:41:35 -0700, "vseale"
>>><anonymous@discussions.microsoft.com> wrote:
>>>
>>>>Running SQL 2000 and Access 2000 in Windows 2000 OS.
>>>>Using ODBC drivers was able to edit SQL tables in
Access
>>>>until 2 weeks ago. Servers were forced reboot one
>>weekend
>>>>and have not been able to edit SQL tables in Access
>>>>since. Server team has limited SQL experience.
Suspect
>>>>an option/setting in SQL. Where would I look?
>>>
>>>.
>>>
>
>.
>

Your welcome...glad it worked for you and that you get to
keep your hair.

-Sue

On Thu, 23 Oct 2003 14:03:14 -0700,
<anonymous@discussions.microsoft.com> wrote:

>Sue
>
>Thank you for that post
>
>I have an Access 2000 Front End using SQL Server 200
>database
>
>All simple 'static type' tables could be fully maintained -
>insert, delete, update etc.
>
>main tables eg client and staff were giving a 'record
>updated' message as you describe - the addition of
>timestamp did the trick
>
>thank you for your help in posting the solution - I was
>beginning to loose hair :-)
>
>Regards
>John McCutcheon
>>-----Original Message-----
>>This can happen with a few different scenarios. Basically,
>>ODBC will use a timestamp to determine if the record has
>>been updated. If there is no timestamp column, it compares
>>all column values to see if the record has been updated.
>>Some situations can cause Access to become "confused" as
>to
>>whether the record has been update - such as having float
>>data types. Try adding a timestamp column to the SQL table
>>and see if the fixes the problem. There should be some
>>Access knowledge base articles on this subject that you
>may
>>want to search for.
>>
>>-Sue
>>
>>On Tue, 21 Oct 2003 08:38:27 -0700, "vseale"
>><anonymous@discussions.microsoft.com> wrote:
>>
>>>I've refreshed the linked tables several times with the
>>>Link Table Manager and tried deleting the links and
>>>relinking. The tables themselves are now read-only.
>I've
>>>tried doing an edit directly into the linked table and
>>>can't. Error message the "record has been updated since
>>>by another user and I can copy it into clipboard for
>later
>>>update". I am the only working in these tables. (By
>the
>>>way, we have no DBA to help administrate this, we
>>>installed SQL to stabilize the data that had previously
>>>been created in Access and have limited SQL
>experience.)
>>>>-----Original Message-----
>>>>Is the only problem that you can't edit data? Is this
>with
>>>>linked tables? If so, did you try refreshing the links?
>>>What
>>>>specific error do you get?
>>>>
>>>>-Sue
>>>>
>>>>On Sun, 19 Oct 2003 13:41:35 -0700, "vseale"
>>>><anonymous@discussions.microsoft.com> wrote:
>>>>
>>>>>Running SQL 2000 and Access 2000 in Windows 2000 OS.
>>>>>Using ODBC drivers was able to edit SQL tables in
>Access
>>>>>until 2 weeks ago. Servers were forced reboot one
>>>weekend
>>>>>and have not been able to edit SQL tables in Access
>>>>>since. Server team has limited SQL experience.
>Suspect
>>>>>an option/setting in SQL. Where would I look?
>>>>
>>>>.
>>>>
>>
>>.
>>