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!

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

Web Reporting problem with MS access document

Status
Not open for further replies.

ziggs

Technical User
Sep 21, 2000
195
US
I'm using Crystal Reports 8 and I have a MS Access document on a Windows NT network drive. Now, I wrote out a a report that accesses the MS Access Database and it works fine from my computer. However, when I place the report in the folder I use for web reporting, it will open the reoprt but not connect to the MS Access DB. The MS Access DB does not have a username or password. I'm stumped! Any ideas? Thanks
 
1. Here's the error message word for word (test being name of CR and crystal being the name of the web folder that contains the crystal reports):

Error in test.rpt:
Unable to connect: incorrect table location.test.rpt [connecting to Page Server: crystal]

2. To create the connection in CR8, I attached the database using the database explorer, going to database files folder, and then use the find database file to navigate to proper MS access DB.

3. Yes, the person that runs this report does have permission to the NT folder

Thanks for your response

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top