SELECT t.name, IDENT_CURRENT(t.name) FROM sys.tables t

WHERE IDENT_CURRENT(t.name) IS NOT NULL

ORDER BY 1

We used the SSMA for Access 2003 mdb and SQL 2005, with excellent results.

If the app uses reserved words, or spaces quotes etc. in the table or column names, you...

Take a look at Access Key

http://www.lostpassword.com/access.htm

$39 USD

I have used the older versions & it works very well.

If you have an identity column you could use

SELECT @last_ID = IDENT_CURRENT('my_table_name')

to get the last identity value used, but if that record has been deleted, you would get the wrong...

Have not heard of that distinction. I would guess that "standard" means the old "SQL Server" driver from SQL 2000. But that does not make much sense since the native...

Here is a short script to restore a production backup over a test database:

USE master

GO

/*

ABC = production database

ABCTEST = test database

*/

RESTORE DATABASE [ABCTEST]

FROM

DISK = N'C:\Program Files\Microsoft SQL...

What kind of statements are inside your begin try - end try block, do you know what causes the error, and how are you executing the sp from Access?

If you...

Early this year we converted an Access MDB to use the MDB front-end / SQL database concept just as you are doing. The app has about 100 tables, 1300 queries,...

If all you are doing is running that UPDATE statement then you don't need all that previous code to open the recordset.

SQL Native Client is for SQL 2005

SQL Server is for SQL 2000

Instead of "CurrentDb.Execute " try "DoCmd.RunSQL "

Good to hear that things are working better.

It appears that you want to open the entire table in a recordset. Not sure exactly what you need to do, but here...

UtterSQLNewb (10/7/2009)

---

On a slightly different topic, my connections on the client PC side only work when I log on to the PC as domain administrator. When I log on...

UtterSQLNewb (10/7/2009)

---

Thanks William, I found the native client driver and installed it on the client pc. I tried some basic queries and although performance had improved a little, still...

You don't need SS2008 but you do need to install the native client on each PC. If you Google search for "Microsoft SQL Server 2008 Feature Pack, August 2008" the...