May 31, 2005 at 6:19 pm
I am linking to a SQL server table through access front end. The SQL server is in clustered enviornment. I am able to connect and link, but if I reopen the access database and try to open the linked table it throws an "Invalid Object Error/Cannot find table error" and I have to go through the link Manager and redo the whole procedure.
Any ideas why I cannot just open the linked table?
June 2, 2005 at 5:41 pm
Are you saving the password? when setting up the link?
David
June 2, 2005 at 5:46 pm
No, I am not.
June 2, 2005 at 6:10 pm
so when you right click in the MDI window, and choose link table, choose teh file type to ODBC.
Select or create & slect your machine Data Source:
(Click on the machine Data Source tab and select one from the list or click New)If new, select System Data Source and choose next.
Select SQL Server, click Next the Finish.
Give the data source a name "SQL test"
Give it a description
Choose a server, click Next
Choose how you want to authenticate, I am choosing SQL Server authentication for my test then click Next
Change your default database if applicable then click next
Click Finish, then test connction and press OK
Press OK after choosing your Machine data Source
This is where I get my SQL Server login, becuase I chose SQL authentication, you may not get this screen. if so, enter it and click OK.
select the table(s) you want to link and BEFORE pressing OK, click "Save password" in the lower right hand corner.
HTH
David
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply