Access 2007 Opening Files In Read Only
There's possibly a very simple answer to this but it's been boggling my mind all morning and I can't find any answers on the net.
I'm opening a db on a network that was built with Access 2003. When I open it with Access 2003 on one pc it opens fine and I can edit it. But when I open it with Access 2007 I get a message saying that's it's opened the db in read only mode and that if I want to edit it I have to save a copy.
I tried opening the db exclusively but still no luck. Is there a reason why it's doing this and how do I get around it?
Many thanks,
Peter
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Opening Excel Files In Access.
Is it possible to open up excel files from access using a macro?? I have a database where we search for files by job number, we also have individual spreadsheets for these jobs where the job number is the file name. So basically what I want to do is open one of these spreadsheets from a button in one of my forms. thanks, joe
View Replies !
View Related
Trouble Opening Access Files
Hi, I was wondering if i could get some help here. I think this is to do with the security issue. I usually double-click to open or run an access file (for example student.mdb) that sits on the server with no problem. But this time, nothing happen when i did double-clicked on it from my laptop while the file was being open by someone'else on another computer. I know that it makes sense that we shouldn't open a file that's being used by other users. But my curiosity is that should it not give you a warning like (you know) you're not able to save any changes or things like that. No, i didnot get any of that messages. It's just nothing happen after trying to open it by double-clicking it. I have set the macro security to low level but that did not help either. Is there any thing that i need to tweak? Thank you in advance
View Replies !
View Related
Access 2007 Not Opening
Hi All, I've been developing in Access 2002-2003, and now have Access 2007. I can open a 2002-3 .mdb database OK, but when I click on the Main Menu buttons, nothing happens -- they do not work. So I cannot access any of the existing Menus and Forms. In fact, none of the previously existing databases I tried will open/close Forms using the existing buttons. Any ideas? Thanks for any suggestions. 331
View Replies !
View Related
Opening Access 2007 Using Msado15.dll
I have an appplication that reads information from Access Database, it uses ADO (msado15.dll) to open a database using Connection15::Open( ). I am unable to open Access 2007 database using this method. I get the following error: "Microsoft JET Database Engine, Unrecognized database format". Is there something I am doing wrong or I should be aware of? Does msado15.dll support Access 2007 databases? Thank you in advance.
View Replies !
View Related
Error Opening MDB Files On New Setup
I just recently helped a local business move their files to a new server, and reinstall fresh windows and office on all their machines. I have run into a problem with Access, hoping someone can help. Sometimes (usually when someone else has the file open), if you double click on the mdb file (which is on a mapped drive) nothing happens. If you make a shortcut that doesnt help. But if you open Access, and then goto File-Open and located the MDB file that way, it opens fine. This is annoying to the employees and they want a solution. Anyone run into this problem?
View Replies !
View Related
|
TRACKER
