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.

All Forums  General SQL Server Forums  New to SQL Server Programming  Upsizing Access mdb to MS SQL server 2005

Author  Topic  writer Starting Member 2 Posts Posted - 2009-03-25 : 20:42:01 Hi, I am a newbie with ability to install 1 or 2 SQL Server 2005 databases on a shared web hosting site I have (hosting provider: Godaddy, Windows server hosting). I have not yet set these up, because I want to figure out first if I can use them with upsized mdb files. Access 2007 has an upsizing wizard which appears able to convert mdb files for the SQL Server 2005 databases. There are help files for the Access 2007 upsizing wizard, plus some help files at GoDaddy for the SQL Server DB: how to identify name, password, connection paths. One of the issues I will need to figure out is how to make sure that permissions are set in the SQL DB for writing, etc. Otherwise, data will not be written, read from, updated. Uploaded web site files that will use the DB's are scripted to connect(I can re-configure the path), write, read and update. I basically need to get the Access files converted and imported into the SQL Server. A basic question: if I have 2 mdb files, will I need 2 SQL Server DB? The mdb files are used separately by the other uploaded files, so I'm guessing that I will need to set up 2 separate SQL Server Databases, one for each mdb that is upsized/converted. With no DB knowledge or DB skills, I would also appreciate feedback as to whether what I want to do can be done with the available tools (upsizing wizard in Access, an SQL Server 2005 DB or 2?). Suggestions are welcome. Kind Regards, writer