In Windows Explorer on the root of the storage device, right click and click on properties. Go to the Security tab. Add your name to the list of approved users and give yourself full rights and be sure to check the box to apply this to all files and sub-directories as well. Then click on advanced and do essentially the same thing in the Special Permissions section. Make sure the special permissions section does not deny access to to the Everyone user - if so, edit it to allow access (at least read only but any kind of access will do - if denied, this entry overrides everything else). While in the Advanced section, click on the ownership tab and make yourself the owner of the drive (and again check the box to apply it to alll files and subdirectories as well). This should resolve the problem. If you can't complete the tasks (you get stuck on some file or folder), try to amend that folder or file directly and once done restart the global process. If you can't, move it temporarily from the drive until you've done the rest and then return it and try again to change it - especially if that's the folder or file you're talking about. If you still have problems with that file/folder and the following articles don't help, post back with an explanation of exactly what happens or doesn't happen when you try to change it and I'll see if I can identify a reason and help you fix it.

1. Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error
2. Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error Or Access Violation

Here's some additional information on permissions and ownership in case you run into problems or want more details on the procedures:

Hi, Thank you so much for sharing this update with us. If you need any further assistance with Windows Operating System, please post your query on Microsoft Community Forums and we’ll be glad to assist you with it. Jan 19, 2017  Data source Prefix Value; Driver Manager vendor ODBCcomponent datasource Microsoft ODBC Driver Manager N/A: Visual FoxPro driver: vendor ODBCcomponent.

To see your permissions, right click the folder/file, click on properties, and check out the security tab. Check to see what permissions you have by clicking on your username (or user group). Here are the types of permissions you can have:http://windows.microsoft.com/en-US/windows-vista/What-are-permissions. You need to be an administrator or the owner to change permissions (and sometimes being an administrator or even an owner isn't enough - there are ways to block even them from access (though a smart administrator knows these ways and can get around them - but usually shouldn't because they were denied access usually for a very good reason). Here's how to change folder permissions in Vista:http://www.online-tech-tips.com/windows-vista/set-file-folder-permissions-vista/.To add take and grant full right permissions and ownership to the right click menu (which will make it faster to get in once it is set up), check out the following article:http://www.mydigitallife.info/2009/05/21/take-and-grant-full-control-permissions-and-ownership-in-windows-7-or-vista-right-click-menu/.

Download Advance Wars - Dual Strike (EU)(M5) ROM for Nintendo DS (NDS) from Rom Hustler. 100% Fast Download.

To fix this problem with the folders, takeownership of the folders or the drive (as an administrator) and give yourself full rights. Right click the folder/drive, click on properties, go to the security tab and click on Advanced and then click on the Owner tab. Click edit and then click the name of the person you want to give ownership to (you may need to add it if it isn't there - or it may be yourself). If you want it to apply to sub-folders and files within that folder/drive, then check the box for replace owner on sub-containers and objects and click OK. Back out and now there's a new owner for the folders/drive and files who can change permissions as needed. Here's more information on taking ownership of a file or folder:http://www.vistax64.com/tutorials/67717-take-ownership-file.html.To add take ownership to the right click menu (which will make it faster to get in once it is set up), check out the following article:http://www.howtogeek.com/howto/windows-vista/add-take-ownership-to-explorer-right-click-menu-in-vista/.

If that doesn't work, check the network settings. Here are some articles that may help:

Here's a tutorial on how to setup a home network (including a wireless one) - check out the additional links for further information that may be of great help:http://windows.microsoft.com/en-US/windows-vista/Setting-up-a-home-network.

Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error

Error 42000 Microsoft Odbc Visual Foxpro Driver Syntax Error Or Access Violation

Here's an article on troubleshooting wireless network connections (again with helpful links):http://windows.microsoft.com/en-US/windows-vista/Troubleshoot-network-connection-problems.

Here's an article on networking different versions of Windows:http://windows.microsoft.com/en-us/windows7/Networking-home-computers-running-different-versions-of-Windows.

I hope that helps. If necessary, start over from scratch using these procedures and see if that helps.

Good luck!

Lorien - MCSE/MCSA/Network+/A+ --- If this post helps to resolve your issue, please click the 'Mark as Answer' or 'Helpful' button at the top of this message. By marking a post as Answered, or Helpful you help others find the answer faster.