My Assistant
![]() ![]() |
|
|
Apr 28 2012, 04:42 PM
Post
#1
|
|
|
UtterAccess Member Posts: 44 |
I created a table using the upsize tool to sqlsrvr2005. several of my users cannot see it. What could cause this and how do I fix it ?
when I launch SMSE I do not see it. I know it is there because one user can see it. I have been working from two machines remotely and I am not sure which one I used to create it.The two machines I use remotely are the ones that cannot see it. The machine that can see it is the server itself when I use gotomypc.I see it when I try to link to it from the access front end. All users are in the same user category Please help. thanks, Dave |
|
|
|
Apr 30 2012, 11:46 AM
Post
#2
|
|
|
UtterAccess Member Posts: 44 |
How do I upsize a table so that the dbo schema is used? When I upsized the first table I did not worry about this.
thanks, Dave |
|
|
|
Apr 30 2012, 01:31 PM
Post
#3
|
|
|
UtterAccess VIP Posts: 18,396 From: Oklahoma City, Oklahoma |
Dave,
Are you using Access 2007 or later? There are several upsizing tools. Did you use Microsoft's SSMA for Access tool or something else? |
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 25th May 2013 - 12:54 PM |