Full Version: How To Change Extention .accde, .accdb To Accdr?
UtterAccess Forums > Microsoft® Access > Access Forms
kenwood1
Hi all,
Can someone tell me, How to change the extention accde or accdb or mdb to accdr?
I just package a programm self made and with use also runtime 2010, after finishing the process package and I install on the Hard drive "C" and when I open the soft keep telling me Potential securty concern has been identified File the path... C:....xxxx.accdr, and I searched on the "C" xxx.accdr I even did not have that file xxx.accdr. So I need to change the programm to .accdr and put on the trust location.
Thanks for any helps.
Peter
theDBguy
Hi Peter,
I'm not sure what happened or what you did but here's what I would do when I'm ready to distribute the FE.
1. Make sure the db compiles
2. Compact and Repair
3. Make a ACCDE
4. Rename the ACCDE to ACCDR (just right-click on the file and select Rename)
5. Distribute the ACCDR file
Also, you need to add a "folder path" (not a file) to the Trusted Location settings and store the ACCDR file into that folder.
Just my 2 cents... 2cents.gif
kenwood1
Hi theDBguy,
Thank you for your reply. It's a nightmare to try to distrube that soft self made programme. I try to save the programm self made to .accdr and Microsoft gave me the message below. So I try to make the file to . MDE and still and tell me I need to convert the Database to current version of Microsoft Access. then create the ADE or MDE File, So in access 2010 I save the database to default Database and after Save Publish in the right Side Advance Make ACCdr and I still in the same step not moving forward.
I have try in Access 2003 to make the MDE File and same tell me the same mesage below.
What kind of mistake did I encountered?
" This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. The Access database engine can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used. "
Thank for your kinds respond!
Peter
dmhzx
Weel what Iv'e done (for whihc I expect howls of derisions) ---- is
After packaging up the runtime,
Orun the install, and then change it all back to .accdb.
Some of my users have access and some don't
By giving everyon the .accdb I have a simple upgrade route. After the initiai install I just need to send out a new .accdbd to everyone
HAs to the security warning, that tends to happen with the runtime by default. The only way I've found to turn it off for runtime use, is to turn off VBA warnings in the registry. - Hardly ideal, but then so much of the MS security seesm to be all or nothing.
It won't even let me set my own network as a trustd ;location, because I map using the IP address.
If anyone has found a way to set a runtime application as 'OK to run: It's my PC, my application, and my risk. Iknow what I'm doing Don't ask me again for this application " I do hope they post it.
kenwood1
Hi dmhzx,
o if I understand the Packaging the self made soft and install on the Hard drive even we have "A potential security concern has been identified" this message are seting default on the run time 2010. And this will not harm the computer of the Users right?
kenwood1
Hi Hi theDBguy,
try below and until the point N°4 to rename the file I did rename but still the extention are still the same .accde and the point 5 distribute the ACCDR, I do not quite understand can you give me more explanation? what I found on save & Publish there is package and Dritribute title but no button...
I'm not sure what happened or what you did but here's what I would do when I'm ready to distribute the FE.
1. Make sure the db compiles
2. Compact and Repair
3. Make a ACCDE
4. Rename the ACCDE to ACCDR (just right-click on the file and select Rename)
5. Distribute the ACCDR file
Also, you need to add a "folder path" (not a file) to the Trusted Location settings and store the ACCDR file into that folder.
Thanks, Peter
kenwood1
Hi,
Can anyone tell me how to change the extention .accde to accdr?
Odid have a file with extention accde and a got a help, telling me just right clik on the File accde and it's what I did, but it's only the rename the name of the file and not the extention. How can I get directelly to the extention file?
Many thanks for any helps!
Peter
ipisors
Hi Kenwood,
id you try doing what dbGuy suggested? This will help you rename the file.
(Note, that in Windows 7--and yes this is very annoying that MS did this--when you right click the file, you have to play a little bit with the selection in order to see the file extension, but do it carefully; it's there).
kenwood1
Hi ipisors,
Yes, I did but arrive untile position 4. The self made programme with accde I click on the right mouse , but only the name of the file I can change and not the extention.
I did I do something not correct?
Thanks,
ipisors
s exactly what I referred to in my last post about Windows 7. This was new to me when I left XP for 7 and one of a million things that still annoy me about the file/folder/navigation/explorer situation in 7.
I'm not really sure how to explain it. But when you right click on the file, yes, at first you only see the file name, and the extension name may be "hidden".
Use your arrow keys on your computer a little bit - play with it by using Home, End, and right arrow....Eventually the extension will appear. I hope this helps, sorry I don't have an exact step by step on this one.
kenwood1
Hi ipisors,
Thanks for your quit respond. No way... But I have an attachment you can see what I mean?
Thanks again.
ipisors
Yes, I know exactly what you meant. Did you try what I posted in my last post?
Also try this:
If you can't see the file extension, go to organize > Folder and Search Options, then click the View tab. Uncheck the box titled "Hide extensions for known file types" like so:
kenwood1
Hi ipisors,
Thank you very much! It works now with your recomandation.
Many thanks again.
Regards, Peter
ipisors
Glad that it is working er="0" alt="thumbup.gif" />
kenwood1
Hi theDBguy,
It works now. I have ipisors helping me.
Thanks again, Peter
ipisors
He he - dbGuy gets the credit here, I can barely figure out how to overcome daily life in Win7 sarcasm.gif
I'm just barely learning how to use Runtime myself, thanks to help from him and others. woohoo.gi
 </div>
</div><div class='postwrapper'>
 <div class='posttopbar'>
  <div class='postname'>dmhzx</div>
  <div class='postdate'>Feb 18 2013, 12:25 PM</div>
 </div>
 <div class='postcontent'>
  Hi Kenwood.<br />Yes.<br />henever we ran our app on a runtime, it put  up a mseeage whichs in essence said "Are you sure you want to run this, It might be nasty becuase it has some VBA. Do you want to enable  the content?<br />I want not fine anywhere an option to to tell the thing Yes, I trust this . Let it run and don't pester me again.<br />So we decided that rather than have all users having to say "yes I want this to run"  everytime  they opened that database, part of our installation process is to disable VBA warnings for Acccess Office 14. by modifying the registry. It's not what we wnated really, but faced with Microsoft giving us the choice between asking us always for everything or never for anything, we chose the latter <br />So if anyone knows how to set an application as safe on a machine that only has runtime, I would be very pleased to  hear it.
 </div>
</div><div class='postwrapper'>
 <div class='posttopbar'>
  <div class='postname'>kenwood1</div>
  <div class='postdate'>Feb 19 2013, 09:49 AM</div>
 </div>
 <div class='postcontent'>
  Hi dmhzx,<br />Something that is intread me, how do you do to "disable VBA warnings for Acccess Office 14. by modifying the registry" ? Do you need to put a code in VAB' or with the path: Hkey_curren_User/Sofware/Microsoft/office/14.0/security/Trust Location ? what should I do after?  <img src=
Thanks, Peter
dmhzx
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\14.0\Access\Security
BAWarnings = 1
You may have to add a new DWORD to do this
kenwood1
Hi dmhzx,
Thank you for your feedback. It's works your suggestion woohoo.gif
I have a question. The registry is changed on my computer that Warning will not appear when we're opening the self made programme, but when I make a package solution and that whole programme give to the Users to install in there computer without access programm, it's this warning are also disable or do they need also to make your methode?
Thanks again for your answerd.
Peter
dmhzx
You'll need to add the key onto all their machines as well.
It SHOULD only affect Access 2010 applications, (or rather any access database they try to open) and will appy to all of them.
There may be a more secure way of doing this with trusted locations, but in our case, our Back end is on our network and we map to it by IP address.
Microsft wil not under any circumsatnaces allow us to trust our own network, if we insist on talking to it in IP. - If we use a share name, or a drive mapping, no problem, but IP is totally prevented by those helpful people at Microsoft. -It's a bit like being refused entry to you own homw if you refer to it as Number 10, but OK if you call it "Dunroamin"
Anyway best of luck
ipisors
just 2 minor comments, none important I guess.
) dmhz, your solution would work for KEnwood to simply add that registry change via VBA, which can then be included in the access app right? Thus, the user only has to deal with the annoyance one single time (the first time they open, at which point the VBA runs to change the registry).
2) please believe me that it is very rare that i defend microsoft for something that's a clearly annoying obstacle, BUT.... I tend to view the Runtime as a pretty big gift. The fact that as a developer, you can buy one single license for MS Office/MS Access, and then deploy a database to 5000 people, none of whom have to buy anything...I can see annoyances are still annoyances and yes we strive for perfection, but given that scenario I suppose I can understand if microsoft takes a dim outlook on your complaints, given that they've provided you a free program to make your program useable to an unlimited # of clients who haven't even purchased MS product...... That's a huge "selling point" for anyone doing business as an access developer. is the fact that with Runtime, one cannot change Trust Center settings, a very small price to pay? Just a thought.
theDBguy
Pardon me but the above may not be entirely accurate.
If you use the Runtime Package Solution Wizard to let users install your application, there is a portion during the packaging process where you could add registry keys to create Trusted Locations.
Just my 2 cents... 2cents.gif
ipisors
dbGuy:
ice catch - so there are two ways to change the registry settings, even if client can't (what I meant): open up Runtime directly and change the trust center settings in the conventional way.
That's my point, it seems like a huge gift with minor drawbacks.
theDBguy
Hi Isaac,
The "gift" is the free runtime version, the "minor drawback" is the package solution wizard. You will have better control of the install using other products such as SageKey or Inno Setup.
Just my 2 cents... 2cents.gif
dmhzx
dbGuy and Ipisors:
Yes you're both right. Yes the royalty free runtime is a Good thing from MS
BUT
Yes there is a bit in the packager to allow you to set registry keys, but I could not make head or tail of it
So we do the changes at installation with regedit.
The packager, is indeed an impreesive piece of kit nad has made a huge difference to us.
The annoyance in this case is not with the runtime, but iwth MS being like 'nanny', and refusing to let us take responisibility for our own data on our own network.
It is with trust setings.
You cannot set anywhere on your own network as trusted, in runtime, or the full access, or by changing the registry if you map your netwoork by IP address. - It cannot be done. I would much prefer to have done it, But I cannot change our entire approach to network usage because MS thinks it might possibly result in problems.
That is NOT an issue with runtime, it is an issue with 'nanny' Microsoft arrogance. -- And yes I do feel aggrieved.
\\192.168.1.23 is never, and cannot ever be 'trusted'. (but if you call the self same place "\\Burglar": No problem at all.)
Of course if anyone knows differently and can tell me how to set \\192.168.1.23 as trusted, please do tell. -I have a large slice of umble pie here ready to eat.
theDBguy
Hi dmhzx,
can understand your frustration, and I can't tell you if there's a way to get what you want, but your situation is a little different than the OP (Peter) in that he clearly just wants to set a folder in the C: drive as a Trusted Location. So, setting the registry to disable VBA Warnings may be a bit overboard for his case. That's all.
Just my 2 cents... 2cents.gif
PS. Found this other thread on the subject and I quote:
Have you tried that?
dmhzx
I agree dbGuy:
pening up everything is not ideal, and it may be that he can navigate round the packagersand work out how to set the folder in the C:drive as trusted.
Best of luck if he can. All I was offering was something that worked for me. (and that is relatively easy to do)
HAs to your Internet Option. No that had never occured to me. There I was hunting round all the Access help I could find, and never for a second did I think to try Internet options
I will try that. And many (genuine) thanks for posting it. - Another unexpected work round eh? hat_tip.gi
 </div>
</div><div class='postwrapper'>
 <div class='posttopbar'>
  <div class='postname'>theDBguy</div>
  <div class='postdate'>Feb 20 2013, 11:40 AM</div>
 </div>
 <div class='postcontent'>
  Hi dm,<br />Good luck to you too
 </div>
</div>
  </div>
  <div class='smalltext'>This is a click here.