Re: Access and ASP.NET working together - any advice?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Access is not secure at all (any version, numerous password hack tools),
however if you have Access on a secure PC that is running a web server (IIS)
the Access database will be less vulnerable than SQL Server 2000 database
since Access does NOT and can NOT "listen" on any communications port
because it doesn't have a Service running. However, if you want to keep
Access secure internally you'll need to make sure your server's directory
rights are setup correctly. Suggest you put the Access MDB in a directory
that is restricted to just your ASP.NET web app code.


"phil cunningham" <phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OtvgDzbIGHA.1836@xxxxxxxxxxxxxxxxxxxxxxx
>I did double post this and it has been answered elsewhere so please ignore
>
> Phil
>
>
> "phil cunningham" <phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:eReG1xbIGHA.1032@xxxxxxxxxxxxxxxxxxxxxxx
>>I am using Access to run a database within the company and also have a
>> website that makes some of the information available to the general
>> public
>>
>> And so far everything is working very well
>>
>> q. is there any problem using Access to do all our internal work while
>> the
>> DB is exposed to the web
>>
>> q. if I move to SQL server can I still use all the features of Access
>> (VBA
>> reporting etc) for our internal work
>>
>> I really like Access and would hate to have to do everything through
>> ASP.NET
>> if I don't have to
>>
>> I think I just need a little advise before I get stuck into the
>> development
>> work
>>
>> Any feedback will be much appreciated
>> Phil
>>
>> PS I may have double posted this!
>>
>
>


.

Relevant Pages

  • Re: Word 2007 Missing User Level Securitty - ARRRGGGGHHHH What were they thinking?
    ... File servers aren't secure? ... Access predates Windows security, ... database system has never been updated or kept current. ... the OS-based database server product, ...
    (microsoft.public.access.security)
  • Re: Created on Access 2003, but.......................
    ... But that's not secure under any scenario, as any port scanner ... Well, you still need a userid, password and database name. ... You're assuming the server remains in a secured configuration. ...
    (comp.databases.ms-access)
  • Re: Security on a common server
    ... Being that this database is sitting on a common server ... they shouldn't even be able to open your secure mdb ...
    (microsoft.public.access.security)
  • Re: Use Level Security Shortcut
    ... You'd put the backend on your server, and give each user a copy of the frontend on their computer. ... Change the paths to reflect the location of the frontend on your PC, and the path to the secure mdw, which you put on the server. ... an actual shortcut to the mdw was setup by the wizard on my desktop. ... desktop which is the only way the database can be opened. ...
    (microsoft.public.access.security)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)