Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simplicity_theory
Starting Member
1 Post |
 Posted - 2002-09-05 : 02:25:48
|
| I am running MSDE on Windows 2000 and using Access 2000.Im am trying to upsize my Access DB to SQL using the Access Upsize wizard. Trouble is when I go to upsize the end report says that no tables or data has been upsized. I beleive this is because I do not have a login for the MSDE SQL Server. But you can not create edit user login details because MSDE does not come with Enterprise manager. The SA null password account does not work either.Ive been told to use a stored procedure, but how do you do that in Access 2000. All the tutorials I have been reading relate to the setup with Access 2002. Please help me! |
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2002-09-06 : 02:03:45
|
| Have you tried using an adp against your msde? You can add/edit/change sql server logins using a project. Open Database Utilities - Security.You can also change the authentication mode for MSDE. You didn't mention which version of MSDE you're using, here's a link to a KB article describing MSDE2000 auth mode changes. I have changed authentication modes on MSDE 1.0 so there is some similar method for the older version.http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q285097&======Doug G====== |
 |
|
|
|
|
|
Loggin in to SQL MSDE for access db upsizing