I need to split my Access 2007 .accdb and place the back-end on SQL Server 2008. I am not able to utilize SSMA due to security reasons. SQL Server resides on a different machine from the Access Database. I tried looking for books or tutorial to no avail to any information is greatly needed.

Can't you export/import your settings through a file (csv/sql)?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.