Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Accessing ".accdr" extension file Expand / Collapse
Posted Monday, June 18, 2012 12:15 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 6, 2013 5:33 AM
Points: 48, Visits: 340
Hi Every one,

I'm very new to this forum and access 2007 so please bare my questions.

I have an application in my computer i often use it for retrieving data based on the requirements they already programmed some queries in that application, my problem is that i have one requirement which is not meets the already existing queries i have a query but that file extension is "accdr", ok i changed it to "accdb" when they asked and solving my requirement but i think this is not good idea to do this way all the times because that application is linked with ODBC database.

so please help me with permanent solution...

Thanks for you help in Advance.

Ganesh N
Post #1317144
Posted Monday, June 18, 2012 6:00 AM


Group: General Forum Members
Last Login: Yesterday @ 7:23 AM
Points: 196, Visits: 782
The .accdr file extension is used to make the database file read-only and prevent changes to it. As you have discovered, changing it to .accdb lets you edit the file, but it also leaves you open to file corruption and other errors. I would change it back to .accdr which will again make it read-only. However, in the long run you should have the developer incorporate your needs into the application - otherwise when they do put out a new version, you will have to make the same changes again.


Colorful Colorado
You can't see the view if you don't climb the mountain!
Post #1317274
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse