Users can't run app...

[SepMan76]

I am learning about server administration, but need some more help. I am running Small Business Server 2000 (AD, it's the PDC) and Terminal Services. I am having users log into the server through TS, but I just want them to be able to run one application (an Access database) and log out, THAT's IT!

The problem I am having is the users can't open the Access database. I get "Microsoft Access can't find the database file 'C:\ABC\ABC2001.mdb' Make sure you entered the correct path and file name." C:\ABC is a shared folder, shared to EVERYONE. Everyone has access to ABC2001.mdb. All users, logged on either locally or through TS, get the message, except for Administrators.

Question 1: What setting(s) can be changed to allow all users to run access and open this database and where do I find these settings in the AD?

Question 2: How can I clear the desktop so when the user logs on, all they see is a shortcut to the database (no My computer, My docs, Recycle Bin, etc.) and the only option on the Start Menu is "Log Out"?

Thanks for your help in advance!!!

 

[peterve]

you can do a lot by using policies & registry tweaking to clear up your desktop.
Check

http://www.ntfaq.com

for registry tips & tricks

about the access database
I would try to let a test user log on to the server, but on a desktop environment, and then try to open the access database.
Is the database on a share ?
Does the users have mappings to access that share (using a logon script ) ? Peter Van Eeckhoutte
peter.ve@pandora.be

 

[SepMan76]

Yes, the database is on a share.

About the logon script, please explain what you mean. Does the share have to be mapped to access it? If so, how would I go about doing it? and why do administrators not have to have the mappings?

 

[peterve]

maybe only the administrators have rights to the mapping
I would create a logon script for all the users, and make sure the mapping is executed when the user logs on to the terminal server session
Also make sure the users can access the share
Additionaly, you might want to check NTFS permissions ... Peter Van Eeckhoutte
peter.ve@pandora.be