Question Locked

CONVERTING ACCESS DATABASE TO MSDE VERY NEW TO DATABASE DEAL?

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello all and thank you in advance for the replies and help.. We have a acces database which we are tryng to migrate to MSDE and I do not have the slightest clue on how to deploy this succesfully. I have been reading a lot of white papers regarding MSDE and pretty much grasp a little of it. My question is can any one help me either by pointing me to a post that this has been talked about and resolved with the answers or direct me to a step by step intergration of acces database and msde deployment? What would be the correct way and easy way of doing this and making sure it is doing what we want it to do which is MSDE running the database engine portion of it since the database front end is access that is how they open the databse when we are working on it? There is 10 employees 1 win2k3 EE server domain 10 xp-pro workstations joined to the domain. I have installed MSDE on the server and MSDE is running I also have used the UPSIZE wizard in access to transfer the database to the MSDE DATA folder but i dont know if is properly setup. Have i done this wright already or did i mess up by doing this? How can i VERIFY MSDE is doing all the work? Again thank you in advance for all your help.

Edgar
I.T SPECIALIST NETWORKING

4 replies

by vinnyd

On each computer you need to add an ODBC connection to the MSDE database running on your server.

In Win XP you do that under Administrative Tools in the control panel.

You use the standard SQL and use the server name or the servers IP address.

You may need to run SVRNETCN on the server to make sure that TCP/IP is enabled for access to the MSDE database.

Once a working connection is setup in ODBC you can open Microsoft Access and use Link Tables, Select ODBC sources, use the Machine Source to connect to the MSDE database.

You should now be able to see all the items that you transferred into MSDE now.

by aandecomputers

When i followed your steps on creating a new odbc connection from the client computer in admin tools i get this error: connection failed sql state 'HY000' SQL SERVER '0' [MICROSOFT][ODBC SQL DRIVER]CANNOT GENERATE SSPI CONTEXT..The port number is configured on both serv and wkst correctly and there is communication in both ends also MDAC 2.8 is also installed on the wrkst. what do you recommend? thanks in refrence to your replies very much appreciated

by vinnyd

That error can mean a number of things.

Checkout http://support.microsoft.com/default.aspx/kb/811889 and see if any of the normal troubleshooting steps help.

When installing MSDE there are a number of options about how the SQL server gets configured (using Mixed Mode, SA user password, the Instance, etc)

If you installed an Instance the server name is something like MainServer\sqlServername

Mixed Mode Authentication lets you login using the SA user or as a Domain login.

If your only using Domain login, you likely do not have the correct permissions to the database.

This discussion is closed to new replies.