Can't see table? 1

[fredk]

Hi - I have the backend of a database on a shared server - I also have the front ends on the shared server - For me, it was better to do it this way because those that use the databse are not in this office and it really did not slow it down enough to worry -

Anyway, the users front end is linked to the tables in the backend ..... I have a table called tblUserinDatabase - This table contains the novell id and time that a user is in the database - there is a function in the form that opens with the database that writes the info to this table -
The strange thing is that when I go into the backend, I cannot see the table? If I go into the front end, I see it linked and I can see the table from the front end. Also, if i try to create another table in the backend with the same name it advises me that the table exists?

Any help would be greatly appreciated!

Thanks!!!

Fred

 

[willir]

Fred

I bet you a cyber coffee that the table has been hidden. since it is tied to security, this makes a lot of sense.

On the back end db, select the "tools" menu item and then select "options". Click on the "view" tab. The top section clled "show" dictates what tables are visible when you are in development mode. Enable "Hidden" objects. This will probably allow you to see your table. If not, then enable "System" objects.

I suggest that you...
- reset the view or show option after you have verified this
- consider "hiding" the tblUserinDatabase in the front end. Right click on the linked table and select properties. Enable the "hidden" option. Make sure viewing hidden tables is disabled under options for the front end. If you need to relink the tables FE / BE, you may have to tempararyly enable the view of hidden objects. Why hide it? In case of prying eyes, for example in query builder mode, they will not be able to access the table.

I say "consider" since to me, this adds to security, but I since I have not seen your application, I can not state that it will work.

Touché on whom ever design the security tracking with a Novell system.

Richard

 

[fredk]

Thanks Richard - That was it - it was hidden - I created the database and I don't remember hiding it .... Anyway, the main purpose of the tblUserinDatabase is more to track activity. You see, this database is for a bunch of "salesy" people to track their visits to clients.

They did not/do not want to do this as they never had to do it before. However, the managers want them to do it - so much so that it is now tied into their evaluations.

Anyway, I can track who actually goes into the database. I could also look @ the activity they enter but this is easier.

Thanks again for the info - you definately deserve the star!!!!!

Fred