Problem with accessing Forms

[sampath_shiva]

HI,
I am using ms access 97 for the first time. We have an application which is created in MS Access 97....in which we have lots of forms,linked tables,queries,macros etc.

This application is used to Update certain information to our Database Oracle server . Now, say this application is updating our Oracle database ABC123 , now we are migrating from this server onto another Oracle server XYZ 123 .
All i need to do is to modify this mdb file and make it point to XYZ123 so that updations happen in XYZ123 instead of ABC123.

When I trying to open any forms,Queries Macros...Its saying I do not have Permissions.
For eg : when I m trying to Open a Form using 'Design' Button it says

" You dont have Permission to read <form name>
You need to have Read Design Permission in order to view the same".

Nobody here knows anything about this application and nobody has userid or password to administrator user acct(which I hope is there).

If I am able to open any forms which contain the DSN name I guess i will able to achive the redirection...But when I am trying to open any form it gives me the above error message.

Please help me with this.

Thanks a ton in advance.

Regards,
SS

 

[apr pillai]

problem with accessing Forms

MS-Access Security features are very effective and complex too. I don't want to talk at length here. First of all, when you open the Ms-access database, are you giving a Userid & Password ? If so the Owner/Administrator of this database didn't give design change privilages to you to modify the Form. The Administrator or the Owner of this Database only can grant you this. Go to Tools Menu Select Security-->User & Group Accounts and check for your UserName & Group Account. From Security Menu you can check your User permission settings on individual objects userlevel/Group level depending on how it is implemented.

Oracle Database may be using its own security features to give connectivity of its objects. Try creating an ODBC DSN for the new Oracle Database. Select Access File Menu-->Get External Data-->Link Tables and select the ODBC Databases() (it will prompt for the DSN) select and link the Tables. You may rename the Link-Name within MS-Access to match with the old Oracle Database-Tables so that the source Names used in Queries, Forms takes the new Tables automatically.

visit my site http://msaccessblog.blogspot.com

good luck