Re: Overcoming access connection properties

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/17/03


Date: Wed, 17 Sep 2003 07:49:17 -0600


You'll probably want to post this in the access adp
newsgroup. Try:
microsoft.public.access.adp.sqlserver

-Sue

On Wed, 17 Sep 2003 04:13:59 -0700, Liam McIntyre
<itmanager@wpg.ie> wrote:

>
>
>Hi There,
>
>I currently developed an Access project which connects to MS SQL Server
>2000. I have developed a login screen which validate the username and
>password for the user against the security settings on SQL Server,
>however the connection properties on the Access project overwrites the
>permission on the back-end once the user has successfully logged in. Is
>there anyway I can disable the connection properties within access and
>control the connection through code on the logging screen. Any help is
>appreaciated !
>
>Thanks,
>Liam
>
>
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!



Relevant Pages

  • Overcoming access connection properties
    ... I currently developed an Access project which connects to MS SQL Server ... I have developed a login screen which validate the username and ... however the connection properties on the Access project overwrites the ...
    (microsoft.public.sqlserver.security)
  • Re: SQL server question
    ... Microsoft is deprecating it even for new development, ... An Access project is an Access file that provides a direct, ... You can connect an Access project to a remote SQL Server ... a local SQL Server database, or a local installation of the SQL Server ...
    (comp.databases.ms-access)
  • Use of Access project with SQL Server Over VPN
    ... front-end database to connect to reports and input forms ... accessing the internal network via VPN. ... creating it as an Access Project, ... terrible trouble connecting to the SQL Server through the ...
    (microsoft.public.sqlserver.security)
  • Re: Linking SQL Server tables
    ... I notice the help topic you quoted is talking about an Access project. ... or an MDB? ... > I'm trying to link tables from SQL Server to my Access 2003 database. ... > in the Microsoft SQL Server database. ...
    (microsoft.public.access.externaldata)
  • Re: client/server application using Access as front end
    ... Access project is a quick way to create clients. ... You can remove the standard Access menus from your your client so that users ... If you have some experience with access databases you can benefit from this ... when you create an access application working with sql server. ...
    (microsoft.public.sqlserver.clients)

Quantcast