Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection to MS Access
Message
From
03/11/2005 00:58:00
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01064680
Message ID:
01064838
Views:
17
Looks like you must've gotten a password protected mdb from your customer. If you have Access I would try to open it with MS Access, just to make sure this is the issue. If you can open it there, I would try enclosing the table name with brackets, given the spaces in the name.

If not, just ask for the password and add it to the connection string. If that's not an option check out the www.mvps.org website for the Access MVP's pages as I vaguely remember seeing a password utility there.

>Thanks for your response. I have reproduced the error...
>
>---------------------------
>Microsoft Visual FoxPro
>---------------------------
>Connectivity error: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'National Ancillary Data'.
>---------------------------
>OK
>---------------------------
>
>Apparently a permissions problem. This being a file we received from one of our clients, I am not sure I will be able to get around it. Any thoughts?
>
>Thanks
>Vince
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform