Access 2010 Working with Tables
In this lesson, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The business does not have a full time DBA, and has contracted work like that in the past, but I would prefer not to call on such a person for what appears to be simple changes (adding records to tables, etc.).
and I foolishlymentioned that I have some experience with Access, so I have been tasked with all Access problems.
Herein lies the problem: Currently I am working on converting a table and find that the DBA who built these DBs not only hid the nav pane, but apparently has locked the tables for editing as well.
I can get the tables to show with F11 fine, but I need to get around those permissions set on the tables. I am unsure exactly how to go about it with 2010 not having permissions (from what I understand).
DoCmd.OpenReport strReportName, acViewPreview, , strSQL
the report opens fine, but no longer filters like it used to. (In my case I am filtering dates, using the # characters.)
The Access 2007 version and the Access 2010 version are both connecting to the same SQL Server 2008 database. The issues only exist in Access 2010.
* A form which used Me.OrderBy to sort the recordsource crashed Access 2010 after working fine in Access 2003 and 2007.
* Settings for a form's InputParameters which worked fine in Access 2003 and 2007 now crashed Access 2010.
* Access 2010 incorrectly decided that a foreign key id field in a form "cannot be updated because it is an autonumber". In this particular case, the problem does NOT occur if the record source is "Select P.* From dbo.Payment P", which is the table containing an actorID foreign key.
I am able to import the Forms,Modules and On selecting the run macros to Initialise the Database in MS Access 2010(while building ADP),it is giving runtime error'29060'"file not found".
How can I create a login or security to only allow certain users to see certain parts of the database? I have read afew tutorials on this, but there does not seem to be too much information with Access 2010 unless it's providing read only and admin edit options.
Failing that, is it possible touninstall/reinstall just Access? It's part of my Office 2010 Pro installation and doesn't show up by itself in the uninstall programs dialog.
The Table in question has 24670 records and is in the centre of the structure. It records the base data by reference to a date and uses the other tables for the common data.
All other functions of the database work providing reports,
It is as if this one table has been locked in some way.
The database had no problems under Access 2007 and new records could be added to the table in question
Each part of the form is entered into a different table. There is an auto number field to tie the three tables together. One of the tables links to the main form in a one-to-many format for transactions.
The other table is linked one-to-one. It is the one-to-one subform that is not working in 2010.
During data entry the information can be entered in the main form and the subforms with no problems. The problem is that the subform does not display the information after moving to another record.
The data is in the tables correctly. but the form does not display the information from the one-to-one table.