All,

I have a company intranet which uses a 2003 Access db as a backend,
developed with Cold Fusion (purchased as an off-the-shelf intranet). It
works fine. However I want to query one of the tables in the back end and
run a report that users can access from a link. Here's my approach, which
hasn't worked so far....

I have created a new access db and linked it to the relevant table in the
intranet backend db. I have written an autoexec macro which runs some code
to open a form enabling the user to select the report in preview or print
mode, thus limiting the user's access to the tables etc.

The second access db is on a network directory that all users have edit
access to.

I then created a link from our intranet to the network directory using the
full file path name, in the hope that access will open with the form run by
the autoexec macro.

I have 2 problems with this:

1- some people cannot open the db from the intranet link, they get the
message "file already in use".
2 - those who can open the db from the intranet link, then get the message
"could not open ......mdb file already in use" - this is the intranet
backend db.

How on earth do I get around this? Please bear in mind that I'm not a cold
fusion developer, or ASP or anything similar. I can write rudimentary html
and am learning vb.net, but in early stages. I know we could distribute the
front end to all users but that's not an option we want to explore.

Any ideas appreciated.

Julia