Using float for financial values is a bad idea. It's an inaccurate data-type and you may well get rounding errors.

Use either numeric or decimal and set the scale high enough...

I haven't worked with Access for several years, but if I recall, those queries should be executed client side, not server-side.

Can you please post the exact error, that way maybe...

It's the data source for a form? Is it set as a pass-through query?

What error are you getting?

OK, that makes a bit more sense.

Where is that query? Within a report/form/object data source? in a stored proc?

What's the error that you get?

Drop them and recreate with the new name. Constrants (primary key, unique, foreign key) are objects themselves and don't depend upon the tables for their names.

Your indexes also won't have...

I have attached an access database to my SQL Server 2005 as a backend

Please clarify what you mean by this. SQL Server is a backend database already. Do you mean...

Where the item no doesn't start with RA, or some other field. I'm assuming the first. If it's another field you want to filter on, then replace Item_No with that...

SQL does not keep any form of log of logins, unless either the option to log successful logins to the error log is checked, or the server has c2 auditing...

That's interesting.

I'll take a look this weekend, if I get a chance, see if I can find a way to trigger it.

Are you sure a DDL trigger won't tell you? Changing a column name is an alter table statement, so it should get caught by a ddl on alter table.

As Lynn said, if depends on how the table is queried. If most of your queries filter on CompanyID alone, or LocationID alone, then you will want two indexes. If...

You can use openquery and put the nolock inside

SELECT * FROM OpenQuery(server,'Select * from sometable with (nolock)')

There are a few interesting things there. first, I'll echo the recomendation the error gave. Run CheckDB on your database RAProd. There may be corruption. I hope you have a...

The database has an id of 7. Run SELECT db_name(7) to find out which that is.

Go into that database and run select object_name (1125769272) to find out which table

Why...

Sorry about that. I read in something that wasn't there.

I am interested in your experience with 2005, as mine has been exactly the opposite. I did a little experiment this...