[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

Access 2010 behaving strangely

Hi.

I have some issues with Access 2010. Can anyone help? Access refuses to let me delete some fields blaming it on relationships - however none of the fields in the table are linked either in the relationship view or in the query design view (the only query in the database).

It's a 32 bit running on 64 bit Windows 8.
0
Evert Jor
Asked:
Evert Jor
  • 9
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
<Potentially stupid question>
Are these tables local to your Access app, or are they linked to another database, where there are relationships between tables that you can only delete in that database (i.e. not in Access)?

<ok questions>
If local tables, go to Relationships and import all tables, then manually delete all relationships.

If that doesn't work, in each table you're having differences with go into Table Design, click on each column and look at the Lookup tab.  If anything has a display control of Combo Box, you'll have to delete all the Row Sources, as they may be forcing the dependancy.

Good luck.
0
 
Evert JorDVM/ResearcherAuthor Commented:
I also an getting an error telling me that i'm trying to paste beyond the 255 row although i'm on row 10. Any advice? See attachment of both errors.Access-error-saving-table-and-er.pdf
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
In case there are relationships (see above 2nd point), another approach would be to 'wash' the database by creating a blank database and importing all objects, being careful NOT to import any relationships.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Evert JorDVM/ResearcherAuthor Commented:
OK.The relationship view did not use to behave like that in the earlier versions of Access that I have used. They were always visible when I went into the Relationship view once the relationships were made.
0
 
Evert JorDVM/ResearcherAuthor Commented:
So. Now in table design view I'm still unable to delete rows, but I don't get an error message.
When I mark a row and press delete there is a black line displayed for some milliseconds on the arrow. The row isn't deleted.
0
 
Evert JorDVM/ResearcherAuthor Commented:
Display Control = (set as) Text box

Change to another control type and database then?
0
 
Evert JorDVM/ResearcherAuthor Commented:
Characters in some of the threads "here" are changing. How is that?

I mean - the correct
English grammar is changed.
0
 
Evert JorDVM/ResearcherAuthor Commented:
Do you use Google for grammar check?
0
 
Evert JorDVM/ResearcherAuthor Commented:
I wrote: I'm getting an error

and you display:

an getting an error

?
0
 
Evert JorDVM/ResearcherAuthor Commented:
Only local database.
0
 
Jeffrey CoachmanCommented:
Can you post a sample of this database that exhibits this issue?

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Unhide any hidden database objects
10. Compile the code. (From the VBA code window, click: Debug-->Compile)
11. Run the compact/Repair utility.
12. Remove any Passwords and/or security.
13. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
14. Post the explicit steps to replicate the issue.
15. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.
0
 
Evert JorDVM/ResearcherAuthor Commented:
I've used this "washing procedure" many times before. However - in my environment it's quite time consuming to reconnect to all external database tables.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 9
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now