DBinPhilly
06-07-2011, 02:05 PM
I created a .ADP file and imported a bunch of tables from an MS Access database into a SQL Server database that I set up using the Access wizard. That all worked well, but when I try to make changes or additions to the new database, I'm informed that the db is read only.
I've gone into the database using SQL Server 2008 Developer and get the same message when I try to add/change a record.
I'm brand new at SQL Server, so maybe someone can clue me in on how to make these tables (there are a couple of dozen of them) updatable.
thanks
I've gone into the database using SQL Server 2008 Developer and get the same message when I try to add/change a record.
I'm brand new at SQL Server, so maybe someone can clue me in on how to make these tables (there are a couple of dozen of them) updatable.
thanks