Access DB to SQL

Is there any easy way to move my MS Access DB into MSDE?
Thanks
from the Enterprise manager
use the import data and make sure you check the copy objects option
f
"Keith" <@..> wrote in message news:#WP3vgDLEHA.556@.tk2msftngp13.phx.gbl...
> Is there any easy way to move my MS Access DB into MSDE?
> Thanks
>
|||Hi Keith,
If you have SQL Server installed, you can use Enterprise Manager as Francisco suggested.
If you don't, then you can use MS Access tools to upsize an Access Db to MSDE by following this steps:
1. Open the Access database you want to upsize to MSDE
2. From Access Menu, select the Wizard through:
Tools -> Database Utilities -> Upsizing Wizard
3. In the dialog box choose "Create New Database" (recommended approach)
4. In the subsequent screens fill out the necessary information for the SQL Server (MSDE) server - you can do this for a remote server also, type SA credentials, choose the tables to be converted to MSDE, choose what database features to be imported in th
e new dabatase (indexes, Validation rules, etc.) - preferrably leave these settings in their default state.
You can also choose to have you database controlled from within Access if you choose the default setting "Create a new Access client/server application" - this will create a .adp application controlled with Access.
NOTE 1: If something goes wrong and you have error messages during the process, you'll have to delete the newly created MSDE database and restart the process.
NOTE 2: It would be advisable to test this procedure few times before going for an upsizing of a production application. I would suggest to do this with copies of Northwind Access sample database. This way you'll repeat the procedure few times and gain co
nfidence in what you will do.
Regards,
Vasile
|||That works well, thanks.
Is there any way of importing the relationships from my Access file into a
Diagram file on MSDE.
Thanks
"Vasile Nedelcu" <vasile_nedelcu(RemoveThis)@.hotmail.com> wrote in message
news:324DE12F-69C5-46B9-8F34-C334293009FC@.microsoft.com...
> Hi Keith,
> If you have SQL Server installed, you can use Enterprise Manager as
Francisco suggested.
> If you don't, then you can use MS Access tools to upsize an Access Db to
MSDE by following this steps:
> 1. Open the Access database you want to upsize to MSDE
> 2. From Access Menu, select the Wizard through:
> Tools -> Database Utilities -> Upsizing Wizard
> 3. In the dialog box choose "Create New Database" (recommended approach)
> 4. In the subsequent screens fill out the necessary information for the
SQL Server (MSDE) server - you can do this for a remote server also, type SA
credentials, choose the tables to be converted to MSDE, choose what database
features to be imported in the new dabatase (indexes, Validation rules,
etc.) - preferrably leave these settings in their default state.
> You can also choose to have you database controlled from within Access if
you choose the default setting "Create a new Access client/server
application" - this will create a .adp application controlled with Access.
> NOTE 1: If something goes wrong and you have error messages during the
process, you'll have to delete the newly created MSDE database and restart
the process.
> NOTE 2: It would be advisable to test this procedure few times before
going for an upsizing of a production application. I would suggest to do
this with copies of Northwind Access sample database. This way you'll repeat
the procedure few times and gain confidence in what you will do.
> Regards,
> Vasile
|||> That works well, thanks.
Glad to help

> Is there any way of importing the relationships from my Access file into a Diagram file on MSDE.
Not exactly usre what you mean.
If you have installed only MSDE on the machine, from my knowledge this doesn't install SQL Server Enterprise Manager, so there is no way to have the E/R diagram.
But, if on your development machine you have installed SQL Server Developer Edition (MS recommended approach when designing MSDE applications) - or another edition - then you can open Enterprise Manager, then open databases, go down to your database, righ
t click on Diagrams, choose new diagram and choose all user tables (not the system tables) into the diagram. From there you are in business ...
Hope this helps.
Vasile
|||Hi
I am using Developer Edition on my Dev machine to do the work.
I tried what you suggest, but many of the relationships I created in Access
were not created in the Diagram when I added the tables. I assumed that
they would automatically be recreated, which seems not to be the case
"Vasile Nedelcu" <vasile_nedelcu(RemoveThis)@.hotmail.com> wrote in message
news:536A4698-7A10-435E-AE96-144622A868DE@.microsoft.com...[vbcol=seagreen]
> Glad to help
a Diagram file on MSDE.
> Not exactly usre what you mean.
> If you have installed only MSDE on the machine, from my knowledge this
doesn't install SQL Server Enterprise Manager, so there is no way to have
the E/R diagram.
> But, if on your development machine you have installed SQL Server
Developer Edition (MS recommended approach when designing MSDE
applications) - or another edition - then you can open Enterprise Manager,
then open databases, go down to your database, right click on Diagrams,
choose new diagram and choose all user tables (not the system tables) into
the diagram. From there you are in business ...
> Hope this helps.
> Vasile
>
|||Hi Keith,
> I tried what you suggest, but many of the relationships I created in Access
> were not created in the Diagram when I added the tables. I assumed that
> they would automatically be recreated, which seems not to be the case
This is strange. It should be OK and you should have all relationships as you designed them in Access.
I did my self the same procedure several times and it was OK. Not very complicated databases, indeed, but this shouldn't be an issue.
A couple of things:
1. During the upsizing process did you received any message - error message or warning?
2. Did you checked the MS Access report for the upsing process for any strange messages?
One idea would be to delete the SQL Server created database by the upsizing process and to re-start it again and check for any message during the process and the report after the process.
Maybe somebody from MS is monitoring this thread and they can intervine with an idea.
Vasile
|||It is very odd. I have tried upsizing and using both DRI and Triggers in
the radio boxes for upsizing relationships, but neither copy through all my
relationships.
"Vasile Nedelcu" <vasile_nedelcu(RemoveThis)@.hotmail.com> wrote in message
news:7D4FA1CE-1E5F-4D68-AA8C-3C12D0B76158@.microsoft.com...[vbcol=seagreen]
> Hi Keith,
Access
> This is strange. It should be OK and you should have all relationships as
you designed them in Access.
> I did my self the same procedure several times and it was OK. Not very
complicated databases, indeed, but this shouldn't be an issue.
> A couple of things:
> 1. During the upsizing process did you received any message - error
message or warning?
> 2. Did you checked the MS Access report for the upsing process for any
strange messages?
> One idea would be to delete the SQL Server created database by the
upsizing process and to re-start it again and check for any message during
the process and the report after the process.
> Maybe somebody from MS is monitoring this thread and they can intervine
with an idea.
> Vasile
|||I am trying to upsize my Access DB to SQL, but it always give me error message like "overflow" when 2nd step I was typing login ID and Password
Anyone can help?
Best regards
|||You need to get the Office update... I had same issue and that corrected it.
regards,
Mike
"frank" <anonymous@.discussions.microsoft.com> wrote in message
news:696A44D7-0C71-48D0-A0D4-56CA29BAAD7D@.microsoft.com...
> I am trying to upsize my Access DB to SQL, but it always give me error
message like "overflow" when 2nd step I was typing login ID and Password
> Anyone can help?
> Best regards
>
sql