Body
Who is Eligible?
Active Faculty or Staff with Banner (ODBC) Access
What is Remote ODBC?
Remote ODBC (or ODBC Web) is a service that allows users to utilize ODBC with Microsoft Access reports from off-campus, or on devices that do not support Microsoft Access.
Remote ODBC is designed to only house Microsoft Access reports that utilize ODBC.
How to use
- Connect to the VPN
- Browse to https://odbcweb.oakland.edu/rdweb
- Login using the format "ADMNET\<yourNetID>" and password. If you have login issue try resetting your password using the https://netid.oakland.edu/profile/
- Double Click an application to download the launcher.
- Open the downloaded launcher from your downloads directory, if needed. The launcher can be used in the future without logging into the website.
- The file will have the file extension
.rdp.
- If you are on a non-Windows device, you will need to install the "Windows App" to utilize the downloaded .rdp file.
- Login to the server using the same credentials.
- If you see any additional prompts regarding certificates, click accept.
- The Access application will launch as a window on your computer.
- Once you are done, simply close the session by using the applications "X" button in the top right corner.
ODBC Authentication Issue
If you are having issues with authenticating with ODBC in a Microsoft Access report, please reset your ODBC password. Information regarding how to reset your password can be found in the linked knowledge base articles section on this page.
How do I gain access or request changes?
Please submit a service request using the linked services request on this page.
Additional Support
- OU Technology Center
- 44 Oakland Center
- Rochester, MI 48309-4479
- (248) 370-4357
- Office Hours: M-F 8:00am - 5:00pm