Tables in Access show dbo at the end

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top