Solved

Records are not editable in MS Access database project

Posted on 2009-04-13
2
243 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 50 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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…

867 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now