The user is me. I'm the dbo.

Of course. I've checked out that spelling of the sp is correct and everything.

Carl

Just thought I'd let you know I finally created a solution to this problem. Since creating Schema.ini options are grayed out in Microsoft Access Projects I created one using code:

Sub...

Not sure what this has to do with SQL Server but try Zonealarm.

http://www.zonelabs.com/store/content/catalog/products/sku_list_za.jsp;jsessionid=E0gAEDUoYH2TpY5QG3WDPfope6bKxVyP1R1NB6AB3fUiqyeXhFlr!1911602324!-1062696904!7551!7552!NONE?dc=12bms&ctry=US&lang=en&lid=nav_za

Also a lot of the home internet providers provide free anti-virus and firewalls. For instance Comcast offers...

Carl

What I was hoping to do was to do as you say and export it manually and save the Spec file from that manual export. You can then list that...

Thanks, yes I tried that and it works great. If you click on the Advanced button you get a screen where you can set Text Qualifier to ", ' or...

Thanks for the reply. It's not the delimiter that's the problem. It's that it puts quotes around all data since all of my exported columns are nvarchar. Here's an example:

"Bracket...

Thanks guys. I just finally gave up and used the DELETE statement.

I do use ADO. I just saw that DAO code on a website and thought I would try it. The problem is some procedures do pass the info to Access...

Never mind. Dummy me. This is the code that caused this:

MsgBox Err.Description

MsgBox Err.Number

It might be the data type you are using. Decimal is much more accurate than float in SQL Server 2000. Here is a quote from BOL: "Approximate number data types...

I've been working on an Access Project with Access 2003 and SQL Server 2000. I tried creating a project using SQL Server 2005 and it gave me a message saying...

Thanx for the answers. I know what is causing the error. I just need to know what row is causing it so I can adjust the proc to look for...

Instead of leaving your program running fulltime, you could use Scheduled Tasks in Control Panel to open the application and run your macro. If you type "Startup command-line options" in...

These are free.

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx

Charlie