Results 1 to 4 of 4

Thread: Memo problem

  1. #1
    Join Date
    Jul 2005

    Unanswered: Memo problem

    Anytime I enter a value for a memo, I have this error which states I have a "write conflict" then gives me a choice to overwrite or cancel changes.
    If I choose overwrite, all values in database give a weird encryption.

    Any suggestions?

  2. #2
    Join Date
    Apr 2004
    outside the rim
    Any suggestions?
    a tall glass of beer perhaps?

    Is the memo a field in a table? Are you entering the data in a table, query, form or through code? Anything or anybody else in the table at the same time you are? Give us some more details .....


  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    That should have been:

    A tall glass of beer?

    This is a multi-user db?
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Dec 2004
    Madison, WI

    Memo field

    Are you using linked tables? If so, simply add a timestamp field into the table (I don't think jet tables have a timestamp field though). We used SQL Server and linked the tables into Access and had the same kind of problem you described. Once I added a timestamp field (i.e. DataType = TimeStamp) into the SQL Server table (and refreshed the tables in Access), no problems.
    Last edited by pkstormy; 07-21-06 at 11:52.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts