FoxPro has indexing on it's tables using either IDX or CDX files, they'll have the same name as the .DBF file, but with a different extension; that is if there are any indexes on the table. Hopefully, there is an index on the zipcode field that can be used to speed up the look up queries. From my experience with OLEDB, it's generally faster to send as few commands as possible, so build a single query like: select zipcode from zipcodes where zipcode in (... comma-separated list of zip codes ...) This query of course will perform much better if there is an index on the zipcode field. It will give you the list of zipcodes that exist and need to be UPDATEd and ones that aren't in the result set will be INSERTs. Keep It Simple Stupid! (KISS)

I'm not expert in ASP.NET coding or debugging, but it would seem that you have to attach the Debugger to the ASPNET_WP process in order to make this work. You'll find the "Attach to Process..." menu item under the Debug menu. Dave Kreskowiak Microsoft MVP - Visual Basic

Hi, I think a user defined function would work better for what you are trying to do (a SCALAR FUNCTION in this case) CREATE FUNCTION dbo.udfGetSeconds (@Days INT) RETURNS INT AS BEGIN DECLARE @Seconds INT SET @Seconds = @Days * 24 * 60 * 60 RETURN @Seconds END Then use it as follows SELECT dbo.udfGetSeconds(5) (edit) or in an UPDATE statement UPDATE [Table] SET [column] = dbo.udfGetSeconds(5) (edit) The man who smiles when things go wrong has thought of someone he can blame it on. If you tell a man there are 300 billion stars in the universe, he'll believe you. But if you tell him a bench has just been painted, he'll have to touch it to be sure. -- modified at 8:03 Thursday 6th October, 2005

It is possible to include vbs scripts in other vbs scripts using the 'wsf' extension. rename your main script to ScriptName.wsf And the content of the file should be like this: <script language="vbscript"> ' Put your script here </script> Good luck, Yaron Ozana Freelance web developer yaron@supertech.co.il

Try this with your appropriate primary key field name substitution. Not sure about your dbf suffix as it's been about 8 years since I touched dbase. SELECT TOP 5 SOURCE.* INTO DESTINATON FROM SOURCE LEFT JOIN DESTINATON on DESTINATON.PRIMARYKEY = SOURCE.PRIMARYKEY WHERE SOURCE.ZIP5 = '95003' AND DESTINATON.PRIMARYKEY IS NULL ORDER BY SOURCE.MAILED ASC Janya

I had a DBA once who stored the UserId created by MSSQL in a table. After a while, usually after lunch, strange effects occured. People started to see other peoples data. After a while we figured out that when the connection is dormant for a while the connection drops and a new one is created when needed. MSSQL does this all by itself. So i dont think you can get a connection all to yourself, you share it with others. Perhaps there is a way to keep the connection alive but why would you want this. HTH, Grtz, Guus

I found the problem! Public Sub New() MyBase.New() g_dbConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" End Sub as soon as i commented the "g_dbConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""" line it started to work. Can some one tell me, can i have extra code in the sub new ? besides the MyBase.New()? :confused:

I think it's closed automatically !!

iluha wrote: If i write a code in vb in the access database is there a way to run this code from server side asp. I haven't found a way to do so yet, but I'm still looking. But why do you want to do this? Why not simply add a userid to the database on the first visit, then use ADO to query the database to find if that userid exists? Using cookies will allow you to accomplish the same thing without the user having to supply a userid, but this requires that the user have cookies enabled in the browser. You can't always depend on that, but you can provide a notice on the site to the effect that it won't work if cookies are disabled. iluha wrote: And y is there a vb editor in access??? Access isn't meant to be a full relational database server. It's designed for use in a small office for developing custom database applications for internal use. VBA is included, along with the VB editor, to let you provide the functionality needed to respond to user input appropriate to your application. For general database purposes, SQL Server is the recommended solution, and you can access stored procedures remotely using a SQL Server database. MSDE is a freely distributable version of SQL Server that you can install on computers running your application so that your customers don't have to own SQL Server to use it. "Ask not for whom the bell tolls; It tolls for thee..."

iluha wrote: Thank you very much!!! I tried with ' around before, but i completely forgot about # signs. Access uses the # sign where SQL Server uses a single quote. -Nick Parker

Hi It is probably because VFP Drivers are not included in MDAC 2.6 and above. You can download this drivers from Microsoft Visual FoxPro page. Here is the link http://msdn.microsoft.com/vfoxpro/downloads/addons/odbc.asp Greeting Marek

It works now Thank you very much!!!! ilya :)

Thank ! Thank ! Thank very much!:)