You know what...it works when I use query analyzer, but does not work using the view editor. I get an error saying "Case is not supported". Don't you...

Does this work in views? I tried it and it didn't work. Maybe I messed up the syntax.

There is a one-line command in Access 2000 called TransferSpreadsheet. You give it the parameters - spreadsheet location, and table name to insert to. When I created the...

I do have roles set up. I gave the user's role all possible permissions on all objects. Also, I don't want the process to create a new table....

Thanks alot! I'm new at this so bare with me. My next question is - how do I get the login ID?

Thank you so much. This is new to me. I had successfully printed from stored procedures, but I had no idea it wasn't available in triggers.

No I haven't because this is a new problem that suddenly popped up. Also, we are just beginning the process of redesigning the application. This is a very...

I have modified some tables, but then I refreshed the link so the changes would show up. I just tried deleting the links, then completely adding them from scratch....

Thanks for responding, and I'll try that. We are re-doing the application, but in the meantime it's a problem. We moved the data to SQL Server because it...

I was brought on to do a major overhaul to a really big, really bad Access database application. Phase 1 is to move the data to SQL Server because...

We want to make the database very secure. We don't want anyone to just walk up to a computer and have rights to the database. Also, we want...

Access won't let me change it. It's a read only table

Which Access system table houses that information? I looked at the system tables and didn't see it anywhere.

This is a good work around. But, I was hoping to get rid of the extra step of deleting the auto-populated user name. This is an enterprise wide...

I tried to edit the file. The User ID is blank, but Access must be saving it somewhere else because it keeps pulling it up. If it doesn't...