RE: SQL 2000 and Access 2002 front end

One possibility would be that after linking the table the table has been
renamed in the ACCESS file. This is sometimes done when an access DB is
upgraded or migrted into a SQL Server backend. Keep in transitions like this
are usually begun by folks in the organization who are learning as they go...
so they may choose to adopt so naming standards in SQL that they never used
in Access... At any rate, you could seeone name in access and it could be
linked to a table names something else in the SQL DB.

Possiblity two - same cause as above, but the access linked table could also
be inlinked to a view in SQL Server - again the link could be renamed to
conform to the naming convention in the access db.

As for having to relink tables to edit records. Does this tend to happen
after you have changed the structure of the table in SQL Server... Usually
when you have added field. I know that in Access 2000 one usually had to
drop and relink a table/view to see and use recently added fields in
underlying table/view. This tends to happen particualy when the new field
noes not allow nulls and since access can not see it it can not place a value
into that field...

any of this sound like what might be happening in your case?

"Xavier" wrote:

> I have a web based application where my reports are run from an access front
> end
> (don't ask but the people who own the application did it this way) my issue
> is the following I have a report that shows all the proper records but:
> If I look at the linked tables used in this report the data does not match
> what is in the tables in SQL.
>
> What could cause a linked table not to show the same information as the
> table in SQL?
>
> I also have an issue where sometimes my database will not allow me to edit a
> record till i delete the linked table and relink it.
>
> any help is greatly apprciated.
.

Relevant Pages

  • Re: Nearest Common Ancestor Report (XDb1s $1000 Challenge)
    ... >the report via SQL Server's Query Analyzer? ... Issue asynchronous command to save RAM table to HD. ... There is no such thing as a "RAM table" in MS SQL ... documantation of SQL Server, avaialble on the CD but can be browsed ...
    (comp.object)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • .Net framework error
    ... Unfortunately the information is very limited and usually the report just ... The application is a front end for a SQL Server 2005 Express database, ... connection string in the app config file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Access using SQL Server only DB
    ... I recommend you re-write that report to use a SQL Pass Through Query so you ... It all works except for one report. ... > of creating such a relationship i SQL Server! ...
    (microsoft.public.access.externaldata)
  • Re: SCAN.EXE - McAfee AntiVirus Software
    ... > | of network computers and have only report summaries sent to be via ... > | Virus Scan Report File ... > | application RemoteProcessLaunch. ...
    (microsoft.public.security.virus)
Loading