UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Permissions To Tables    
 
   
red68
post 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
Go to the top of the page
 
+
red68
post 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
Go to the top of the page
 
+
HiTechCoach
post 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 the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 12:54 PM