Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DAO Blues...
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00404555
Message ID:
00404889
Views:
10
>I've been roped into trying to figure something out and, unfortunately, have hit a wall. While this isn't a VFP issue, I was hoping that someone here might have more information than I. So, without further ado...
>
>There's a VB application hitting an Access database on an NT server via DAO. The database is being opened with the OpenDatabase(< filename >) syntax, which, since no other parameters are passed means that it should be opened in shared mode. However, when we try to access the table, we get a message stating that the database is either opened exclusively or we don't have the appropriate permissions, via DAO. Supposedly, we do and it was suggested (since the original attempt was via ODBC) that it might be a conflict between DAO and ODBC. However, under VFP 6.0 SP3 and SP4, I can simultaneously connect to the Northwind sample mdb using both DAO and ODBC.
>
>Admittedly, I know very little about DAO (enough to be dangerous< g >).Could this possibly have something to do with a secure workgroup? If anyone can provide some info, I'd really appreciate it.

Nevermind. Found the answer to the problem in MS KB article Q191737.
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform