Shared Access 03 Database will not open after one user is running

[Guest]

The database is a simple shared database running on a shared server. After
one user is running the database if you click on the database file or a
shortcut to the file nothing happens. If you launch Access and open the file
through the product it will open. This is not a good solution since a
shortcut is much easier for the users. Our computers are newish Dell's
running XP and the following version of access: 2003 (11.6566.8132) SP2.

This is not an issue compacting has any affect on.

On a side note whenever I open the file through access I get no message but
clicking on the file or link I get "Open File - Security Warning Do you
want to open this file" I think I need to create a Digital Signature. I
have not done this. Will this solve the problem or do I need to go to each
users machine to have them accept the signature.

Thanks for any help.

 

[Guest]

doesn't anyone have any ideas?

 

[germaine.oliver]

Two issues here:

1) Only working for one user at a time: that may be due to some
security settings, but since I never have two users trying to use the
same thing at the same time, I've never experienced it. You should
have your database split so each user is accessing a different front
end.

2) The security warning has do do with the security settings on
Access, but I don't know if a digital signature fixes it. Presumably,
if you have a digital signature and can add that to a "trusted" list,
that would work, but I have no experience with that. I just tell my
users to say "open" and "ok" or whatever the two windows are. Maybe
not a perfect solution, but it works for my purposes (but I am not a
professional developer, just a dinker).

Sorry it's such a sad reply, but since no one else has offered any
info, I thought I might be able to help a little... "split the db" and
"tell users what to click".

 

[Guest]

The database is a simple shared database running on a shared server. After
one user is running the database if you click on the database file or a
shortcut to the file nothing happens. If you launch Access and open the file
through the product it will open. This is not a good solution since a
shortcut is much easier for the users. Our computers are newish Dell's
running XP and the following version of access: 2003 (11.6566.8132) SP2.

This is not an issue compacting has any affect on.

On a side note whenever I open the file through access I get no message but
clicking on the file or link I get "Open File - Security Warning Do you
want to open this file" I think I need to create a Digital Signature. I
have not done this. Will this solve the problem or do I need to go to each
users machine to have them accept the signature.

Thanks for any help.

 

[Guest]

1) Regarding the problem opening the database, I don't know what causes the
problem but a work around is to create a shortcut which includes the location
of the MS Access exe so your shortcut target will look something like this:

"C:\Program Files\Microsoft Office 2000\Office\MSACCESS.EXE"
"C:\SomeFolder\YourFile.mdb"

This causes MS Access to load the specified mdb file.
There are other switches which can go in the shortcut, find them by
searching for "Startup command-line options" in the MS Access help.

2) One of the reasons for getting security warnings is because by default MS
Access sets the macro security level to high or medium (Tools | Macro |
Security). This is done to prevent malicious VBA code from ruining your
computer. Digital signatures might solve the problem but I've also found that
making sure the latest service packs are installed and setting the macro
security level to low resolves the problem. I'm not recommending you do this,
that is at your discretion but it does elliminate the warnings and unless
your users are running apps that they shouldn't, there shouldn't be any
issues.