create accde from command line

Question

Hi!

We would like to create the accde from command line on our build server.

Pre Access 2016 version worked fine [for us] with SysCmd 603 but the Access 2016 version shows the error "Illegal function call"

(800A1F10). 

Any solutions to this? Does it work for anyone else?

Regards,

David

Answer 1

I can successfully run SysCmd 603 in Access 2016. The error "illegal function call" sometimes occurs if there is a corruption in the database. You should create a new empty database and import all objects from the database that contains the SysCmd 603 and then try again.

Matthias Kläy, Kläy Computing AG

Answer 2

Hi!

This one worked out - the app.SysCmd takes strings. We used variables = variants. Go figure...

source = "sdfsdf.accdb"

target = "sdfsdf.accde"

app.SysCmd 603, source,target 'Dont work!

---- changed to ---

app.SysCmd 603, Cstr(source),Cstr(target)   'Worked out fine