I have a link table from a SQL Server but I’m having trouble connecting to the table and adding records. I've done a search on google groups looking for code, but I don't understand what I’ve found. Can anyone provide me with code to connect to the table? Also, it would be nice if someone could explain the important parts.

Thanks

The only difference that I have found from connecting to a link table in SQL server and a link table from say a different access application is that when you connect to the sql server table, you have to use a prefix of dbo_. So if you have table employee that you link to is sql server, you would access it by the name dbo_employee.

I bet that doesn't help, but you never know :)

nikotromus