J
Josugar
I created an ADP in Access 2003 to connect to SQL Server Express 8 and
succesfully made the connection.
I also succesfully imported a new table, but when I tried to add records to
the new table, I can not do it. I tried opening the table but the add new
record is disabled.
Then I tried to create an update query as the help states for ADP.
I received the following message:
I red that you cannot make design changes to SQL Server objects
(http://office.microsoft.com/en-us/access/HP052745861033.aspx) but is adding
rows to a table a design change?
Is it possible to make row additions to a table in this scenario?
Thank you in advance
succesfully made the connection.
I also succesfully imported a new table, but when I tried to add records to
the new table, I can not do it. I tried opening the table but the add new
record is disabled.
Then I tried to create an update query as the help states for ADP.
I received the following message:
You have connected to a version of SQL Server later than SQL Server 2000. The >version of Visual Studio or Access that you are using was released before the >version of SQL Server to which you are connected. For this reason, you might >encounter problems.
Please check with Microsoft to see if there is a service pack that you should apply >to Visual Studio or Office in order to get support for the version of SQL Server to >which you are connected.
I red that you cannot make design changes to SQL Server objects
(http://office.microsoft.com/en-us/access/HP052745861033.aspx) but is adding
rows to a table a design change?
Is it possible to make row additions to a table in this scenario?
Thank you in advance