Brad Marks
BradM at blackforestltd.com
Sat Jan 8 07:32:21 CST 2011
John, I ran into a situation similar to this several months ago. As I recall, I could see the default database, but I could not see the database that I wanted to work with. I discussed this with the person who handles security and was given "Administrator" rights. After this, I was able to see the database that I wanted to work with. I am not sure if this piece of info will be useful to you or not, but the two situations seem similar. Good luck. Please post what you discover once you get it working. Thanks, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, January 07, 2011 11:02 PM To: Sqlserver-Dba; VBA; Access Developers discussion and problem solving Subject: [AccessD] Access - link to SQL database -Database not showing I have installed SQL Server 2005 on a (remote) Windows 2000 server machine at the client. From my workstation at the client I then open SQL Server MSExpress 2005 and I can see that SQL Server Express instance and two databases that I created on that SQL Server Express instance. From Access I try to link to a table in one of those databases. When I get to the wizard page where I am allowed to change the default database, I cannot see either of the two databases that I need to get at, only the master, msdb and tempdb. I was having a problem where I could not connect and had to open the surface configuration and allow remote connections. I selected TCP AND named pipes. That allowed MSE to see that server as well as Access to see that server, but it does not yet allow me to see the actual database of interest. Any clue why? I have done this before here at my office and I could always see the databases. TIA, -- John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.