Access superior in some way to anything! Really?  I didn't even know that Access had anything that could be called security.

Unless that password...

And how do propose to do that Frank if the table has only two columns and the duplicates have exactly the same values?

Ok, Dave, your solution is easier, quicker to...

As Adi said, you can't stop someone with SQL Server sysadmin privileges from viewing your schema.

However, as this and the whole app will be your intellectual property you might...

Would that mean if the person possing the problem had dates and times (in his second table containing two character fields) that didn't follow the datetime data type restriction...

Probably the most easy way is to use the database maintenance plan wizard from inside EM. It allows you to specify how often to backup, what to backup and how...

Take a look at BACKUP in BOL. I bet you also find scripts here in the script section

Why not simply delete the duplicates and then alter your index? I don't think that you'll need to export, drop.....

Have a look at the script section here. There are several...

Just to add to Allan, you can nest stored procedures up to 32 levels.

Are you providing a value for those bit columns?

I have often seen that message when it comes to Access Yes/No fields respectively bit columns in SQL Server when there is...

I have no idea

There is just one thing to watch out for when using quotename(). The input parameter is a nvarchar(129)

On SQL 2k you can use

   CREATE FUNCTION quotestring(@str nvarchar(1998)) RETURNS nvarchar(4000) AS

  ...

One last word.

Before you're drowning in BOL this one might also be interesting

http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp

And remember that directly querying the system tables is...

Can you post the statement?

That's indeed a huge task for you!

I don't know for sure, but aren't there commercial products for this around?

But I guess as you've mentioned the public domain, that the...

Sure this will work, but still NULL != empty string.