MS-ACCESS DB for ODBC Logging

On Sun, 4 Jan 2004 18:17:15 +0100, "Kristofer Gafvert"
<kgafvert DeleteThis @NEWSilopia.com> wrote:

 >Hello,
 >
 >Yes, that works fine.
 >
 >Please have a look at:
 >
 >"How do I configure ODBC logging to log to a Microsoft Access Database?"
 >http://www.iisfaq.com/default.aspx?View=A151

You can do this but you will almost certainly experience performance
related problems, especially if the site gets anywhere near busy :

What are the limitations of Access?
<a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2195" target="_blank">http://www.aspfaq.com/show.asp?id=2195</a>

You'd probably be better off using SQL or at least the MSDE version :

What are the limitations of MSDE?
<a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2343" target="_blank">http://www.aspfaq.com/show.asp?id=2343</a>


Regards,

Paul Lynch
MCSE<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: MS-ACCESS DB for ODBC Logging 

That is true!

And another option (if SQL Server or MSDE is not possible), is to log to
text files, and then at the end of the day run a script that inserts
everything in the access database. But...the file will probably become quite
large after a while, and large access files...hmmm....

--
Regards,
Kristofer Gafvert - IIS MVP
Reply to newsgroup only. Remove NEWS if you must reply by email, but please
do not.
<a style='text-decoration: underline;' href="http://www.ilopia.com" target="_blank">www.ilopia.com</a> - FAQ and Tutorials for Windows Server 2003


"Paul Lynch" <paul.lynch.DeleteThis@nospam.com> wrote in message
news:ovjgvvgibhlvnlgeefrqllcsk53p28jahn@4ax.com...
 > On Sun, 4 Jan 2004 18:17:15 +0100, "Kristofer Gafvert"
 > <kgafvert.DeleteThis@NEWSilopia.com> wrote:
 >
  > >Hello,
  > >
  > >Yes, that works fine.
  > >
  > >Please have a look at:
  > >
  > >"How do I configure ODBC logging to log to a Microsoft Access Database?"
  > >http://www.iisfaq.com/default.aspx?View=A151
 >
 > You can do this but you will almost certainly experience performance
 > related problems, especially if the site gets anywhere near busy :
 >
 > What are the limitations of Access?
<font color=purple> > <a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2195</font" target="_blank">http://www.aspfaq.com/show.asp?id=2195</font</a>>
 >
 > You'd probably be better off using SQL or at least the MSDE version :
 >
 > What are the limitations of MSDE?
<font color=purple> > <a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2343</font" target="_blank">http://www.aspfaq.com/show.asp?id=2343</font</a>>
 >
 >
 > Regards,
 >
 > Paul Lynch
 > MCSE<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: MS-ACCESS DB for ODBC Logging