Re: Access lock cells

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Is it a Jet table or is it linked table for a file in a different format?
Not all drivers allow editing of a linked table. HTML is one of them.

If it's a Jet table with a locked datasheet, the developer used a tool to
lock it because users were editing the table directly - instead of using the
form, which is the correct method for data input. Either get the developer
to use the same tool to unlock the datasheet or buy another copy of it so you
can lock/unlock the table when you want to.

Chris
Microsoft MVP


James wrote:
I have a table that has some cells in it locked where a user cannot type in it. How can I reverse the lock so my users can type in it? I have looked around in access but there is nothing obvious to make all the cells in a table editable.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200809/1

.

Relevant Pages

  • Re: Local tables or linked local database?
    ... If you send stupid SQL to SQL Server you're going to get a huge ... dataset, too, so I don't see how the developer is *not* responsible. ... The only difference between Jet and a server is that Jet has to get ... Jet will do an index merge and then retrieve only the ...
    (comp.databases.ms-access)
  • Re: Reinstall Microsoft Jet 4.0
    ... The developer at Salabium thinks my copy of Jet is messed up, because the program runs just fine on his pc so he thinks if I reinstall Jet the problem will be solved. ...
    (borland.public.delphi.database.ado)
  • Delphi virtual peer programming?
    ... Borland announced that JBuilder 2006 has 'Virtual peer Programming'. ... This allows a developer to 'share' a project and others ... to collaborate with editing and debugging. ...
    (borland.public.delphi.non-technical)
  • Re: [kde] Konqueror: Web form text field is slow
    ... often I have the proble that when editing text fields (like editing an ... with "non-letter keys" like backspace. ... KDE version is 3.5.5. ... Kevin Krammer, KDE developer, xdg-utils developer ...
    (KDE)
  • Re: Possible to tell what data type a control on a form contains?
    ... developer to modify that behavior. ... have a small unbound form to collect the data for the required ... record is loaded in the main form with all the fields for editing. ... the data editing form, which can be simple and completely codeless, ...
    (comp.databases.ms-access)