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).
Having used MANY tables dating back to 2003, etc in Access 2007 with NO problems with the 'Date()' function I am experiencing multiple failures in Access 2010.
When I first opened these Tables in 2010 the error message 'Unknown function 'Date' in validation expression or default value on tblXXXX' was shown and the Default Value of today's date did not work.
I have now had to disable the Deafult Value of Date() in these tables.
Interestingly, NOT all of my tables are affected but the majority alas are.
There were NO changes made to the tables, the original WORKING databases were simply opened in 2010 after an upgrade.
Why do I always seem to get such niggles / issues after upgrades?!
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".
I hope this has not been answered somewhere before but I could not find it.
Our office is stuck using access 97. For obvious reasons I would like to follow the rest of the world into this century and move to 2010.
Problem is that over the years many people have created many MDBs and not of them them knew what they were doing! It is all a bit messy.
If we start converting databases we will inevitably end up with 2010 front ends linked to 97 tables. I know it is possible to do this and I have done some testing and everything looks okay but does anybody know if this will cause any unexpected side effects? Anything like supported data types across the different versions or anything like that
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.
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.