Error Message ''The record set is not Updeteable ???'' in my FORM

  • Thread starter Patrick Carbonneau
  • Start date
P

Patrick Carbonneau

Hello,

I have a problem..I have setup my database (Datasheet) and I have design a
new FORM.. Here an example..I have a field (Lookup) and I was try to import
them in my form no problem at all...but when I select (FORM VIEW) I go this
message
 
J

John W. Vinson

Hello,

I have a problem..I have setup my database (Datasheet) and I have design a
new FORM.. Here an example..I have a field (Lookup) and I was try to import
them in my form no problem at all...but when I select (FORM VIEW) I go this
message
Click to expand...

Please give us a little more information. We cannot see your computer.

A database is not a datasheet. A Datasheet is one of several ways of
displaying data in a Table. A Form is a different way of displaying data.

You can't "import" a field in a Form so I really have no idea what you mean
here.

What is the Form's Recordsource?
What are you "importing" and how?

John W. Vinson [MVP]
 
P

Patrick Carbonneau

Hello John,

Thanks to reply..here more accurate problem about


Initially, I created a new table that contain more than 20 columns of data
in which
I have attachement for pictures and hyperlink for playing AVI files. The
other table
that I created is FORM and this where when I select (FORMVIEW) I cannot select
my data field without have an error message like this:
*** The Recorset is not updateable ***



----------------------------------------------------------------------------------------------
TABLE
Created 2007-04-24
Modified 2007-05-02
Owner:Admin

C:/Document and Setting/Patrice Carbonneau/ARCHITECTURE (database) Prequots
$ Form.accdb

This is bizarre but there 3 similar files but this one has been is LOCKED

Access Record-locking Information
Date Modified 2007-05-02
Size 64bytes
----------------------------------------------------------------------

What is the Form's Recordsource?............ I DONT WHERE I CAN FOUND THIS ?


What are you "importing" and how?

I am importing new fields like: (Simple Lookup List) or normal by select
ADD EXISTING FIELDS
 
A

Aaron Kempf

Access MDB does this randomly

move to a real database, like SQL Server for example
 
Top