Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old September 20th, 2007, 04:29 AM
Authorized User
 
Join Date: Jan 2007
Location: , , United Kingdom.
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default Change tbl permissions using VBA

I am creating a system that logs visits to site, using a sql backend, access front end. Now loading the front end I have a procedure which creates a local mdb file in the users my documents folder. The purpose of the local mdb file is that it gives the user an offline record of all their visits.

When there are design changes which involve additional tables adding to the local mdb, I want to run on startup a sql query to check whether table exists in the local mdb. So I do a Select Query of MSysObjects where name='tblname'.

However when I load up the front end I get an error saying Record cannot be read, no read permission of MsysObject. Now I can obviously go into the VB Created Mdb and alter the permissions. However that is no good when I need to distribute to 100 workstations.

What I need is, VB code to alter the permissions on the MsysObject, when I create the Local Mdb.

Any Idea's??


  #2 (permalink)  
Old October 12th, 2007, 01:19 AM
Friend of Wrox
 
Join Date: Jul 2005
Location: Oklahoma City, OK, USA.
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Check out this:

Sample Code to Check for Table or Query in a Database
http://support.microsoft.com/kb/210398

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Form Code with VBA emt_101 Access VBA 2 October 17th, 2008 11:45 AM
How to change FTP File permissions malay mehta PHP How-To 0 October 29th, 2007 05:18 AM
VBA to change source of link table DonLennon Access VBA 4 March 19th, 2006 06:18 PM
VBA to create new tbl and append 3 tbls ckentebe Access VBA 2 May 28th, 2004 10:43 PM
change paper's format with VBA exarkuun Excel VBA 1 December 9th, 2003 11:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.