10 total posts
If I recall the download version is indeed a demo.
And you can't use it to edit tables. You'll need the "real" version from Microsoft installed from their CD to gain full access (pun unintentional) to said files.
Actually, I purchased it, not downloaded it.
I did not mean to say I downloaded it. My mistake. We have the full copy of MS Office 2007 Ultimate and still have this problem.
"I don't want to create a new file."
Sorry, I'd just follow that instruction and move forward. I'm sure some won't do that so they'll be stuck.
There is a reason why some of the demo databases are like this. It's so people (other users on the machine) can start from there and move forward. It's also a bad idea to edit the example databases since they are not in a good directory for you to backup.
I could go on about this but you might be stuck on that "I don't want to create a new file" and I won't be able to help.
Not a demo database.
hey Bob, thanks for your quick reply, but the database is one I created from scratch, from a blank database, not a demo.
I added tables, fields, and records and then saved the file. When I reopened Access 2007, I get this. Now, the weird thing is that it only happens sometimes. I don't understand why. So, in other words, I open my database in Access 2007 and get this message and the read-only state. I close it and go through this maybe 2 or 3 times before I can make changes. I cannot understand why this happens sometimes, and not always or never.
That's 2 corrections so far.
Your first post noted one thing and I was incorrect. I was also unaware of the database particulars and since it was a new install (your words) I took that and what happens to some to piece together the usual picture.
Since it's a bug, call Microsoft and see if they offer a patch for this issue.
Remember that if said file is on a shared drive, Access may have the next person open in read only, but you haven't written about networks so I'll stop why this is an issue here.
File is on my PC, but PC still on a shared network.
Thanks Bob, you are pointing me in the right direction Now, it is on my local C: drive and the folder itself is not shared, but my PC is in my company network.
Now, a little more background, I am connecting to it with ASP.NET. So, the ACCDB file sits on c:\inetpub\wwwroot\ which is created by Internet Information Server.
Any suggestions there?
Since you are running IIS
Which I can only GUESS from your post then it will lock the file and you'll get the message.
This is not a bug but what happens. I'll share we ejected Access for use with web servers (along with IIS) and moved to the more stable and extendable MySQL, Apache combo. No file locks there.
-> Again, all appears to be working proper from what you wrote in your last post. IIS has your file locked.
Thanks. I will change the DSN and see if that helps
Maybe being under IIS is doing it. I will move the database and create a new DSN!
Thanks for your help, Bob.
Bob, exact same problem.
IIS has your file locked, create new DSN? I know IIS is Internet Information Center, but, DSN I think is Data Source Name???
Please explain the steps that were involeved in unlocking IIS and the creation of a new DSN...