Re: Mysterious Disappearing Field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 04/20/04 

Date: Tue, 20 Apr 2004 09:08:47 -0500

Have you queried the field from Query Analyzer or a Pass-Through query in
Access? 

-- 
Duane Hookom
MS Access MVP
--
"Roger Burns" <anonymous@discussions.microsoft.com> wrote in message
news:166101c426b2$5cbde700$a501280a@phx.gbl...
> Hi
> I wonder if anyone out there can help me.  I have an SQL
> database with an Access 97 front end that is used as a
> call logging tool for an IT Helpdesk.  The call logger has
> been in use for roughly six months without any problems,
> but this morning the following happened: For no apparent
> reason all the data held in a field
> called "Details_Of_Call" (SQL Char 4000 - converts to a
> memo field in Access) disappeared.  The field is still
> there but the content has disappeared for every call in
> the database, which is roughly 3500 calls.  The database
> is hidden from the users, so no-one had access to play
> with the base tables - there were no delete queries set up
> on this field and there was also plenty of space available
> on the server which houses the SQL database.  Can anyone
> give me any guidance as to why this has happened and what
> I can do to prevent it happening again?
> Thanks

Relevant Pages

  • Re: Is sql server as good as access 97?
    ... Once you really get into using Query Analyzer for writing your ... Transact-SQL and for formulating 'queries' for exporting to your code, ... resulting stored procedure runs in a small fraction of the time it took to ... Unfortunately the database I am converting ...
    (microsoft.public.sqlserver.programming)
  • Re: Help! How to code an Importing a SQL Tables to Access 2003
    ... I just wrote a query and macro and this works fine. ... The Make Table queries can reside in the database even if the linked ... I use 5 tables in a SQL database. ... I run my queries it slows down the entire system. ...
    (microsoft.public.access.externaldata)
  • Connecting to SQL from Access
    ... I have users who currently query a SQL database using Access and an odbc ... do their own queries. ...
    (microsoft.public.sqlserver.security)
  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)