upsizing a database tp sq; server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dennist685 - 21 Mar 2007 14:00 GMT

I am definitely the administrator The 'me' sttement tells me so. So why do
I get something like 'you do not have permission to perform this operation?

dennis

Reply to this Message

Douglas J. Steele - 21 Mar 2007 14:40 GMT

What do you mean that me statement tells you so? What does it tell you?

What operation are you trying to run when you get the error message?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I am definitely the administrator The 'me' sttement tells me so. So why
>do
> I get something like 'you do not have permission to perform this
> operation?
>
> dennis

Reply to this Message

dennist685 - 24 Mar 2007 15:19 GMT

I mean the my statement in visual basic. I access the databases, once
designed, only through visual basic. But I guess this is a sql server issue.
I found out for the database I want I only need sql server express.

Thanks Doug.

dennist

> What do you mean that me statement tells you so? What does it tell you?
>
[quoted text clipped - 6 lines]
> >
> > dennis

Reply to this Message

Saracen - 26 Mar 2007 10:59 GMT

>I mean the my statement in visual basic. I access the databases, once
> designed, only through visual basic. But I guess this is a sql server
[quoted text clipped - 16 lines]
>> >
>> > dennis

Reply to this Message

dennist685 - 29 Mar 2007 11:36 GMT

In access 2007 I can't find the 'upsize' command. Is there an equivalent
command the transforms the access dtabase to an sql server or server express
database?

thanks very much

dennist685

> >I mean the my statement in visual basic. I access the databases, once
> > designed, only through visual basic. But I guess this is a sql server
[quoted text clipped - 16 lines]
> >> >
> >> > dennis

Reply to this Message

Jeff Boyce - 21 Mar 2007 14:43 GMT

dennis

We aren't there. We can't see your PC.

What "me" statement? Where?

In Access, the "Me." or "Me!" expression is used to refer to the current
form (or report), not to you.

To use SQL-Server tables, you have to be given permission IN SQL-SERVER, not
in Access.

Signature

Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

> I am definitely the administrator The 'me' sttement tells me so. So why do
> I get something like 'you do not have permission to perform this operation?
>
> dennis

Reply to this Message

dennist685 - 28 Mar 2007 03:07 GMT

I clicked yes for helpful but it clicked off once I clicked yes also to the
next answer

> dennis
>
[quoted text clipped - 14 lines]
> >
> > dennis

Reply to this Message