Linking to SQL Server

[dan-cat]

Strewth didn't think I was ever going to work with Access again, but I am, so here comes a table link question for you.

Got an access xp FE linking to SQL server via a DSN file. All linked up fine, however the tables in access have been given a 'dbo_' prefix to the original table name in SQL server.

How to get rid off?

A setting in the DSN file?
Some VBA to loop through each table and rename?
Linked table manager which I haven't got round to installing yet?

Thanks

Dan

 

[FoFa]

You can rename them, but why? The DBO shows the table owner (in this case sysadmin). I don't get it why people get hung up on that.

 

[dan-cat]

You can rename them, but why? The DBO shows the table owner (in this case sysadmin). I don't get it why people get hung up on that.

There is already a bundle of queries/modules/macros/forms within the FE calling these tables without the "dbo_" prefix - so the table linking wizard renaming the tables is completely unwanted.

Was just wondering whether there was a way of linking to SQL server without the wizard doing this. If not I'll just write something to loop and rename.