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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-09 : 09:00:15
|
| Tim writes "HI SQLTeamI am trying to upsize my current access db to a sql db but I am experiancing problems.Firstly I am running MSDE on Windows 2000. My version of Access is now 2000 SR-1 with Access SQL Server readiness updated patch.Now when I go to upsize my db in the end report all it says is that none of the tables or data has been upsized. I beleive this is because I do not have a proper login for my SQL server. MSDE does not have the Enterprise Manager installed with it so you cant do it that way, how do you create a new login through stored procedures for SQL Server so that I can upsize my database? (Remember Im on Access 2000 all the tutorials I have found regarding this topic use Access 2002 which must have a lot of new SQL features compared with 2000.Ive also tried the sa null password account but that does not work either.Any help would be great, this has been a total nightmare for me!" |
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2002-09-09 : 17:55:21
|
| Open a new access data project, and use the SQL OLEDB provider to connect to your SQL Server database. You will get a connection builder screen when you create the new project.Then go to Database Tools - Security and add or edit SQL Server users.======Doug G====== |
 |
|
|
|
|
|
Loggin into MSDE SQL Server using Access 2000