Thanks Brian -

In this particular situation, it didn't matter if they were logged in since it was a SQL/Access problem.

Thanks for the information though on multiple sessions. I looked...

I haven't gotten the group thing to work either. Without an Active Directory domain, you seem limited to using the bottom part of that dialog box:

For a login not...

I fixed it, but still want to know how the rights are handled. I would like to know if there is a better way.

In this instance I forgot to...

You could select distinct * into newtable from existing_table and then rename the newtable.

You could select * into newtable from oldtable group by all_your_fields.

Couple of similar ideas.

Michelle

I had a problem similar to the knowledgebase article. I called Microsoft, they were helpful and gave me the patch.

It is happening to me a lot when queries aren't...

In an NT domain you cannot pass the rights to another server. You must have an Active Directory domain to do it.

Your best bet is to allow all users...

Are you in an Active Directory Domain or an NT 4.0 domain?

I'm currently testing Adept SQLDiff. It is nice when the tables are in different databases, but you can't compare two tables in the same database. I can only...

In the Import/Export Wizard, you must choose 'Copy Objects and Data between SQL Server Databases' in order to get all the data and relationships. Now your best bet is...

My apologies joshcsmith13, my tired brain read your suggestion as a way to never have the 'B' in field1. I am awake now and I understand it. I...

If they choose C, X, or R then the field2 can be 0000. It is only when they choose B that field2 must be a real document number.

Thanks

I had to give up on triggers with an Access frontend for this reason. I thought at one time that if the developer created a form instead of using...

The link works now. I can email the patch if you haven't already gotten it.

Michelle

Use the DTCPing utility in knowledgebase article 306843 to see if your servers have duplicate CIDs for the MSDTC. If so then that is your problem and you will...

One other thing is to check how the data is striped to the SAN. With a SAN, the drives can have a particular stripe size and the OS on...