Error 3051 Help Please

[sk]

I have developed an Access 2007 database (split into fe/be) and have access
set to shared and no locks. When I place the BE on the server and try to
connect the FE (on user PC) linked tables it is resulting in a error 3051. I
have opened 5 differnet versions of the FE on my PC (FE and BE on the pc)
without any issues.

Is this error most likely the result of permissions on the server or is
there something else I need to look at? Any hints/tips would be appreciated.

 

[Gina Whipp]

SK,

First things ti look at... Make sure you are not opening the database in
Exclusive mode and that it is in a Trusted Location...

http://www.regina-whipp.com/index_files/TrustedLocation.htm

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have developed an Access 2007 database (split into fe/be) and have access
set to shared and no locks. When I place the BE on the server and try to
connect the FE (on user PC) linked tables it is resulting in a error 3051.
I
have opened 5 differnet versions of the FE on my PC (FE and BE on the pc)
without any issues.

Is this error most likely the result of permissions on the server or is
there something else I need to look at? Any hints/tips would be
appreciated.

 

[sk]

Gina,

I was going to check "Trusted Location" in the moring. Love that little
feature.

As for "Exclusive mode", does it matter when I'm opening a FE that is on my
PC and the other user is opening a second copy of the FE on thier PC. (both
with linked tables to same BE). If we are just double clicking the file to
open, it will not be in "Exclusive mode" or am I wrong in that assumption.
If I am, how do I set the default so it is not Exclusive mode.

Thanks

 

[sk]

I have the Default Open Mode set to Shared but I think that setting is just
for my machine. Is there a way to set it for the specific database (either a
setting or via VBA code)?

 

[Gina Whipp]

SK,

That setting is per machine and I don't think there is a way, at least not
that I know of, to set that via code. Another thought, have you made sure
the folder permissions are Read, Write, Delete (some will argue but Delete
but I make sure they have that.)

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I have the Default Open Mode set to Shared but I think that setting is just
for my machine. Is there a way to set it for the specific database (either
a
setting or via VBA code)?

 

[sk]

Thanks for the help Gina!! I will check the permissions again in the morning.

One additional question. When Access links the tables does it do it based
on the user permissions or does it do it with an "admin" (or something else)
connection? All of my SQL and controls are to the linked tables in the FE so
the only thing making the connection to the BE is the actual table links.
I'm wondering if access does this via some other user account and not the
actual User. I know the users have to have the permissions just to see the
BE to make the link but I'm not sure how Access actually processes the
connection.

If it helps, I'm using Dev Ashish's RefreshLinks code to make the
connections

 

[Gina Whipp]

SK,

I'm not sure I understand the question but Access does not make connections
based on Windows Users permissions. Is your back end and SQL Server or
Access database?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thanks for the help Gina!! I will check the permissions again in the
morning.

One additional question. When Access links the tables does it do it based
on the user permissions or does it do it with an "admin" (or something else)
connection? All of my SQL and controls are to the linked tables in the FE
so
the only thing making the connection to the BE is the actual table links.
I'm wondering if access does this via some other user account and not the
actual User. I know the users have to have the permissions just to see the
BE to make the link but I'm not sure how Access actually processes the
connection.

If it helps, I'm using Dev Ashish's RefreshLinks code to make the
connections