Access 2007 Upsizing to SQL Server 2008 Express

[Aran]

Hi,
I want to Upsize an access 2007 data base to SQL Express 2008, but access
doesn't recognise the server, is it because of access edition is lower than
SQL Express edition?

[John W. Vinson]

Post by Aran
Hi,
I want to Upsize an access 2007 data base to SQL Express 2008, but access
doesn't recognise the server, is it because of access edition is lower than
SQL Express edition?

No.

Office has one series of product numbers, SQL a different and completely
independent one.

Don't know what the problem might be; who's in charge of the SQL/Server
instance? Can you create an ODBC link to it?

[Tony Toews [MVP]]

Post by Aran
I want to Upsize an access 2007 data base to SQL Express 2008, but access
doesn't recognise the server, is it because of access edition is lower than
SQL Express edition?

I would assume so.

There is a tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
which should recognize SQL Express 2008. This tool may do a better
job.

Tony

[Aran]

Thanks Tony, I downloaded the SSMA and it did all the works for me.
The only information I shall mention is if you have Attachement field in
your MS Access tables it will be converted to varchar type in SQL so you
should cahnge the varchar to varbinary(max) type to let you attache files
again to the field.
the only problem which I have is during this conversion all attachements
will be lost and I shall attache the files again one by one in new SQL Server
Data base.
If you can give a hint about this problem I appreciate it.
Thanks

Post by Tony Toews [MVP]

Post by Aran
I want to Upsize an access 2007 data base to SQL Express 2008, but access
doesn't recognise the server, is it because of access edition is lower than
SQL Express edition?

I would assume so.
There is a tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
which should recognize SQL Express 2008. This tool may do a better
job.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Brett Labistour]

Hi All,
Can someone tell me is there is a SSMA for MS access to SQL Express (2008),
the link provided only has one for SQL Server, not express; or will the one
provided work for both?
Thanks

Post by Aran
Thanks Tony, I downloaded the SSMA and it did all the works for me.
The only information I shall mention is if you have Attachement field in
your MS Access tables it will be converted to varchar type in SQL so you
should cahnge the varchar to varbinary(max) type to let you attache files
again to the field.
the only problem which I have is during this conversion all attachements
will be lost and I shall attache the files again one by one in new SQL Server
Data base.
If you can give a hint about this problem I appreciate it.
Thanks

Post by Tony Toews [MVP]

Post by Aran
I want to Upsize an access 2007 data base to SQL Express 2008, but access
doesn't recognise the server, is it because of access edition is lower than
SQL Express edition?

I would assume so.
There is a tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
which should recognize SQL Express 2008. This tool may do a better
job.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Sylvain Lafontaine]

Will work equally well (or bad) for both.
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

Post by Brett Labistour
Hi All,
Can someone tell me is there is a SSMA for MS access to SQL Express (2008),
the link provided only has one for SQL Server, not express; or will the one
provided work for both?
Thanks

Post by Aran
Thanks Tony, I downloaded the SSMA and it did all the works for me.
The only information I shall mention is if you have Attachement field in
your MS Access tables it will be converted to varchar type in SQL so you
should cahnge the varchar to varbinary(max) type to let you attache files
again to the field.
the only problem which I have is during this conversion all attachements
will be lost and I shall attache the files again one by one in new SQL Server
Data base.
If you can give a hint about this problem I appreciate it.
Thanks

Post by Tony Toews [MVP]

Post by Aran
I want to Upsize an access 2007 data base to SQL Express 2008, but access
doesn't recognise the server, is it because of access edition is lower than
SQL Express edition?

I would assume so.
There is a tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
which should recognize SQL Express 2008. This tool may do a better
job.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[Margaret]

Please visit ***@hotmail.com/blog
I am starting up a business and need new customers. Any help that you could
give me, I would really appreciate it. Im not spaming anyone, so please let
me know if there are anyone you know who lives in the london area and would
be interested in the purchase of medical uniforms.

Im trying to get as many customers as i can. i need help tho. Please pass
this email on to whom ever you know who would be interested. I would really
appreciate it.

Here is a little about it:

We are a business that makes Medical Uniforms which are made for Nurse's,
Doctors, and any Medical team that there is out there like PSW's.

You can find more out about it at: ***@hotmail.com/blog

We have flexible plans to accommodate growth. All size's, styles and colors
that you can think of

We are located in London, Ontario

Thank you for your time.

Margaret

Post by Aran
Hi,
I want to Upsize an access 2007 data base to SQL Express 2008, but access
doesn't recognise the server, is it because of access edition is lower than
SQL Express edition?