>If you use DataSourceType = [NATIVE]
>You can't alias CA as VFP table name, because you always will get Alias already exists error, but if you use ADO as DataSourcetype you could ALIAS CA as you want.

"You can't alias CA as VFP table name, because you always will get Alias already exists error"
is a mighty strong statement and probably untrue <bg>

Haven't tried it with a CA and a native table, but when working with local views I HAD to xreate a view with the same name as the base table (alias in "mangled" form occuring in code and macros) and was able to hack it using the database events. Might work here as well <bg>.

regards

thomas