Modify secured table

T

Todd

I have secured my database and have split it into a FE and
BE. I have assigned myself full permissions to work on
anything or maybe not which leads me to my question. I
wanted to go in and add a couple more field to a table but
it says that I don't have modify permissions but when I
open the FE back up and check the user permissions I've
got all the check boxes set for me to have administrative
rights. I'm also part of the administrative group.

Is there a problem since the BE is a linked table? Is
there another way to modify my BE table? Help Please!
 
J

Joan Wild

Todd said:
I have secured my database and have split it into a FE and
BE.

I hope you split it manually and didn't use the splitter wizard.
I have assigned myself full permissions to work on
anything or maybe not which leads me to my question. I
wanted to go in and add a couple more field to a table but
it says that I don't have modify permissions but when I
open the FE back up and check the user permissions I've
got all the check boxes set for me to have administrative
rights. I'm also part of the administrative group.

You need to make design change in the backend, not the frontend.
 
E

Eric Butts [MSFT]

Hi Todd,

Well you can't make design changes to a linked table you have to open the
database file where the table resides. I think your problem maybe that you
are not using the correct *.MDW file when you open the backend as when you
open the frontend.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "Todd" <[email protected]>
| Sender: "Todd" <[email protected]>
| Subject: Modify secured table
| Date: Fri, 13 Aug 2004 12:29:28 -0700
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcSBa9m99N+PvQh2QRiWvukHkKmqCw==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:12823
| NNTP-Posting-Host: tk2msftngxa11.phx.gbl 10.40.1.163
| X-Tomcat-NG: microsoft.public.access.security
|
| I have secured my database and have split it into a FE and
| BE. I have assigned myself full permissions to work on
| anything or maybe not which leads me to my question. I
| wanted to go in and add a couple more field to a table but
| it says that I don't have modify permissions but when I
| open the FE back up and check the user permissions I've
| got all the check boxes set for me to have administrative
| rights. I'm also part of the administrative group.
|
| Is there a problem since the BE is a linked table? Is
| there another way to modify my BE table? Help Please!
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top