Randy Anthony
randall.anthony at cox.net
Sat Dec 14 12:30:29 CST 2013
No prob. This assumes you're connecting to your SQL end with Windows Auth and you have dbo permissions on the server. Open SSMS and click Security>Logins. Right click your login account and select Properties. Click User Mapping in the left hand pane, locate the DB, check it and check db_owner on the bottom. Click Ok. Now when you open your link to server and get the ODBC portion, you should be able to see the DB and the tables therein. HTH. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Guss Ginsburg Sent: Saturday, December 14, 2013 12:36 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Linking to SQL Server table from Access - desired table does not show in list Randy, Thanks. Yes, you have described the environment I am in. I am pretty new to using this, and SQL databases, so I will need some specific help walking through this. I see there are permission options for the SQL Server, and for each database. And I believe I want to grant some kind of permission to schema dbo (is that right?), but don’t know where I am stepping now. Can you give me the specific steps to add the permissions needed? Sincerely yours, Guss Ginsburg -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Randy Anthony Sent: Saturday, December 14, 2013 10:49 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Linking to SQL Server table from Access - desired table does not show in list Guss, Are you importing/viewing the data via SSMS? Then when you open Access and try to link you can't see the tables to pick from? If so, you need to add permissions to the SQL side so that your ODBC connection will allow you to see/select the tables. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Guss Ginsburg Sent: Saturday, December 14, 2013 11:02 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Linking to SQL Server table from Access - desired table does not show in list i imported the table into SQL Server, and it shows up on my computer in the database, but when i try to link to it, the list of tables that comes up are only system tables, and the data i am looking for is not shown. Did i leave out a step in the process of creating the db or importing the file? Sincerely yours, Guss Ginsburg -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com