Who's On?

	Membership:
	Latest: cat andrews
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5215

	People Online:
	Visitors: 41
	Members: 0
	Total: 41

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Connection to MS Access 2007

2 Replies

0 Subscribed to this topic

23 Subscribed to this forum

Sort:

Author

Messages

Greg Moeller

Veteran Member

Posts: 1498

MVP

New Poster

Engaged Reader

Avid Reader

11/6/2012 6:10 PM

In this case, I'm trying to hook up an LBI published report to use an Excel 2007 spreadsheet as it's source of data.

I keep getting prompted for a default User ID and password when running with a data refresh.

Any pointers on how to set this up would be appreciated!!!!

Matthew Nye

Veteran Member

Posts: 514

11/6/2012 6:16 PM

i suppose asking "why god, why?" would be in appropriate so....

Id bet its permissions. Where is the excel file? If its not on the local server to the RAS engine you will need to do one of the following:

1. move it to the RAS server
2. run RAS and maybe WAS services with a network login that has access to that file

Greg Moeller

Veteran Member

Posts: 1498

MVP

New Poster

Engaged Reader

Avid Reader

11/6/2012 6:23 PM

Thanks.... that pointed me in the correct direction... It was on our corporate P: drive, and since the RAS server knows nothing about mapped network drives all I needed to do was go back to the Crystal and recreate it using the UNC path to the file.

Oh, and yes... DO NOT get me started!!!!! For whatever reason (mostly lack of motivation to spend the money for additional sql instances, this company is WAY huge on Access and Excel being published through LBI and distributed.

Thanks!!:tongue: