If you are attempting to create a view form from an external sql database....
For SQL Server— TABLENAME or DATABASENAME.OWNER.TABLENAME (Make sure you specify dbo if the current user is the owner of the table.) Also make sure ARAdmin has permissions to the sql db you are attempting to create a view form with. Syntax - [INAME\INAME].DBNAME.OWNER.TBNAME This is the syntax for SQL 2005 with an instance name, the instance name is in the brackets [INAME\INAME] You can test it by the following sql query- select * from [INAME\INAME].DBNAME.OWNER.TBNAME Is this what you are looking for Tricky? Kevin P. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
