grovelli

---

Can you use Sql Server Migration Assistant (SSMA) for Access against the SQL Server Express version?

If I migrate only the backend(i.e. tables), what do I use to relink the...

I've been working quite a bit with SSMA, it works very very well but there are a few issues related to Access:

Every table needs a primary key, otherwise you can't...

npsarros,

You should definitely check out pass-thru queries. A pass-thru query lets you execute T-SQL directly from Access, and you can use the results just like any other Access query.

For example,...

My boss sent me this link to a post that contains the reg keys to delete. I tried it, the patch worked, and my version is 3068 hurray.

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.setup&tid=f7f417c2-3128-41a7-bf8e-e1104c7a9ceb&cat=&lang=&cr=&sloc=&p=1

This fixed it...

On my work PC, the failed update left SQL Server stopped, so it would not connect. (The browser service was still running.) I went into the SAC tool and started...

Failed for me too, running MSSQL Express at work on a newer laptop w/ plenty of RAM and free disk space, Win XP. It failed when installing via automatic updates....

Quick and dirty way:

OPEN "C:\Querytext.txt" FOR OUTPUT AS #1

PRINT #1, CurrentDb.QueryDefs("MyQueryName").SQL

CLOSE #1

What does "legal" have to do with cloning? According to

http://sqlblog.com/blogs/kalen_delaney/archive/2007/11/21/cloning-in-sql-server-2005.aspx

"Cloning a database means creating a statistics only copy of it, so that you can examine execution plans for poorly performing...

I got it wrong, didn't know that creating a snapshot for msdb is not "prohibited" but I have to wonder - what would be the purpose of creating a snapshot...

You have the auto-join option turned on, and Access is guessing the relationships based on field names & data types.

Click Tools ~ Options and click the Tables/Queries tab. Un-check the...

Could it be that the field is set for Required = Yes - ?

Thanks, it worked.

Bill

Create a new query in Access, don't add any tables. Click Query ~ SQL Specific ~ Pass-Through. In the SQL window, type your statement e.g.

EXEC usp_MyProcedure '6/6/2008'

then click View ~...

hyd (6/5/2008)

---

hii everyone

I wanted to know how to convert access97 to sql server 2005

If anybody has done it could u please list down the problems u face d and how...

Create a new table named tblTables_RecordCounts with fields TableName (text,64) and NumOfRecords (long integer) and then run this:

Sub GetRecordCounts()

Dim db As DAO.Database, tdf As DAO.TableDef, rs...