Question tables mysteriously missing?

[simpleton]

I've come into ownership of an Access Database system, and I can't seem to figure something out.

The guy who set it up (who was fired, and unavailable), has two files in this system. One in the main folder which is .mde locked. And the other (which i assume is the back-end) in a subfolder called "data" and is also .mde locked (but the mdb is also there for editing source).

So here's the problem...
I need to add a new form on the front end, so the users can do a search on the data. The weird thing is that, in the front-end there are no visible tables. Not even linked tables. There are queries though. and there are forms. Nothing in the linked-table-manager either.


What the heck did he do?

 

[Banana]

You would have to work with .mdb. .MDE is basically a protected copy and thus locked. While you could access tables inside via code, I think you'll find it easier to use the .MDB.

HTh.

 

[Vonnie]

Another long shot is to rename a copy of the the mde as a mdb. I have seen instances where the programmer didn't actually compile, but just renamed and used run switches.

I have inherited alot of db also, always interesting

the tables aren't hidden, right? Tools, Options View, Hidden Objects

 

[simpleton]

Awesome.
Problem solved.
They were "hidden" linked tables to the backend.
Learn something new everyday.

Thanks so much!!!