Hello All,
I am very new to access and SQL server connections. I am supposed to link a table in SQL to access. I researched online to find out how to do it - but when I try to link a specific table only the dbo's under the "system table" are being shown, the ones that I need are not even in the list to select.
This is how my server looks like:
Server ABC
- Databases
- System Database
- Database Snapshots
- DatabaseA
- Database Diagrams
- Tables
- System Tables
dbo.1
dbo.2
- dbo.employee
- dbo.numbers
- dbo.building
When I link through Access... the list of dbo's shown only includs dbo.1 and dbo.2 (i.e the ones under System Tales), does not show dbo. employee or dbo.numbers (the rest of the tables under "Tables") when those are the two tables I need to link to my existing access database.
Please let me know what I need to do as soon as possible. Thank You for your time and help.