Heh... and people ask me why I use IDENTITY columns...

FP, think outside the box a bit... all the solutions that use an IDENTITY...

Curious... if you like the way it's done in .Net or C#, why didn't you do it that way?

Sam... I know little about MS Access... but couldn't you take one of the solutions Peter pointed and do a little conversion yourself?

This should do it...

 SELECT TableID   = sot.ID,
        TableName = sot.Name,
        IndexName = soi.Name,
        Type      = soi.XType --PK or F
   FROM dbo.SysObjects sot --Table Info
   LEFT OUTER JOIN
        dbo.SysObjects soi --Index...

Good to see you read the post the Tara wrote on the "other" forum, but she's not entirely correct.  [ > ] will erase a file if it exists and...

Since this is an SQL Server forum, what does it matter if it will work on any other RDBMS?  You believe in the myth of portable code?

I'm right with you on that one... the interview process should definitely be a two way street.   And, you did it very professionally,...

Heh... you spam a forum, insult one of it's members, and try to couch your bad form in some ill conceived rhetoric about free speech?  Truly, you are a professional...

Go Remi, GO!

You know me... can't resist a good test   I'm a bit surprised at the apparent slothfulness of the Replace method compared to the...

Heh... could save all of it if they were to format it in the GUI where it belongs

Wonder which would actually be faster? ...

Absolutely!  You want a new file name each time or do you want to reuse the same file name?

We use a "ticketing" system... you could probably build a nice little Access front-end on a couple of tables (Access or SQL).  Expect it to get pretty big in a...

Not a problem, Cole... "hijacked" was probably the wrong word... just wanted to make sure the original poster got what she needed.

Heh... and you're good at it, too   Good "seeing" you again.