?
Solved

Access 2010 behaving strangely

Posted on 2013-01-23
12
Medium Priority
?
319 Views
Last Modified: 2013-04-04
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
Comment
Question by:Evert Jor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 2
12 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 38811367
<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
 

Author Comment

by:Evert Jor
ID: 38811484
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
 
LVL 66

Accepted Solution

by:
Jim Horn earned 1500 total points
ID: 38811520
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:Evert Jor
ID: 38811592
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
 

Author Comment

by:Evert Jor
ID: 38811611
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
 

Author Comment

by:Evert Jor
ID: 38811947
Display Control = (set as) Text box

Change to another control type and database then?
0
 

Author Comment

by:Evert Jor
ID: 38811969
Characters in some of the threads "here" are changing. How is that?

I mean - the correct
English grammar is changed.
0
 

Author Comment

by:Evert Jor
ID: 38811975
Do you use Google for grammar check?
0
 

Author Comment

by:Evert Jor
ID: 38811983
I wrote: I'm getting an error

and you display:

an getting an error

?
0
 

Author Comment

by:Evert Jor
ID: 38811992
Only local database.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38856941
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
 

Author Closing Comment

by:Evert Jor
ID: 39046590
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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question