Cannot create new db from templates on 2007

[allmarangie]

Hi everyone. I'm new to Access 2007, having just upgraded from 2003, and I apologise if this request isn't correctly presented. Now I know this has been asked before, but I'm going cross-eyed trying to find a solution that will work for me. I cannot create a db from a template in 2007, either from a local one, installed with the program, or downloaded. The online ones download with no problems, but as soon as I click on "create", I get the message: [QUOTE] "Template 'xxxxxxxx.accdt' could not be instantiated." it goes further to say "The table 'xxxxxxx' could not be read from the template file. The object may be in an unrecognized format or contain invalid data." [UNQUOTE]. I have read through everything I can find on here, and searched the internet repeatedly. Some places say that certain .dll files are not registered, but after downloading these files, I am unable to get them to register. I have uninstalled and re-installed the entire Office suite, and run the Repair tool 3 times, but to no avail. The files are stored in, and downloaded to, a Trusted location. Templates from 2003 will work, but not 2007. I'm at my wits end now. Please can someone suggest a working remedy? Thanks in anticipation.

[RuralGuy]

Have you established your "Trusted Locations" yet?

[allmarangie]

Hi!. When I checked the Trust Centre settings, the only existing location was "C:\Program Files\Microsoft Office\Office12\ACCWIZ". As it was the templates I couldn't use, I made the "C:\Program Files\Microsoft Office\Office12\Templates" folder as a Trusted Location as well, but this made no difference. I also created one in my Dropbox, thinking this would make the contents available on other devices as well.

[RuralGuy]

You need to have your current location as Trusted as well.

[allmarangie]

Sorry, I may be a bit thick, but I'm not sure what you mean by "current location". I have 3 different .pdf guides to Access 2007, but can't find any mention of that term.

[RuralGuy]

You have an accdb file somewhere that you are working with. What is the path to that location? Is it a Trusted Location?

[allmarangie]

I had two accdb files that I had been using, but these were just saved in Documents as any normal file. I have created a Trusted Location folder in Documents, and moved them into here. These now open without the security warning, but I'm no farther forward with the templates.

[RuralGuy]

I'm sorry but I'm fresh out of ideas at this time.

[ItsMe]

Considering this
"Template 'xxxxxxxx.accdt' could not be instantiated."
You might try reinstalling or repairing your installation of Access. You do not need (or should not need) to do a repair on the entire office suite but I would definately try a repair using hte advanced install options.

[allmarangie]

Thanks for trying RuralGuy. At least I'm no worse off than before and I've got a couple of extra Trusted Locations.

To It's Me: I've tried both, repairing first, then removing and re-installing just Access, but there's no change. Internet searches tell me that the two files msado15.dll and msadox.dll need to be reregistered, but even following the instructions given, I am unable to do this. I get the message " The module 'msado15.dll' failed to load. Make sure the binary is stored at the specified path or debug it to check for problems with the binary or dependent .DLL files. The specified module could not be found.".

Have you any thoughts on this, please?

[ItsMe]

You may be on the correct path. It will take a little bit of research to understand it more. I have meetings today but will take a look at it when I get a chance.

[allmarangie]

After looking at countless internet pages, and trying various remedies, I have unregistered and re-registered "msadds.dll" and "oledb32.dll" in C:\Windows\System 32, and also "msado15.dll" and "msadox.dll" in C:\Program Files\Common Files. This has made no difference whatsoever.

[ItsMe]

This link seems to be the most relevant.
http://support.microsoft.com/kb/958846

The link explains registering the dll files to resolve the issue. If you try this approach, first determine if your OS is 32bit or 64bit.

I would try to see if you can make a reference to the Microsoft ADO Ext 2.8 for DDL Security and Microsoft ADO Ext X.X for DDL Security in a blank DB. Do a compact and repair and then take a look at the references again to see if the references you created now show as broken or missing or if you get errors during the compact and repair.

I would suspect whatever the dll issue you should be able to replicate it in a new blank DB by trying to create a link to reference that depends on said DLL.

If these DLL files
Msado15.dll
Msadox.dll
seem to be more relevant to your issue than other DLL files you could try reinstalling them.

The only problem is I don't seem to see any simple way to do this. Running an OS repair would be extreme and the closest thing I can find to reinstall them is the 2.8 version which is for 32bit systems. It may be the one you need but I might try to replicate a broken reference in a blank DB first. Really figure out which dll is the issue.

[allmarangie]

Thanks for this. I have already un-registered and re-registered those two files, and it made no difference. As to your suggestion about "make a reference to the Microsoft ADO Ext 2.8 for DDL Security and Microsoft ADO Ext X.X for DDL Security in a blank DB. Do a compact and repair and then take a look at the references again to see if the references you created now show as broken or missing or if you get errors during the compact and repair", ​I'm afraid that went right over my head. I'm new to databases, which is why I was hoping to modify a template, rather that attempt to create one from scratch. I do have some .pdf instruction manuals, so I'll start and work my way through them, to try and improve my knowledge.

[ItsMe]

In the VBA editor, there is an option to add references to your "Project". I do not like using the word "Project" here because it could infer other things but it is common when talking about Reference Libraries.

From "Design View" in a form, click "View Code" in the upper right hand corner. You need to be in the "Design" tab of the "Form Design Tools" in order for "View Code" to be displayed.

You should now be looking at the VBA editor. Under "Tools", click "References". In this new window you can tick references from the list of available libraries. It is a lot easier to manage References to Access with this window (GUI).

If there is a problem with your request to add a reference, this window should indicate "Broken" or "Missing" reference. Doing a compact and repair to a new, blank db should cause Access to reexamine the references you requested.

BTW, what type of OS and Version of Access are you using?

What is the Os and is it 64 or 32 bit?

Same with Office/Access, 32 or 64? It is common to have a 64bit OS and install 32Bit Office. If you have a 64bit install of Office, this could cause some issues with some DLL files. I do not have a lot of experience with this but back in the day I read up on it enough to avoid 64bit Office.