Re: Access "lost" updatable connection

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I came to pretty much the same conclusions. The network folks and the SQL
DBAs are quite certain they haven't done anything...

Isn't confidence admirable?

Thanks for the leads.

Jeff

"Jerry Whittle" <JerryWhittle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FC989DC6-A02D-4D1C-8FF9-3E062EED8524@xxxxxxxxxxxxxxxx
Hi Jeff,

If it's not the FE, then it must be the BE or something in between them.
I'd
check if there have been any changes to security or permission settings on
the SQL Server database or the network where it resides. I'd also check if
MS
did any recent updates to that server or even your PCs. The automatic
updates
ususally happen on Tuesday evenings.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Jeff Boyce" wrote:

Access 2002, fully service-packed, with linked SQL-Server 2000 tables.

Somewhere between Wednesday morning (everything worked as expected) and
Thursday, sometime, the front-end Access .mdb file "forgot" that a couple
of
the SQL-Server tables were supposed to be updatable. Refreshing the link
to
those did not make a difference -- the tables were not updatable (no
adds,
no edits).

Adding a new link to the table, and ensuring that the Primary Key field
was
identified, creates an undatable connection to the SQL-Server table.

But nothing was changed in the front-end?! Any ideas how this could have
happened?

(and just in case you wondered, the same problem cropped up in multiple
front-ends, on multiple PCs. The only thing those separate, independent
installations have in common is the back-end.)

Thanks for any ideas/leads

Jeff Boyce


.

Relevant Pages

  • Re: Slow response from MS access report
    ... problem of SQL-Server. ... procedure from SQL-Server if you have atypical parameters. ... We use MS Access form to post records to SQL 7 database, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Connection with .udl and domain accounts
    ... work because it's not recognised by SQL-Server as a valid User Id. ... difference between a SQL account and a domain account. ... Login account using a SQL Login name and password that will ...
    (microsoft.public.sqlserver.connect)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: A97 to SQL?
    ... The access/JET back-end is on the same LAN that your SQL-Server would be. ... What size of job would this be for a competent SQL person? ... reasonable level of expertise in access (well A97 anyway) in this way. ...
    (microsoft.public.access.conversion)
  • Re: A97 to SQL?
    ... If you find someone who can lend a hand on the SQL-Server side AND is ... First step is to find myself an SQL person: better get the phone book out! ... performance by breaking a very complex, multi-table query into individual ... we do not have a SQL-Server/DBA guru in-house. ...
    (microsoft.public.access.conversion)