Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more

x
?
Solved

Records are not editable in MS Access database project

Posted on 2009-04-13
2
Medium Priority
?
266 Views
Last Modified: 2012-05-06
Hi,
I have a MS Access database project which is connect a SQL server database.
There is a table has a column with "char" format. I found this column can't be edit when I open this database in MS Access. But it will be editable if I change the format to "varchar".
Could someone tell me why?

Many Thanks,
0
Comment
Question by:Jinghui Li
[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
2 Comments
 
LVL 22

Assisted Solution

by:dportas
dportas earned 200 total points
ID: 24133014
Does the table have a key? I don't think Access will allow you to update it otherwise.

Access Data Projects (ADPs) are a legacy technology that Microsoft no longer supports. They are probably best avoided.
0
 

Accepted Solution

by:
Jinghui Li earned 0 total points
ID: 24133023
Yes. it has the primary key.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

649 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