Can only open the file from within Access

[Dave]

Access 2003

Split DB in .mdb format

Shortcut from server to users desktop (I have been told recently that this
is not the proper way to do this, however I have several situations where I
am set up in this manner with no issues.).

Users can not open the file with the shortcut. They have to open Access and
navigate to the front end on the server.

Any ideas on why this is happening?

Any help here will be appreciated.

Thanks in advance
dave

 

[Albert D. Kallal]

I believe the issue is likely you have the default for ms-access to open a
database as "exclusive".

So, when using the shortcut...the first user gets into the front end and
with the default = exclusive, then no one else can get in.

When they launch ms-access first, and THEN open the file, you note a little
drop down box "open" to the right that allows you choose "open" (shared), or
"exclusive".

So, check the above...that should fix this...

I have several situations where I am set up in this manner with no
issues.).

Actually, that is not the case. If you have a split database, and placed the
front end on EACH computer, then it would NOT matter if they opened the
front end exclusive or shared. So, it flies in your face that you telling me
that you have no issues here, and yet your now coming to this newsgroup with
a service call and problems with your application due to EXACTLY not running
the application on each computer. This problem would not exist or matter if
each user actually did have a copy of the front end. So, if your company is
paying for the time to fix this (or paying you), then you given everyone
here a PERFECT example of how your wasting company resources and time to fix
a problem that would not of occurred if you had done this right.

Anyway, I would check the "default" open settings for access.
(tools->options->advanced tab).

And, you could also check your shortcut...it should be somthing like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"C:\Documents and Settings\All Users\Application Data\Rides\RidesXP.mde"

The above likely wraps...but, you should make your shortcut to the
msacces.exe..and then pass the file name as a parameter as above.

 

[dave]

Thanks for the replies.

I started with this setup being "Copies" to each users desktop. However the
users were somehow stepping on each other.
I was told by another developer (more knowledgeable them me but clearly not
as knowledgeable as the as the newsgroups helpers) that making the
connection with a "shortcut" and not "copies" would solve the problem.
As I have been recently schooled here in the newsgroups ( this post and
another) that "shortcuts" is the wrong way to do this it is now clear that I
have a programming issue. I will move back to copies.
I will try to post my issue and code and see if the real issue can be sorted
out.

Thanks again for the help and replies


dave