Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access denied

Status
Not open for further replies.
DanNorris2000

DanNorris2000

Technical User
Joined
Nov 10, 2000
Messages
186
Location
US
I am running CR8.5 reports from a VFP command button on a form accessing files thru ODBC on a network drive. While reports are running, access is denied to the VFP database files used in the report. Does CR need exclusive access to the database or am I missing a step?
using the following code to run rpts:

oCRApp = createobject("crystal.crpe.application")
oRep = oCRApp.openreport("k:\vfp\reinsurance\reports\66dr.rpt")
oRep.Printout(.F.)

 
Sort by date Sort by votes
There should be an *Exclusive* on the ODBC driver, if checked, than I believe it will try to lock the tables.

It's been several years since I used VFP, so I can't offer much else.

-k kai@informeddatadecisions.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Charliy
  • Locked
  • Question Question
Access 2010/Crystal XI
Replies
6
Views
405
Charliy
Charliy
Bennie47250
  • Locked
  • Question Question
Access Database via ODBC Connection
Replies
1
Views
341
kray4660
kray4660
kc27
  • Locked
  • Question Question
Can Crystal Access and Utilize Record Creation Date to Sort or Filter Report Data?
Replies
1
Views
232
pmax9999
pmax9999
setaylor07
  • Locked
  • Question Question
MS Access 2010 Database login required when opening a report using Logicity
Replies
6
Views
359
setaylor07
setaylor07
veles
  • Locked
  • Question Question
Crystal XI connection to Access DB with crystal parameter
Replies
1
Views
221
Charliy
Charliy

Part and Inventory Search

Sponsor

Back
Top