Have you entered "Jan","Feb","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec" in the Column Headings property of the crosstab query?

You're right Steve, after the procedure outlined by Bill above, the backend isn't needed anymore and gets discarded.

If I download and install the Express edition on my PC, I cannot...

Thank you Bill, things are much clearer now; when you say the location of the Access database doesn't matter, you mean the Access frontend, right?

If I download & install the...

One more question: end users connect to an mdb backend which is installed on a networked server disk, O:\ in my case. If I were to migrate that backend to...

Hi Scott,

"if you are running DAO (rather than ADO/ADP) you can retain the 'local' tables if you'd rather"

So you'd have a backend containing a mix of "local tables" and links...

It does. Thank you:)

Hi Bill,

Oh so even after the migration, you'd still be working with frontend.mdb and backend.mdb(which is the only file I would feed to the SSMA), only that in the...

If I migrate only the backend(i.e. tables), what do I use to relink the tables from the frontend? I don't suppose you can use the Linked Table Manager utility from...

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

I don't think you can cram multiple ALTER TABLE statements in the same SQL view, you have to prepare one query for each one.

Hi, do you open a connection and execute it? Such as

cnn1.open "Provider=Microsoft.Jet.OLEDB......

cnn1.execute "ALTER TABLE etc.....

But Sandy said what you described happens if the database is self contained and not accessing external databases.

But shouldn't the connection to a SQL database be considered as accessing external databases?

Found it:

a.WriteText FirstLine adWriteLine

now the problem is what the equivalent of

 Set a = fs.CreateTextFile("a:\schema.ini", True)  

is if I use ADODB.Stream

What would the equivalent of

a.WriteLine FirstLine                                             

be if I wanted to use

Dim a As ADODB.Stream

rather than

Dim a As TextStream

?