question

GretchenRosenberg-9826 avatar image
0 Votes"
GretchenRosenberg-9826 asked AlexanderIvanov-MSFT commented

SSMA for Access console issues

I'm trying to use the latest release of SSMA (v8.18) console and am running into a problem with Access database names that contain spaces. This goes in the Variable Values file for the variable AccessDatabase. I am getting a FATALERR that it cannot parse the name. I have tried [] around the name and just got a different error saying the Access database was not found. Is there a workaround? I found this post ssma-for-access-console-issues but the proposed answer from 2 years ago says to use the current version. Any help out there?


sql-server-migration-assistant
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thought I should clarify...the variable AccessDatabase is used in the script command: <load-access-database database-file="$AccessDatabase$"/>

0 Votes 0 ·

Hello,

It would help if you share what the value of $AccessDatabase$ variable is and what error you are getting.

I just did a quick test and command

<load-access-database database-file="$AccessDatabase$" />

with variable set as

<variable name="$AccessDatabase$" value="C:\Temp\Test Database.accdb" />

works as expected.

It is unclear where you would add [], as database-file expects the path to the database file and your filename either has [] or it doesn't.

Regards,
Alex.

0 Votes 0 ·

0 Answers