I got this to work in case anyone wondered.

SET @Select = @Select + char(13) + ' AND AR.FM_USer ="' + @varUser +'"' 

Thanks.

Thank you for the replys.  I'm glad to hear that the performance of Dynamic queries are usually fine.  I will look into the "In" clause olavho.

If anyone else has any...

The DB Admin changed my Default DB to Master and it fixed the problem.

I have decided to go with a single 'User' Table that gets updated with the user's SYSTEM_Name, Installation_Key, and Current Date when they log on.  This seems to work well...

Thanks you for the replys.   I think that I have dropped the temp table idea since I finally got something else to work. I am using MS ACCESS 2003 on the...

All,

Thanks for the reponses. As figured, I was simply overlooking the solution. I didn't explore restore from devices enough. I had it in my head that it was for Tape...

Paul,

Your Code actually returns the Month and Day instead of Month and Year.

Thanks.

fryere

Thanks Allen,

I had thought about converting it and then chopping it up, but I thought that there maybe something built in that I was overlooking.  At Least I won't have...

cwedgewood:

What happen was that I didn't have the Unique Table property set on the Form.  The other user wasn't able to insert a record (which makes sense because the form was...

Right Now I am Using Access 2000, however I may migrate over to VB.Net later on.

cwedgwood50: The Form uses a Sql Statement that is set to the Form's Recordsource when the Form Opens.

D Poole:  All Table are created by me  dbo.table.

noeld:  I have seen Board...

We are both using Access 2000.

I felt like it had something to do with me being the DBO.

This issue was really causing be to rack my brain, since I thought that it...

It was a problem with user priveledges to the Laptop. Luckily, I had Admin rights to the Laptop and could add my network log in the Admin group. ...

It must be an XP problem since I can go the the server and export to another database on the server, but can't on my laptop. Has anyone experience...

Bill Nye,

Good sugguestion, nice & simple. I think I can make that one work.

Thanks for everyone Input.

fryere