cancel
Showing results for 
Search instead for 
Did you mean: 

Help with MS Access

N/A

Help with MS Access

Hi Everyone.

This is a bit of a long shot, but I know there are some very knowledgable people out there in +net land :-)

I'm trying to update an existing multiuser MS Access 2000 database that links
to a table on SQL Server 7 (Microsoft SQL Server ODBC Driver Version
03.81.9030). There is just one copy of the Access database that everyone
executes from a server.

The existing version of the Access database works such that the users do not
have to type in any kind of user name or password. However, the problem is
that I find my new version is insisting on a password when the SQL Server
table is first looked at. It is taking the user name, but not the password,
from the DSN entry.

I have had a look at simply adding the new fields to the live version of the
SQL server table, but experiments on a test copy seem to indicate that you have
to update the link to make the new fields be recognised. This would be fine,
except that a copy of the working access database that was linked to the
working database began to fail after I had only updated the link.

I have compared the DSN entries for the live and test copies of the SQL server
table, and the link information within live and test copies of Access. They
seem to be exactly the same. I have also checked the security menu items and
if there are any command strings attached to a shortcut.

I would be grateful for any ideas that anyone might have.

Thanks


--
Regards

Michael Beard

http://web.ukonline.co.uk/mbeard - West Midlands Job Hunt
http://www.tangent-bunny.co.uk - Live Action Roleplaying Organisers
6 REPLIES
N/A

RE: Help with MS Access

Sorry I can't help on this subject, but try posting on Woody's: http://www.wopr.com/index.html
Best wishes
> Hi Everyone.
>
> This is a bit of a long shot, but I know there are some very knowledgable people out there in +net land :-)
>
> I'm trying to update an existing multiuser MS Access 2000 database that links
> to a table on SQL Server 7 (Microsoft SQL Server ODBC Driver Version
> 03.81.9030). There is just one copy of the Access database that everyone
> executes from a server.
>
> The existing version of the Access database works such that the users do not
> have to type in any kind of user name or password. However, the problem is
> that I find my new version is insisting on a password when the SQL Server
> table is first looked at. It is taking the user name, but not the password,
> from the DSN entry.
>
> I have had a look at simply adding the new fields to the live version of the
> SQL server table, but experiments on a test copy seem to indicate that you have
> to update the link to make the new fields be recognised. This would be fine,
> except that a copy of the working access database that was linked to the
> working database began to fail after I had only updated the link.
>
> I have compared the DSN entries for the live and test copies of the SQL server
> table, and the link information within live and test copies of Access. They
> seem to be exactly the same. I have also checked the security menu items and
> if there are any command strings attached to a shortcut.
>
> I would be grateful for any ideas that anyone might have.
>
> Thanks
>
>
>
> --
> Regards
>
> Michael Beard
>
> http://web.ukonline.co.uk/mbeard - West Midlands Job Hunt
> http://www.tangent-bunny.co.uk - Live Action Roleplaying Organisers
>

N/A

RE: Help with MS Access

This sugest a configuration error, or a mismatch of the passwords.
N/A

RE: Help with MS Access

YOu could also try posting or searching the google groups...

N/A

RE: Help with MS Access

Wow, thanks for the rapid replies everyone :-)

Christopher: I'm in the process of reading through possibly relevant postings on microsoft.public.access.security. I also posted the question yesterday but have yet to get any response.

Phillip: I am pretty sure it is not password mismatch, especially as the password is displayed in the ODBC connect script. what would be the configuration parameters to check?

Stephen: I'll give it a go!

Thanks again guys :-)


--
Regards

Michael Beard

http://web.ukonline.co.uk/mbeard - West Midlands Job Hunt
http://www.tangent-bunny.co.uk - Live Action Roleplaying Organisers
N/A

RE: Help with MS Access

Just an update, I've found out about the ODBC connect script, which confirms that the username and password are correct.

So, the question seems to be why MS Access stops using the password and requires the user to type it in after, for instance, the ODBC link has been updated?

--------------

Mike Beard
N/A

RE: Help with MS Access *SOLUTION*

Turns out that I had to make a new link rather than re-configure the existing one. One of the dialogues that come up give you the option of saving the password :-)

Thank you to everyone who replied, especially Pat at Woody's and to Stephen for suggesting that I ask there :-)




--
Regards

Michael Beard

http://web.ukonline.co.uk/mbeard - West Midlands Job Hunt
http://www.tangent-bunny.co.uk - Live Action Roleplaying Organisers