0
votes
1answer
82 views

SQL Server Migration Assistant for Access and password protected source

Does anyone know if it is possible to have the SQL Server Migration Assistant for Access read from a password protected Access database? The wizard offers no option to provide a password. I tried to ...
0
votes
0answers
375 views

SQL Server OPENROWSET/OPENQUERY Issue with Access DB

Server: Win Server 2003 R2 standard x64 MSSQL: Server 2005 Standard x64 Using SSMS on the database server itself I can execute a simple select on a linked server with OPENQUERY and I can also execute ...
1
vote
2answers
347 views

High Transaction System Recommendations [closed]

I am a SQL Server database administrator and developer and I also have many years experience as an application developer. I currently have a customer with a very big project who is looking to me for ...
1
vote
1answer
3k views

How to import Access 2007 to SQL Server through Import Wizard?

Is there a way to get around this problem? (through GUI) Currently SQL Server 2005/2008 do not allow me to import Access 2007 database as shown below
1
vote
1answer
374 views

linked-server sql - access

I have a SQL server 2000 and an Access database mdb connected by Linked server on the other hand I have a program in c # that updates data in a SQL table (Users) based data base access. When running ...