Subform not allowing edits?

  • Thread starter Thread starter Tim in Boston
  • Start date Start date
T

Tim in Boston

Hello -

I have a problem, that has never been a problem before. I
copy out databases and replace the background table, and
then add a couple of fields to that table. In the past,
once I make that a subform, there have been no problems
editing the data (it's a check box in question here).
However, i cannot check the boxes in the subform now.

Makes no difference if the main form is based on a query
or a table, and I put no locks on anything.
Ideas/suggestions?

Post here for the greater good, but also reply to me
directly - timothy [dot] dube [at] ingenix [dot] com.

Thanks for your help!!

-Tim
 
Just a thought, Tim, but when you copied the database file, is there any
chance that the file's Read Only attribute was set? This can happen, e.g. if
you copy via CD.

If that's not the issue, are you using security (mdw) on this database?

Is the file on a disk or network share that is read-only?
 
Hi Allen -

Nope, for speed reasons I do all of the work on a database
on my desktop before copying it to the network drive for
use. I DBMS-copy a SAS file to an existing database ,
deleting the original table, and rename the new imported
data the original table name. I then a couple of fields
that don't exist in the SAS dataset (including these check-
boxes). I then re-check that all queries and forms are
pulling from the same table name.

Has worked about 15 times in the past, but not this recent
time...

No security on it at all.

Any other ideas/options?

-----Original Message-----
Just a thought, Tim, but when you copied the database file, is there any
chance that the file's Read Only attribute was set? This can happen, e.g. if
you copy via CD.

If that's not the issue, are you using security (mdw) on this database?

Is the file on a disk or network share that is read-only?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a problem, that has never been a problem before. I
copy out databases and replace the background table, and
then add a couple of fields to that table. In the past,
once I make that a subform, there have been no problems
editing the data (it's a check box in question here).
However, i cannot check the boxes in the subform now.

Makes no difference if the main form is based on a query
or a table, and I put no locks on anything.
Ideas/suggestions?

Post here for the greater good, but also reply to me
directly - timothy [dot] dube [at] ingenix [dot] com.

Thanks for your help!!

-Tim
Click to expand...


.
Click to expand...
 
Creating and deleting fields. It's just possible that Name AutoCorrect is
being confused by that process. Make sure the boxes are unchecked under
Tools | Options | General | Name AutoCorrect.

You probably do compact after deleting the old table before
importing/creating the new.

Triple-check the field names and data types. I know I can get things wrong
after a heavy day.

Other than that, the database may be corrupting? Importing into a new mdb
may be worth trying.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi Allen -

Nope, for speed reasons I do all of the work on a database
on my desktop before copying it to the network drive for
use. I DBMS-copy a SAS file to an existing database ,
deleting the original table, and rename the new imported
data the original table name. I then a couple of fields
that don't exist in the SAS dataset (including these check-
boxes). I then re-check that all queries and forms are
pulling from the same table name.

Has worked about 15 times in the past, but not this recent
time...

No security on it at all.

Any other ideas/options?

-----Original Message-----
Just a thought, Tim, but when you copied the database file, is there any
chance that the file's Read Only attribute was set? This can happen, e.g. if
you copy via CD.

If that's not the issue, are you using security (mdw) on this database?

Is the file on a disk or network share that is read-only?

I have a problem, that has never been a problem before. I
copy out databases and replace the background table, and
then add a couple of fields to that table. In the past,
once I make that a subform, there have been no problems
editing the data (it's a check box in question here).
However, i cannot check the boxes in the subform now.

Makes no difference if the main form is based on a query
or a table, and I put no locks on anything.
Ideas/suggestions?

Post here for the greater good, but also reply to me
directly - timothy [dot] dube [at] ingenix [dot] com.

Thanks for your help!!

-Tim
Click to expand...
Click to expand...
Click to expand...
 
Back
Top