Access database shortcut not running the application

jase555 · 5 Jul 2007 at 09:13

Any ideas guys,

Have an access databse(2003) on drive x on my server, several users require to use it,

all i have done is create a shortcut on the database pointig to the database to open it.

It will not open, the pc's have some hdd action as if the appplication will start but nothing.

If I open access 2003 then do file open and open the databse from drive x no problems at all.

Any ideas

Access 2003 with simple database
all clients on XP with sp2
all clients on access 2003

thanks

Jas

helmet · 5 Jul 2007 at 09:20

Is the access application running in the task list?

jase555 · 5 Jul 2007 at 09:37

all i did when creating the shortcut was go to the file on the server and right click send to desktop ie shortcut

should i have done something different ?

Jas

jase555 · 5 Jul 2007 at 10:43

with further testing this morning , some times the file will not directly load if you actually click on the mdb file on the server but will ALWAYS work if you go via the file open route.

I am starting to think that the "shortcut" may not be to blame. Is there anything else i should be checking , even something the user has not setup when doing initial creation

thanks again

jas

UPDATE

moved the database to another box and still the same, so its something access related nothing to do with file permisions on the server but to do with multiple people accessing