Access 2007 Opening Files In Read Only

Nov 21, 2007

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,


View Replies


Access Files - Read Only - Help Needed

Sep 12, 2005

Access files are locked in read only. We upgraded our network and moved the database to a new network - small business server 2003. Does anyone know why all database files are read only now?

View 2 Replies View Related

General :: Opening Access Database In Code As Read Only

Jul 30, 2013

I am trying to open up an Access database as read-only from another running Access database. The code I have to open the database currently reads:

"""C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE"" ""f:commonpattyTraining Database.mdb", 1)

How do I change to read only?

View 3 Replies View Related

Access 2007 Not Opening

Mar 5, 2007

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.

View 6 Replies View Related

Trouble Opening Access Files

Nov 27, 2006


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 2 Replies View Related

Opening Access 2007 Using Msado15.dll

Dec 1, 2006

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 1 Replies View Related

Modules & VBA :: How To Disable Security Pop Ups When Opening External Files In Access 2010

Aug 1, 2013


I have a button on a form, when it is clicked it opens a video file located in a folder on the local computer. Each time the button is clicked a security pop up appears that says "Opening file://C:lahblahyadayadaFile.mp4 Some files can contain viruses or otherwise be harmful to your computer. It is important to be certain that this file is from a trustworthy source. Would you like to open this file?" options are open or cancel. How can these messages be turned off?

I have already played around in the trust center of Access 2010 and changed the "trusted documents", "trusted locations", and "message Bar" tabs with no results. Do I have to play with regedit in windows to get rid of these pop ups? Or can I somehow use VBA code to disable them?They are just a nescience.

View 2 Replies View Related

Modules & VBA :: Determine File Format Without Opening Database (Using Access 2007)

Jul 15, 2014

Using Access 2007, can I return a value for CurrentProject.FileFormat WITHOUT opening the database?

I'm looking for a way to determine the file version of a given Access database without actually "opening" the database in Access (I don't want it to ever be visible at all or in any way).

So to open a database in Access 2007 "without opening it," I'm using:

Dim db As DAO.Database
Set db = DBEngine.Workspaces(0).OpenDatabase("C:Path-ToFile.accdb")

From here, there are at least two different "version" indicators that can be used, as in this example:

Debug.Print db.Properties("Version").Value
Debug.Print db.Properties("AccessVersion").Value

Now, if you run this code on an Access 2002/2003 .MDB file, you will get:


If you run this code on an Access 2007 .ACCDB file, you get:


Note two important factors:The db.Properties("Version") seems to be returning the JET version from what I can see in research. This is NOT what I'm after.

The db.Properties("AccessVersion") returns THE SAME VALUE for an '07 ACCDB as it does for an '02-'03 MDB, since Microsoft never updated it, apparently.

Now.... the one way that I have found that ACCURATELY describes the version of a given access database file is to use:

Debug.Print CurrentProject.FileFormat this will always return, for example, 2.0 for an Access 2.0 .MDB file; 10 for an Access 2002/03 .MDB file; and 12 for and Access 2007 .ACCDB file (and there are others; these are AcFileFormat bitmask constants as described in Access support).

BUT, this CurrentProject object doesn't seem to be available (so far as I can see) when using the "open without opening" method described above.

SO, is there any way to return the FileFormat value without opening the database visibly? (Merely basing it in the extension isn't right either.... that would be easy but not accurate as several formats use MDB.

View 5 Replies View Related

General :: Database Opening In Read Only Mode

Sep 8, 2013

I am having problems opening my databases. Access automatically opens them in 'Read Only' mode, and I cannot find a way to avoid this - so I can never add data to the original tables ....

View 2 Replies View Related

Opening MDB Files Under Windows 7

Aug 8, 2012

I have a PC with Windows 7. I installed Access 2003 (which opens OK) but .mdb files will not load ie my old saved Access files. How can I load these files into Access 2003?

View 1 Replies View Related

Error Opening MDB Files On New Setup

Apr 28, 2006

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 1 Replies View Related

Forms :: Opening Files From A Form

Apr 15, 2013

I have a very simple table of basically a unique number and a couple data fields. On my form with those same fields, I need to be able to create a button that opens a pdf file that is named the same as that unique number. Here is the kicker...I have been able to create a hyperlink with a link to that file and it works fine.... I am trying to set it up so that the file name is automatically put into the hyperlink statement according to what the unique number is for each record.

what I did so far...

in my hyperlink: *file://c:/docubase/3840.pdf (only put * in so not a link here)

this works fine but I need the syntac to make that line take into account the account field (ID) for each record. So something similar to this (already tried this and it doesnt work)


View 11 Replies View Related

Access 2007 Crashes On Excel 2007 Import

Mar 21, 2008

On trying to import an Excel 2007 file into Access 2007 I get the following:

1) Choose "External Data," Import, Exce
2) Select small file in MS Excel 2007 format.
3) Click on Import the source data into a new table ...
4) Choose OK

Immediately get "Microsoft Office Access has stopped working. Windows is checking for a solution to the problem..." This message never resolves, so I have to click 'Cancel'.

Then I get "Microsoft Office Access is trying to recover your information..." I have to click "Cancel" here as well and then kill MS Access in Task Manager.

Event Viewer gives following message, which is of no help:
"ID: 2, Application Name: Microsoft Office Access, Application Version: 12.0.6211.1000, Microsoft Office Version: 12.0.6215.1000. This session lasted 710 seconds with 120 seconds of active time. This session ended with a crash."

Trying to import a small Excel 2003 file leads the same result. The same happens with a CSV file.

I have uninstalled and reinstalled Office 2007 as well. I am using Vista Ultimate.

I have turned off DEP.

How can I get MS Access 2007 to import Excel?



View 6 Replies View Related

Access 2007 Runtime Not Visible In Access 2007

Nov 26, 2007

I installed Office Enterprise 2007. Then I installed DEveloper Exrtensions, then Access Runtime 2007. All appear to have installed OK - they appear in Program and Features.
Instructions on runtime packaging tell me that a Developer option should appear in the resulting drop-down when I click the Office button (top-left round thing) when I have a d/b open in Access. It's not there! I have un-installed and re-installed the extensions and the runtime - still nothing!
I do have Runtime 2002 (XP) on the same PC, is that relevant?

View 10 Replies View Related

Opening An Access Program Without Opening Microsoft Access

Jun 11, 2007

I am very close to completing a DB Program.... How can I create a desktop Icon that will Launch my Program without Loading Microsoft Access along with it???

View 6 Replies View Related

Opening Forms Directly (instead Of Opening MS ACCESS)

Apr 20, 2006

Hi All,

Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.



View 1 Replies View Related

Opening Forms Directly (instead Of Opening MS ACCESS First)

Apr 20, 2006

Hi All,

Is there a way that when the user clicks on a database file, the form pops up without opening MS Access window.



View 6 Replies View Related

Read Only In Access? Is It Possible?

Mar 21, 2005

My Access database is situated in a folder which has permissions to only let some people write into it.

The problem is that we would like users with read access to open the database to view but get the following error:

Couldnt use ...path... File already in use.

The database always has more than one user in it so this may be the root of the error message.

Solutions which cannot be implemented are moving the DB to a higher folder or giving write access to this folder to the read-only users.

Thanks in advance for any ideas.

View 1 Replies View Related

Read From Access

Jul 31, 2005

Hello All,

I have a ASP Page which reads data from an Access database. I Have and Access Database and a Excel Spreadsheet. The spreadsheet contains all of the up to date data whilst the Access Database contains old data. Is there a way that i can get Access to Update its data with the data from the Spreadsheet? As the spreadsheet is updated all of the time. I do not have much knowledge in Access.


View 1 Replies View Related

MS Access Read Only Prompt

Jul 11, 2005

I am using windows XP SP2, Office 2003.

I have created a database to store information from a mine site. I have set up a switch board and most users will just view reports or graphs that have already been designed.

I want the general users to open the file read only without having to open access and use the open read only command. I also don't want to go down the path of database security if it can be helped.

I read in the help page that there is a read only prompt that can be flashed up when the file is opened. Unfortunatly the help page suggests, Tools > Options > Security Tab (tick read only prompt). In office 2003 this option no longer exists (if it ever did)

Any ideas, would be good if i could add something to the shortcut and then have some uses use this shortcut.


View 1 Replies View Related

How Can Users W/o Access Read My CD?

Nov 29, 2006

I want to make an Access database of my collection of antique swords that I can put on a CD. This DB would also include as many as 5 digital images for each record.

Some of my friends may not have Access 2007 on their PC. Is there a viewer that I can put on the CD with my database so they can view it without them having to buy the Access program??

View 8 Replies View Related

Access Read Data

Mar 14, 2007

my question is:

in access, how can I read data from two different tables and show the result in another table? in details:

i have two tables named hydraulics and mechanics. i want to read the data "reliablility" from table "hydraulics" and "reliablility" from "mechanics". and then i want to multiply these values and show in a newly created table as "results".

thanks for visiting and answering.

p.s: my file is attached, everything in german, sorry.

View 1 Replies View Related

NOT Read Only Access Database

Nov 16, 2004

How do you make an Access database able to have records written to it (NOT read only)?

View 2 Replies View Related

Access Database Read-only

May 4, 2005

I am having problems with ODBC Access data source name. When I want to display some database data in a html table on a webpage there is no problem. But when I send data from a html form to the database I get an OLE DB error. (I am using ADO). I can't remember the message exactly but it was something like

Microsoft OLE DB Provider for ODBC drivers error '80004005'
[Microsoft][ODBC Microsoft Access driver] The command must be execute on a query which can be edited.
insert.asp, line 50

For some reason my database is read-only. And I don't want that. I tried
1. ODBC administrator deleting and creating a fresh System DSN, checked if there Read-Only wasn't marked on.
2. Deleted my browser cache.
3. Restarted computer several times again
4. Installed MDAC 2.8 again.

btw. I have created the table with MS Access XP and i am using Windows XP.
Below is my code.

<FORM ACTION="insert.asp" METHOD="post">
Barcode: <INPUT TYPE="text" NAME="a1" SIZE="15"><BR>
Artist: <INPUT TYPE="text" NAME="a2" SIZE="40"><BR>
Album: <INPUT TYPE="text" NAME="a3" SIZE="50"><BR>
<INPUT TYPE="submit" VALUE="Send">
<INPUT TYPE="reset" VALUE="Clear"><BR>
a1 = request.Form("a1")
a2 = request.Form("a2")
a3 = request.Form("a3")
if ((a1 <> "") and (a2 <> "")) or ((a1 <> "") and (a3 <> "")) then
Set db=Server.CreateObject("ADODB.Connection")
db.Open "DSN=pieter", "admin"
sql = "INSERT INTO albums VALUES ('"&a1& "','"&a2& "','" &a3& "')"
Set rs = Server.CreateObject("ADODB.Recordset")
<----- Here is the error ----> db.execute sql
Set db=Nothing
end if

View 2 Replies View Related

Read Only Access To Appended Tables

Apr 30, 2006

Hello! My Small access aplication has a tables appended from dbf database program. I am coping with an issue to set access to this tables as read only.For me its very vital that source dbf application won't be changed from MS Access.Thanks for help!

View 3 Replies View Related

Read Only Access On Win 2003 Server

May 16, 2006

I am currently upgrading to win 2003 servers. When I open an access 2000 database on the server I get a read only warning.

I have check all the permissions to allow the users access, but the warning remains.

I do not have the problem with any other documents on the server.

If anyone has any ideas I would really appreciate a response.

View 1 Replies View Related

Copyrights 2005-15, All rights reserved