And I did that... I went into the front end DB clicked on the linked table manager and chose the Backend again. When I did that it said it could...

All my Backend tables were renamed with SSMA$...... and then the same table name is showing with a world with an arrow? How do I link them back to the...

If I am the Database owner.... wouldn't creating the schema with an authorization of db_owner get the same result?

I finally got it to work... thx for all your help guys...

Yeah... I'm pretty sure.... As a matter of fact this example database that I am creating comes from a book I am going through (Beginning SQL Server 2008 for Developers:...

OK... for some reason I am drawing a complete blank.... How do I check the permissions for the account that is running the instance of SQL Server?

I have admin rights and I have verified and re-verified the file path is correct but still dont understand why I would get this error.

SSMA- SQL Server Migration Assistant.

Yeah I tried using the Access wizard but kept getting an error message saying: The upsizing wizard does not work with the version of Microsoft SQL Server to which your...

Thank you for the link to posting data. I will make sure to use it in the future. I guess I will head to an access forum and see if...

Well.... I have four fields called Stack ID, Location, Move Date, and Move Time.

The Stack ID refers to a bundle of wood and in that column we have multiple stack...

Let me ask this:

In order to use the distinct keyword, would I need to select every field I am getting information from?

I am writing SQL in a query in ACCESS...

The query currently pulls information from the selected fields and I want to be able to keep doing that but also eliminate duplicate info.

So in migrating the back-end I would technically only be migrating one back-end with all 3 applications accessing it on the SQL server instead of the Access Db right?

Actually I am still working on understanding how to move over to SQL Server from access. I want to move the tables and leave the forms and reports as access.......