PDA

View Full Version : Solved: SQL database read only



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

DBinPhilly
06-08-2011, 06:22 AM
Figured it out myself. It was just a permissioning problem and I had never worked with SQL Server permissions before.

See ya.