Tables in Access show dbo at the end

C

Chewie

I have an Access Database that links to an SQL Server. This is great on my PC
but on other PC's the tables show dbo at the end. This is causing problems
with links and the like. Is this normal and can I remove this ???

TIA
 
G

Guest

hi,
access automatickly adds this. it's built in. yes you can
remove it. but be careful. make sure that that you don't
have any queries, reports, forms ect referencing the table
WITH the dbo because everything will start crashing on
you, displaying message about can't find table.
 
D

Duane Hookom

Which "at the end"? When you initially link to SQL Server tables, you will
see something like:
dbo_tblEmployees
You can easily rename the table in Access to tblEmployees
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top