Client not able to view current records?

[scouser]

Hi guys. I am trying to help a client regards an un-supported access database. They have a DB that is shared across a network (only have experiance on database on single client, never set up security etc....). The DB is installed on the Server.
The DB is access via a mapped network drive. The Database folder contains the following files:
MKC Clients_Quesries.mdb
MKC Clients.mde
MKC Clients_.des

On one machine the MKC Clients.mde is launched and 1086 records are visible. On a second machine the same MKC Clients.mde is opened but displays only 977 records?? An I missing the obvious?

Any help appreciated, she is a nice lady!!
Phil.

 

[ghudson]

Are you viewing the records directly from the table or a form?

There might be a filter in the SQL of the form so only show certain records are seen based on the user ID or the users computer ID. Looking directly in the table you should be able to see all of the records from any computer.

 

[scouser]

Thanks

Are you viewing the records directly from the table or a form?

They are viewing the records from a form so I will take a look.
Thanks,
Phil.

 

[scouser]

Nope

Looked at form properties. No filter? Form created from table. Unable to view design of form as locked.
Thanks for posting.
Phil.

 

[Joe8915]

and the tbl shows 977 records. If so I agree with ghudson, you must have a filter somewhere. Did you right click on a field to remove any filters?

 

[scouser]

Filter

I would tend to agree, but could not see a filter.
Thanks for the replies. Consider this one closed.
Phil.

 

[ghudson]

Looked at form properties. No filter? Form created from table. Unable to view design of form as locked.
Thanks for posting.
Phil.

How can you determine if a filter is being used or the data source [SQL] does not have any criteria to limit the record source if you are not able to view the design of the form?

 

[scouser]

Filter

I was able to view the properties for the form when open (obviuosly not what you meant ), however the 'view design' option was greyed out? The user is a novice so can't imagine they would have set up a filter. The DB views fine on her other machine. Any way to way to get round the forms being locked down on a secure db?
Thanks,
Phil.

 

[Joe8915]

maybe check the the security and see how its set up or hold the shift key down when entering the DB. Keep searching this form, they are damn good here. Every problem I ever had, I allways had it solved here.

 

[scouser]

Shift

I actually know that one!! Tried it before posting, no luck.
Yes great forum. I was quite an active member in 2004, bit rusty now!
Phil.

 

[ghudson]

Sounds like the db was converted to a MDE. You can rename a MDE file back to MDB so that it "looks" like a normal database file from Windows Explorer but it really is a MDE and you can not unlock/break/convert a MDE back to a MDB. You would have to have the original MDB to get into the design of a db.

The design button is not disabled in a secured db. The user would get an error message about not having permission to open a db in the design view, if it was secured with Access security using a custom workgroup and user permissions.

 

[scouser]

Thanks

Thanks for the explanation. Never dealt with secured database (creating mde's). Any links on how to do it as I have MS Virtual server so I could have a play
Phil.