Re: Only want to insert a record



Dave wrote on Wed, 11 Jan 2006 09:58:56 -0000:

> Dear Mark,
>
> Thanks. I'll try looking into the user permissions aspect although the
> database is simply a personal one on my PC with no security settings set.
> Of course I only wanted to use Access as a simple convenient platform
> (which I know) to do the development the actual platform is a real
> database (I think it's MySQL) on my provider's server. It is a good
> suggestion though to look at alternatives eg MySQL or the 'lite' version
> of SQL Server (I did not know there was one!).
>
> But really, it SHOULD be possible to do this simple thing with Access
> should it not? I can't believe nobody out there has done it.

Who says nobody has done it? I've got simple ASP applications running here
that use Access databases and don't have the problems that you're having.
I'd completely forgotten about having to give IIS permission to the .mdb
file to modify it - without that, it's always opened in read-only mode.

Dan


.



Relevant Pages

  • Encrypt SQL Database
    ... I want to distribute a application that uses SQL Server ... database. ... Nobody must read or change stored proc, ... with applications like query analizer nore ...
    (microsoft.public.sqlserver.security)
  • Re: Database securing problem
    ... distribution and it should work on all Windows platforms, ... That's the reason for using MSDE 1.0 and not the new ... database is to stop the MSDE, copy the mdf and ldf files ... >> Whatever user permissions for my database I set, ...
    (microsoft.public.sqlserver.security)
  • Re: ADO.NET help - Filling a DataGrid with contents of a DataSet
    ... database requested in login 'SCMS'. ... To me this is an error with my connection string. ... Check your web folder's user permissions in IIS. ...
    (microsoft.public.dotnet.framework.adonet)
  • One of 15 users cannot open DB
    ... The database I have set up is located on a general server. ... Microsoft Office Access can't find the database file 'H:PUBLIC\GP PURCHASE ... If he opens Access and then tries to open the database he gets the following ... user permissions on this. ...
    (microsoft.public.access.gettingstarted)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)