I am not able to edit tables through MS Access grid that is linked to sql
server 2000. I am able to edit some tables but not all.
Can you please tell me how I could change this so that I am able to edit all
the tables.
Thanks
> I am not able to edit tables through MS Access grid that is linked to sql
> server 2000. I am able to edit some tables but not all.
> Can you please tell me how I could change this so that I am able to edit
all
> the tables.
I guess you don't have Primary Key constraints on tables you cannot modify.
Check this first.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
Showing posts with label grid. Show all posts
Showing posts with label grid. Show all posts
Tuesday, March 27, 2012
Cannot edit MS Access tables that are linked to SQL Server 2000
I am not able to edit tables through MS Access grid that is linked to sql
server 2000. I am able to edit some tables but not all.
Can you please tell me how I could change this so that I am able to edit all
the tables.
Thanks> I am not able to edit tables through MS Access grid that is linked to sql
> server 2000. I am able to edit some tables but not all.
> Can you please tell me how I could change this so that I am able to edit
all
> the tables.
I guess you don't have Primary Key constraints on tables you cannot modify.
Check this first.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
server 2000. I am able to edit some tables but not all.
Can you please tell me how I could change this so that I am able to edit all
the tables.
Thanks> I am not able to edit tables through MS Access grid that is linked to sql
> server 2000. I am able to edit some tables but not all.
> Can you please tell me how I could change this so that I am able to edit
all
> the tables.
I guess you don't have Primary Key constraints on tables you cannot modify.
Check this first.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
Cannot edit MS Access tables that are linked to SQL Server 2000
I am not able to edit tables through MS Access grid that is linked to sql
server 2000. I am able to edit some tables but not all.
Can you please tell me how I could change this so that I am able to edit all
the tables.
Thanks> I am not able to edit tables through MS Access grid that is linked to sql
> server 2000. I am able to edit some tables but not all.
> Can you please tell me how I could change this so that I am able to edit
all
> the tables.
I guess you don't have Primary Key constraints on tables you cannot modify.
Check this first.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
server 2000. I am able to edit some tables but not all.
Can you please tell me how I could change this so that I am able to edit all
the tables.
Thanks> I am not able to edit tables through MS Access grid that is linked to sql
> server 2000. I am able to edit some tables but not all.
> Can you please tell me how I could change this so that I am able to edit
all
> the tables.
I guess you don't have Primary Key constraints on tables you cannot modify.
Check this first.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
Subscribe to:
Posts (Atom)