Link Table Error

  • Thread starter Thread starter Sunny
  • Start date Start date
S

Sunny

I created the database and later i upsize the database on sql 2000 server.
Now all my tables are linked to sql server. I can open any of table by
double clicking and doesn't ask for any password. Then I create one more
table on SQL server, and link to my access database. I can't open that table
first, If I open other table first then it let me open newly linked table.
How can I resolve the problem?

Thanks.
 
Sunny said:
I created the database and later i upsize the database on sql 2000 server.
Now all my tables are linked to sql server. I can open any of table by
double clicking and doesn't ask for any password. Then I create one more
table on SQL server, and link to my access database. I can't open that table
first, If I open other table first then it let me open newly linked table.
How can I resolve the problem?

Thanks.
Click to expand...

I'm guessing that what you need to do is to delete the link to the new
table, create it again, but this time put a tick in the "Save Password" box
 
Thank you very much. Works great!

Brian said:
I'm guessing that what you need to do is to delete the link to the new
table, create it again, but this time put a tick in the "Save Password" box
Click to expand...
 
Back
Top