I need a SQL query which i could run in access DB ... for example if i give that query a table name it should return the primary key cloumn name...
Dec 05, 2009 at 07:40 AM
Syed Talha Ali
Sorry, this is a site specifically for Microsoft SQL Server, so there may not be people here who can help you with Access
try posting it at http://www.sqlteam.com/forums/forum.asp?FORUM_ID=3
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Dec 05, 2009 at 07:40 AM
Seen: 735 times
Last Updated: Dec 05, 2009 at 07:40 AM
ODBC Connection to SQL Server failing from MS Access
Changing database names in an access application
how to import to SQLSERVER
Connection Error on alternate startups
Test Connection failed while exporting from Access to SQL SErver 2008 R2
Microsoft Access SQL (insert into) multiple rows with a single statment
Where do I make the connection to the internet DB
Insert/Update SQLDB from MSAccess DB
Pass DB record to a variable
Unable to see relationship diagram in database after upsizing from Access 2003 to SQL Server 2008 R2