Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Tables
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Tables
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2005 at 11:37am
name stays the say.

the name of the table is called name

so that is orrect.
Back to Top
felix.akinyemi View Drop Down
Groupie
Groupie
Avatar

Joined: 09 December 2004
Location: United States
Status: Offline
Points: 113 		Post Options Post Options   Thanks (0) Thanks(0)   Quote felix.akinyemi Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2005 at 11:47am
im getting this error
 


 

Microsoft JET Database Engine error '80040e09' 

Record(s) cannot be read; no read permission on 'MSysObjects'. 

/tables.asp, line 16
 
and line 16 is
 
rs.Open strSQL, adoCon
 
and my query is
 
 
strSQL = "SELECT NAME FROM MSysObjects WHERE TYPE=1 AND FLAGS=0"
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 01 February 2005 at 4:25pm
You need to open the database with the admin account. I think when you use external connections you should specify even if there is no password that you connect via admin like user="admin";password="";
Blog | MPG Tracker
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.