468,765 Members | 1,157 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

An experience in linking Blackboard learning system backend to Access

Hello
We started using Blackboard learning system in our college. We would
like to link Blackboard SQL-server backend to an Access database for
writing reports. Does anyone have an experience of using Blackboard
SQL-server backend? I'd be very greatful for any advise?
Thank you.
Galina

Nov 13 '05 #1
2 1976
"Galka" wrote
We started using Blackboard learning
system in our college. We would
like to link Blackboard SQL-server
backend to an Access database for
writing reports. Does anyone have an
experience of using Blackboard
SQL-server backend?


I have no specific experience with Blackboard, but Access works very nicely
as a client to SQL Server. You'll need security permissions on the SQL
database -- see the Database Administrator (there surely should be a DBA for
an application of strategic import such as this one).

You can create your client as an MDB, using Jet and ODBC to link Tables in
the SQL Server database (this would be my preference) or as an ADP, using
ADODB and OleDB (some others prefer this approach, but when I used it, I
could see no advantage).

Larry Linson
Microsoft Access MVP
Nov 13 '05 #2
Larry
Thank you. The small problem is that they do not provide a data
dictionary for back-end database. They prefer customers using their and
third-party's JSP utilities for any customisation.
I am sorry, I should have mentioned that I was looking for someone, who
knew the Blackboard backend data.
Best regards.
Galina

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Robert | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.