RE: SQL 2000 and Access 2002 front end

Simon

No this would not be the case, the table is linked from Access 2002 directly
to the SQL table using ODBC, with no changes at all it will work now and you
close the Access front end and open it again and it will not let you edit in
any way shape or form, if I drop the table and relink it then I can continue
doing work.

another issue I have noticed is that if I run a query in access with a SQL
linked table it does not show me the correct contents of the table but if I
go into enterprize Manager tha data is all there.

what else would you think to look for, Im not an expert in SQL but I can
work my way around it I have been using Access since Ver 2 and Im happy with
it but I need the SQL behind it because of a webbased application which is
what is used for 99% of all this data entry and Access is just a very easy
reporting tool for me to produce
all my needed reports on the fly.

thanks
Xavier

"Simon McLaren" wrote:

> 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

  • A little OT - Quite a rant on microsoft.public.sqlserver.olap
    ... SQL authentication doesn't work for SQL Server to anywhere. ... reports in ADP; but somehow it's not getting traction. ... thru in order to create forms and reports against a database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: crash on virtual dimensions
    ... the most important part about ADP is that the tools in an Access Data ... Proejct are better for writing stored procedures and SQL udfs. ... I wrote MDB with forms and reports for 2 years before getting into ... I was able to get into SQL Server, ...
    (microsoft.public.sqlserver.olap)
  • Re: why>?
    ... MDB are a useful learning tool ... I used them for several years before moving to SQL. ... We've got the most exciting pivotTables anywhere. ... it's each to share reports with others; copy reports; duplicate ...
    (microsoft.public.excel)
  • Re: Faircom c-Tree Server vs. Relational DBMS
    ... Our products were very reliable in terms of how the database ... SQL was used for building and upgrading the ... to process reports that take several hours to run. ... what database tools to use) that are dictated by management ...
    (comp.databases)
  • Re: View or Not Views
    ... SQL Server use the tempdb database to store temporary results and do the required calculations, but its a per-session "table", and you can't access or use these result directly. ... If you really want to access the database in your reports and you always access aggregated data, then create pre-aggregated tables to store the result and use these tables instead of you 500Gb table. ...
    (microsoft.public.sqlserver.olap)
Loading