upsizing a database tp sq; server

D

dennist685

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
 
D

Douglas J. Steele

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?
 
J

Jeff Boyce

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.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


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

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

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 issue.
I found out for the database I want I only need sql server express.

Thanks Doug.

dennist
 
S

Saracen

dennist685 said:
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
Click to expand...
 
D

dennist685

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

dennist685

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
 
Top