jwcolby
jwcolby at colbyconsulting.com
Mon Apr 14 09:37:51 CDT 2008
Further to this, I opened my access billing mdb (FE) in a directory under my jwcolby directory, modified a module, and then couldn't save it. I closed, right clicked the directory and unchecked the read-only of the directory. It went through and processed all the files and folders underneath. I could then edit and save a module in that same Access FE. I then copied that entire directory back to the C: drive and I could no longer edit a module in that FE. I copied the entire directory back to my jwcolby directory and tried the edit / save and it worked. So there is definitely something about "directly under the C: drive". jwcolby wrote: > Well... I have to say "I don't think so". The problem is that this is > Vista, and I do not yet understand Vista. > > Let's take some examples: > > I tried to unzip a file directly into a directory in the C: drive of > this machine. The unzip failed saying that it was read-only. I copied > the zip to my documents directory and could unzip it there. I had to > ask permission to copy the unzipped contents back to that directory. > > OTOH, I have an Access database FE in the same directory that I am > trying to run this SQL Server DB from. I can open that MDB and modify > it, so that mdb file is not read-only and I have permission to do that. > > The folder itself is marked read-only from the properties window. When > I tell it to set it to not read-only it goes off without complaint to > start marking all the files and folders underneath that directory as not > read-only, but the folder itself is still read-only when it is done. > > So I don't have a clue what Vista / SQL Server is doing in this case. > What I do know is that if I move the files off to a thumb drive they > will attach just fine so it is SOMETHING about the C: drive in particular. > > Asger Blond wrote: >> John, >> Does the service account for your SQL Server have read/write permission on >> the folder hosting your database? >> >> Asger >> >> -----Oprindelig meddelelse----- >> Fra: dba-sqlserver-bounces at databaseadvisors.com >> [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af jwcolby >> Sendt: 14. april 2008 15:36 >> Til: Dba-Sqlserver >> Emne: [dba-SQLServer] Unable to open billing database >> >> I have rather an emergency here. I am trying to get at my billing >> database which runs through an Access FE attached to tables in a SQL >> Server database. This was all working for many years on my old XP >> machine. The database was created in SQL Server Express AFAICR. >> >> When my laptop died I received a new one from Dell, and I installed >> Vista on it. I also installed Visual Studio 2008 in preparation for >> going there. It apparently installed PARTS of SQL Server 2005 and SQL >> Server Express. >> >> Management studio was NOT installed, so first I tried to install SQL >> Server 2005 but it told me that I could not install the user interface >> because what I already had installed was newer than what I was trying to >> install, however AFAICT Management Studio was NOT installed. Needless >> to say not having management studio is causing me problems doing >> anything with SQL Server. >> >> I subsequently downloaded and installed Management studio express which >> DID install. However (and here comes the problem) when I try to attach >> the billing database I get a message saying: >> >> >> An exception occurred while executing a Transact-SQL statement or batch. >> (Microsoft.SqlServer.Express.ConnectionInfo) >> >> ------------------------------ >> >> Unable to open the physical file "C:\Colby >> Consulting\C2DbBilling\C2DbBilling.mdf". Operating system error 5: >> "5(Access is denied.)". (Microsoft SQL Server, Error: 5120) >> >> Unfortunately so much has changed that I have no clue where to start >> troubleshooting this problem. I googled the error but ended up with a >> bunch of "SQL Server can't start" stuff, but SQL Server is running as is >> Management Studio Express. >> >> Any ideas where to start figuring this thing out. My billing database >> is locked up in SQL Server at the moment and I can't get at it. >> >> 8-( >> >> John W. Colby >> www.ColbyConsulting.com >> _______________________________________________ >> dba-SQLServer mailing list >> dba-SQLServer at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >> http://www.databaseadvisors.com >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> _______________________________________________ >> dba-SQLServer mailing list >> dba-SQLServer at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >> http://www.databaseadvisors.com >> >> > -- John W. Colby www.ColbyConsulting.com