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

x
?
Solved

Records are not editable in MS Access database project

Posted on 2009-04-13
2
Medium Priority
?
267 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
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

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

834 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