If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I can't see my Access 97 Tables...
I have an Access 97 database used in our software that has two tables in it
and I can’t see either of them so I can’t modify the data. I checked and they aren’t marked as hidden or as a system object. I also checked the permissions and I am opening the database as Admin. The programmer that used to work on this must had set this up this way but I can’t find anything in Access to change to get it to show me the tables. I did find the table names in the system table MSYSOBJECTS and they both have ‘Flags’ set as 1, and I can’t modify this system object to change them to 0 to see if that is the problem. Has anyone else ever had this problem or can tell me where to information on how to view/modify these two tables? (I know they are there because our software is writing to them) |
#2
|
|||
|
|||
Don't know the "why" -- but this may be a workaround:
create a query that selects all the rows and columns from the table ie. SELECT * from TableName On Wed, 29 Dec 2004 12:59:05 -0800, Calvin wrote: I have an Access 97 database used in our software that has two tables in it and I can’t see either of them so I can’t modify the data. I checked and they aren’t marked as hidden or as a system object. I also checked the permissions and I am opening the database as Admin. The programmer that used to work on this must had set this up this way but I can’t find anything in Access to change to get it to show me the tables. I did find the table names in the system table MSYSOBJECTS and they both have ‘Flags’ set as 1, and I can’t modify this system object to change them to 0 to see if that is the problem. Has anyone else ever had this problem or can tell me where to information on how to view/modify these two tables? (I know they are there because our software is writing to them) ********************** remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security |
#3
|
|||
|
|||
=?Utf-8?B?Q2Fsdmlu?= wrote in
: I have an Access 97 database used in our software that has two tables in it and I can’t see either of them so I can’t modify the data. What about the other system and hidden tables:- if you cannot see them either, go to Tools Option View and switch ON hidden objects and system objects. If this reveals your missing tables, then you can right-click on them in the database window and reset the Hidden flag. (Note: I have checked this in A2000, but my faulty memory seems to say that it was similar in A97.) I did find the table names in the system table MSYSOBJECTS and they both have ‘Flags’ set as 1, and I can’t modify this system object to change them to 0 to see if that is the problem. In general, even trying to faff around with system tables is courting disaster. That is what the GUI is for. As a last resort, you can always try a bit of VBA: ' this needs DAO library set! For Each tdf In db.Tabledefs If GetHiddenAttribute(acForm, tdf.Name) Then SetHiddenAttribute acForm, tdf.Name, False End If Next tdf By the way, I have not tried or tested this, but it is probably a close first step. By the way, what are the names of the tables? There is some way of naming tables to make them look hidden -- I am hazy on the details because, as you are discovering, it's about as secure as a colander full of water, so I never bothered to learn or remember it. Hope that helps a bit Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
Upload Image | Jason MacKenzie | General Discussion | 1 | September 1st, 2004 04:38 AM |