solutions07
Programmer
Hi All,
I am assigned a this task of resolving the problem that the other team is running into with Access 2002 application. The application is originally created by a contractor and he has given up on the problem.
I am very new to Access 2002 and I have spent only a week with it and the problem. So my apologies for any sort of technical typos or redundant information for all the experienced people in the forum.
Problem -
Basically there is a form object that allows users with admin permissions to create new users, assign groups, passwords etc. So the user is added to the table and works smooth till that step.
When the user logs in, by default the file format of the application starts up in Access 2000 and the new user gets a error "Records cannot be read, no read permissions for MSysAccessStorage". Now all the other users [those few for whom it had worked] have the application starting up with Access 2002. But all the table objects are basically same.
solutions I tried -
1. Created users using Tools-> Security and assigned groups/permissions/passwords. It worked perfect for that bunch. The file format in which the application started up had Access 2002
2. Created some users using the Forms. They all started up with Access 2000 with the above error.
3. I changed the default file format from Tools->Options to Access 2002.
4. I changed the registry settings for default file format (10 for Access 2002).
5. I noticed that the VB module for create users didnt have a provider and I also specified provider as "Microsoft.Jet.OLEDB.4.0"
6. I tried to convert database to Access 2002 for that user, but the error messages that follow are "Records cannot be read, no read permissions on MSysAccessStorage" & "Database is already created to the requested version".
7. created a new workgroup that default opens with 2002. And added that user to that work group.
Nothing has worked so far.
More Details -
The OS hosting this application is Windows 2000. I am quite certain there is some problem with the system set up and most likely I might not be able to find a solution that would fix it programmatically.
I am willing to provide more specific information as required.
Thanks a lot for all your support. My team will really appreciate it.
I am assigned a this task of resolving the problem that the other team is running into with Access 2002 application. The application is originally created by a contractor and he has given up on the problem.
I am very new to Access 2002 and I have spent only a week with it and the problem. So my apologies for any sort of technical typos or redundant information for all the experienced people in the forum.
Problem -
Basically there is a form object that allows users with admin permissions to create new users, assign groups, passwords etc. So the user is added to the table and works smooth till that step.
When the user logs in, by default the file format of the application starts up in Access 2000 and the new user gets a error "Records cannot be read, no read permissions for MSysAccessStorage". Now all the other users [those few for whom it had worked] have the application starting up with Access 2002. But all the table objects are basically same.
solutions I tried -
1. Created users using Tools-> Security and assigned groups/permissions/passwords. It worked perfect for that bunch. The file format in which the application started up had Access 2002
2. Created some users using the Forms. They all started up with Access 2000 with the above error.
3. I changed the default file format from Tools->Options to Access 2002.
4. I changed the registry settings for default file format (10 for Access 2002).
5. I noticed that the VB module for create users didnt have a provider and I also specified provider as "Microsoft.Jet.OLEDB.4.0"
6. I tried to convert database to Access 2002 for that user, but the error messages that follow are "Records cannot be read, no read permissions on MSysAccessStorage" & "Database is already created to the requested version".
7. created a new workgroup that default opens with 2002. And added that user to that work group.
Nothing has worked so far.
More Details -
The OS hosting this application is Windows 2000. I am quite certain there is some problem with the system set up and most likely I might not be able to find a solution that would fix it programmatically.
I am willing to provide more specific information as required.
Thanks a lot for all your support. My team will really appreciate it.