Small Database on Network

[Guest]

I have a small access database stored on our main PC.
Through our other PC which is on the network, I want that to be able to
connect to the database on my PC and create records, edit records, save
changes etc. I setup a shortcut so that it logs directly into the filepath of
where the database sits on the main PC however Access wont open it claiming
there is a potential security risk etc.
Any ideas how to correct / bypass this or an alternate solution ??
BR
Ben

 

[Guest]

Hi Ben,

Does it give a specific error message? Have you tried it in reverse order
(put the dB on the other PC)?

Tips for professionals using access: http://accesspro.blogspot.com/

 

[Guest]

It is working fine if it runs off that machine on its own.

 

[Ron Hinds]

You didn't say what version of Access but I'm assuming Access 2003. Cut and
paste the following into a text file (all between Begin and End):

----- Begin -----

REGEDIT4

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Security]
"Level"=dword:00000001

----- End -----

Rename the text file to Access.reg

Double click the file and when it asks if you want to add this data to the
Registry click Yes. Do this on the PC that is having the error message.