June 28th, 2005, 06:38 PM
Passing User Authentication in VB
I'd like to use Username and Pw, entered during Windows login, to access mdbs, remote folders, etc.
...obviously, I don't want user to retype his credentials
Anyone knows how to do it?
June 29th, 2005, 02:20 AM
Re: Passing User Authentication in VB
Remote folders etc should automatically use the creditials of the logged-in user.
For mdbs... Access help says this:
In order for the Enable system administrator (SA) user name check box to be enabled, the following must be true.
The Access project must be connected to a SQL Server 7.0 (or later) database or a Microsoft SQL Server 2000 Desktop Engine.
The SQL Server database must be running on a Windows Server platform.
The SQL Server must be running on the same computer as the Access project.
The current Windows user must be an Administrator for the computer.
The current SQL Server user must be a member of the System Administrator role.
Click Here to Expand Forum to Full Width