Hi
Am using Access 2007 with linked tables in SQL Server 2008.
When I link the SQL Server tables, they automatically appear with the DBO prefix.
I have found the VBA code to remove the DBO which is all good.
However, what I would really like to do is use the database name as the prefix instead of DBO.
Anyone got any code that might help me do this?
Many thanks
Am using Access 2007 with linked tables in SQL Server 2008.
When I link the SQL Server tables, they automatically appear with the DBO prefix.
I have found the VBA code to remove the DBO which is all good.
However, what I would really like to do is use the database name as the prefix instead of DBO.
Anyone got any code that might help me do this?
Many thanks