Read Permissions

[cdacey]

Hi Everyone,

I have a split database that generally has no problems. I loaded this application on a Dell Sever running WinXP Professional, and I have been unable to open in the program using access runtime. I can open the frontend fine by using access directly, but when I try to use the access runtime, I get a message "Records cannont be read, no read permissions on SwithBoard Items".
I checked that the file is not read only, and that the backend folder is shared and allows network users to edit my files.
I am baffled, but have a strong feeling it has something to do with Win XP.

The funny part is that remote workstations running Win XP, can access the backend on the server through access runtime without a problem.

Any thoughts ???

Thanks Chris

 

[Autoeng]

Your error message indicates to me that security has been applied to the db itself. Is it a secured db?

 

[cdacey]

Security

Yes,
It has user level security, but there is no Database password. What does this mean in relation to the access runtime?
Thanks Chris

 

[Autoeng]

Sounds as though security for the users has been changed so that they cannot open the switchboard form.

 

[cdacey]

I have checked the switchboard, and all permissions look ok. This pc I am having the issue on does have mcafreee security center installed, would that effect anything ? The other pc with xp seem to work fine?
Stumped
Chris

 

[cdacey]

One last thought,
Can user profiles in windows possibly effect your ability to open a backend file in access runtime ?

 

[Autoeng]

In a secured db environ the user must have create and delete permissions because when the db is opened the user is logged on a ?.ldb file. When the last user logs out the file is deleted.