Recent content by 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...

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

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

That would be what I used then. I think:o

Sorry. Not very techi. What does ULS mean. I used 'User and Group Accounts' to set up names and give them admin rights.

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...

I want to do it automatically based on the ever changing dates from the original download. The intention was that others can import the data and click on a button to produce the report. Not spend ages renaming the fields each period.

Thanks.:D Don't have much as it is.:o

Nope. Will go and have a play. Never used a crosstab before. Aything I should look out for. Spook

The field headings come across in the format "RES-14Jul07". I import the data and work out the financial period and year, in the format "Period 1 07/08" based on our company's yearly cycle. And it is the "Period 1 07/08" I want to use as the field name. So that they appear asthe field names on...

Here is my problem. I have created a dbase that takes a download of financial data on a four weekly basis to produce an report for my users. The data always comes across with the same numer of columns but at each four weekly period the date moves on. To show this data in a meaningful way I need...