Hi,
I have recently upsized our access mdb to sql server. The result is as follows:
When I try to link tables from the SQL server into the MDB, they all have dbo. suffix's, why is this? Because it therefore means that I have to change all queries & reports & modules? That would take ages considering we have around 600 queries.

Also, I unchecked the box in the upsizing wixard so that it would upsize data as well as table structure - But it doesnt, I only ever get table structure.

I am a beginner with SQL Server but have been using Access 2000 for a year now. Any help greatly appreciated - I must be doing something wrong.

Thanks.

After you link the tables ans they are named:

dbo_tblMyTableName

you can rename the "link" in the databse window by selecting the table then press F2 or right-click and selet rename . Then you can remove the prefix so that it will be back to the original name like:

tblMyTableName

Now all your other objects that reference the table will still work



Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

Hi, and thanks for your reply. Just to let you know...

I got home and decided to try upsizing on office 2003 which i have at home (we have office 2000 at work). In 2003 it upsized fine, everything working and im very pleased with the results, just a few niggles to sort out.

So, from my experience and in aid of others, if you are upsizing, make sure you're running Office 2003. I maybe wrong, but for me, its done the trick very well.

Bye.