in reply to Inserting a record into an Access database

Hi Doyle,

Have you tried selecting records? I mean, is the problem with the connection or with the DB operations? Since you're using the CGI modules, I assume you're working with a web server...which one?

In addition, you must ensure the user that the process is running under has both read AND write permission for the Access file. If you can select records, but not insert them, I'd bet user permissions are your problem.

HTH,

Larry

Update: Fixed a typo. :)

  • Comment on Re: Inserting a record into an Access database

Replies are listed 'Best First'.
Re^2: Inserting a record into an Access database
by Doyle (Acolyte) on Feb 21, 2005 at 19:06 UTC
    I have no problem selecting the records that works. Only when I want to insert is when the problem arises. I am checking to see if I have read/write permissions. thanks