SQL Server and Creating Tables/Queries

  • Thread starter Thread starter Laurie
  • Start date Start date
L

Laurie

I have connected to a database through Access using the
SQL server. I can see view the data and create reports but
I can't create a table or query. I get an error message
that I'm not log in as the database owner or system
administrator. I will not be able to save changes to
tables that I do not own. Is this a problem in Access or
with the Software that I got my database from?

Thank you.
 
Laurie said:
I have connected to a database through Access using the
SQL server. I can see view the data and create reports but
I can't create a table or query. I get an error message
that I'm not log in as the database owner or system
administrator. I will not be able to save changes to
tables that I do not own. Is this a problem in Access or
with the Software that I got my database from?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

This is a permissions issue. Your signon (user name) needs to be
granted permissions on various objects.

If you are not the SQL Server DBA, ask her to make you a user on the
database you want to access & grant you permissions to do the various
things you want to do.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQHWdDIechKqOuFEgEQL4zgCdFA36cG6ozr/3Pfd3UuHwnzM/MGsAn2tU
GlddPfU+Ccy/Z5l7c+a5UX0c
=lnAI
-----END PGP SIGNATURE-----
 
Back
Top