SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Accessing ".accdr" extension file


Accessing ".accdr" extension file

Author
Message
ganeshnarim
ganeshnarim
Valued Member
Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)Valued Member (64 reputation)

Group: General Forum Members
Points: 64 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
WendellB
WendellB
Right there with Babe
Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)Right there with Babe (758 reputation)

Group: General Forum Members
Points: 758 Visits: 1756
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.

Wendell

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search