Access Dreamweaver Can't find a valid editor for this file extension

Hello Experts
I have a Dreamweaver Site which is using Access.mdb

If I try to open the access database from within DreamweaverI get the error message

Can't find a valid editor for this file extension

I can open the .mdb  outside of Dreamweaver.

I can open other access.mdb files within  Dreamweaver in other sites on the same machine, so it seems like the problem is specific to this one site.

I wondered if anyone has any ideas for this please
Regards
John
johnhardyAsked:
Who is Participating?
 
Jason C. LevineNo oneCommented:
Sort of.  When you double-click from within Dreamweaver, is it on the Local Site or the Remote Site?  DW may be confused about your site definition and preventing access to the mdb as a result

Compare this non-working site to a working site and see if you have any differences in the settings for local and remote.

If not, post your site definition and I will see if I can duplicate the problem on this end.

One last thing to try is forcing the site cache to rebuild.  That sometimes fixes transient issues such as this.
0
 
Jason C. LevineNo oneCommented:
Hi John,

Under Edit | Preferences | File Types/Editors, is the .mdb extension mapped to the msaccess.exe application file?

0
 
johnhardyAuthor Commented:
Sorry for the delay, I dont seem to have been notified there was an answer, (may be been asleep)!
Thanks for the answer
It was not there but I browsed to the MSACCESS.EXE and MSACCESS is now showing but it made no difference.
Regards
John
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Jason C. LevineNo oneCommented:
Weird.

If it works in one site, it should work in all sites.  Is this particular mdb file secured in any way?
0
 
johnhardyAuthor Commented:
Secured?
Not sure what you refer to.

The permissions are set and its working in all other respects
Thanks
John
0
 
Jason C. LevineNo oneCommented:
Permissions?  Are you trying to open this file for editing on the web server (remote site)?

Access won't be able to do that unless you map your web server as a network drive.  You would need to link tables to make it happen from a local version.
0
 
johnhardyAuthor Commented:
I am using this database within a website I am developing on my local PC under localhost.

Does that answer your point?
0
 
Curtis ShullFounderCommented:
This may sound simple and redundant but CHECK your path syntax in the local site setup/configurations again for any anamolies.
0
 
johnhardyAuthor Commented:
Thanks Jason, how do I force the cache to rebuild please?
0
 
Jason C. LevineNo oneCommented:
Under the Sites | Advanced | Rebuild Cache menu.
0
 
johnhardyAuthor Commented:
Great
Thanks that seems to have done the trick. Its working OK now.
Regards
John
0
 
Jason C. LevineNo oneCommented:
Woot.  Glad it works now.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.