Re: Subform not allowing edits?
From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 02/12/04
- Next message: Mike Thomas: "Why Would Form Become Invisible opr Covered by SubFornm"
- Previous message: RH: "Re: Autonumber"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: Subform not allowing edits?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 13 Feb 2004 00:42:24 +0800
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. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. <anonymous@discussions.microsoft.com> wrote in message news:f79101c3f184$1e9eb340$a601280a@phx.gbl... > 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? > > > >"Tim in Boston" <anonymous@discussions.microsoft.com> > wrote in message > >news:e9d901c3f0bf$0e4887c0$a401280a@phx.gbl... > >> > >> 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
- Next message: Mike Thomas: "Why Would Form Become Invisible opr Covered by SubFornm"
- Previous message: RH: "Re: Autonumber"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: Subform not allowing edits?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
