Security wizard database macro

[Spook]

I have access 2003. Is it possible to run a macro only when one of the users with full administrator rights opens the database.

I have a link to an ODBC database that other users will not have access to so linking won't work. I want to be able to update the link only when I and others with full rights open the database. Is this poossible.

Thanks in advance.

Stephen

 

[DCrake]

How does your application recognise who has admin rights? ULS or customised?

 

[Spook]

How does your application recognise who has admin rights? ULS or customised?

Sorry. Not very techi. What does ULS mean.

I used 'User and Group Accounts' to set up names and give them admin rights.

 

[DCrake]

USL User Level Security.

 

[Spook]

USL User Level Security.

That would be what I used then.

I think

 

[DCrake]

What is it you don't want none admin users doing?

 

[Spook]

I want to refresh links to an ODBC database whenever I open the database. However only admin users will have access to this ODBC link so the macro will not work for others and I don't want to confuse other users with messages they will not understand.

Cheers

 

[DCrake]

If you have a set of linked tables to a specified back end you can refresh the links of an identical source in a different location. However it seems to me that what you want is something different. Are the two different ODBC links pointing to two different data sources or is it simply a case of data contents that arre restricted to access rights?

 

[Spook]

It is simply a case of data contents that have restricted access rights.

Stephen

 

[DCrake]

The fact that is is data related means that there is no need to change ODBC Links. If you think about it you would have to maintain two datasets one for admin and one for others.

How do you distinguish what can be seen by a none admin person? Can they see the same tables but only certain records or are whole tables private. Or can they only see records that they themselves created?

Only asking as this will affect your Role Based Access Control (RBAC)

 

[Spook]

Non admin users have only 'read only' rights. They can see all of the data, if they know what they were looking for but are led, via the switchboard to run certain queries only that give them the data they want.
The data from the ODBC link is a total unrelated dbase which gets updated regulary and the data from this effects the queries the non admin users can run.

Hope this all make sense.

Stephen