If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unlocking a Database in order to Edit Info
I am trying to unlock a database program in order to edit the information
with no luck. I imported data from FP Bento into something similar to the Home Contents Inventory database template but made from a new Form, then tried to update the information in a cell but had no luck with adding/deleting information. My IT DB rep ( who deals mostly with Oracle) suggested I should find and delete the LDB file which should unlock the database. I did that (at least I think I did) and then tried to work on the cells but am still having the same problem in either the Form or Datasheet view- I can't backspace or add anything new. I created a database of my home inventory on my Mac using Bento by Filemaker and want to share this with my wife on her Office/Access so she can do her own inputting of data while I am deployed. Any suggestions would be grealty appreciated. Thanks, -- RickVA |
#2
|
|||
|
|||
Unlocking a Database in order to Edit Info
There are no 'cells' in Access so I'm confused what you mean?
If you mean you cannot update columns, what happens when you try? Are you getting an error message? Does the screen title say 'read only'. If so, someone else has locked the database. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "RickVA" wrote: I am trying to unlock a database program in order to edit the information with no luck. I imported data from FP Bento into something similar to the Home Contents Inventory database template but made from a new Form, then tried to update the information in a cell but had no luck with adding/deleting information. My IT DB rep ( who deals mostly with Oracle) suggested I should find and delete the LDB file which should unlock the database. I did that (at least I think I did) and then tried to work on the cells but am still having the same problem in either the Form or Datasheet view- I can't backspace or add anything new. I created a database of my home inventory on my Mac using Bento by Filemaker and want to share this with my wife on her Office/Access so she can do her own inputting of data while I am deployed. Any suggestions would be grealty appreciated. Thanks, -- RickVA |
#3
|
|||
|
|||
Unlocking a Database in order to Edit Info
Dorian,
What I mean is that I cannot go into each column to update or delete information. I can't backspace, I can't type. Nothing. There are no Error messages and the file is not Read Only. -- RickVA "Dorian" wrote: There are no 'cells' in Access so I'm confused what you mean? If you mean you cannot update columns, what happens when you try? Are you getting an error message? Does the screen title say 'read only'. If so, someone else has locked the database. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "RickVA" wrote: I am trying to unlock a database program in order to edit the information with no luck. I imported data from FP Bento into something similar to the Home Contents Inventory database template but made from a new Form, then tried to update the information in a cell but had no luck with adding/deleting information. My IT DB rep ( who deals mostly with Oracle) suggested I should find and delete the LDB file which should unlock the database. I did that (at least I think I did) and then tried to work on the cells but am still having the same problem in either the Form or Datasheet view- I can't backspace or add anything new. I created a database of my home inventory on my Mac using Bento by Filemaker and want to share this with my wife on her Office/Access so she can do her own inputting of data while I am deployed. Any suggestions would be grealty appreciated. Thanks, -- RickVA |
#4
|
|||
|
|||
Unlocking a Database in order to Edit Info
Try creating a brand new empty database, then importing (right click then
choose import in designer) the form and tables (with data) into it. Then retry editing the data. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "RickVA" wrote: Dorian, What I mean is that I cannot go into each column to update or delete information. I can't backspace, I can't type. Nothing. There are no Error messages and the file is not Read Only. -- RickVA "Dorian" wrote: There are no 'cells' in Access so I'm confused what you mean? If you mean you cannot update columns, what happens when you try? Are you getting an error message? Does the screen title say 'read only'. If so, someone else has locked the database. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "RickVA" wrote: I am trying to unlock a database program in order to edit the information with no luck. I imported data from FP Bento into something similar to the Home Contents Inventory database template but made from a new Form, then tried to update the information in a cell but had no luck with adding/deleting information. My IT DB rep ( who deals mostly with Oracle) suggested I should find and delete the LDB file which should unlock the database. I did that (at least I think I did) and then tried to work on the cells but am still having the same problem in either the Form or Datasheet view- I can't backspace or add anything new. I created a database of my home inventory on my Mac using Bento by Filemaker and want to share this with my wife on her Office/Access so she can do her own inputting of data while I am deployed. Any suggestions would be grealty appreciated. Thanks, -- RickVA |
Thread Tools | |
Display Modes | |
|
|