3 "." is correct. The authentication issue would probably be related to the Linked Server configuration (just a guess), but the fact that you even get an auth error seems to indicate that the 3 "." is getting you to an actual DB connection. Basically, not too generalize overly much, the dot notation is something like this:
[server name].[database name].[table space / table owner].[table name] So, a maximum of 3 "." and the first is your Linked Server alias. Since Access is a single file per database (2nd position) and does not have ownership space (3rd position, like SQL Server had [dbo].[myTable]), it has no entry for either the 2nd or 3rd position, leaving the 3 plain dots between server name and table name. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320412 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
