Macro trouble in an mde

[Fozzie22]

Hi everybody,

I have created some macro's to set some fields and then perform a process. There are 5 macros in total and depending on which shortcut is executed will call a different macro using the command line parameters /x macro

They all run fine in an mdb file but when I convert it to an mde file I get an error msg saying that that command isnt available in an mde/ade database.

When I run the macro in the mdb file is seems to want to step through it and not just run it. I have attached my macro below all 5 are the same except for the source name and client_ldb is different.

'Macro to open LogiDB
Public Sub OpenLogiDB()
Source = "N:\Logitech Database\LogiDB.mde"
Destination = "C:\LogiDB\LogiDB.mde"
Client_ldb = "C:\LogiDB\LogiDB.ldb"
sSourceTable = "tbDBaseDetails"
sRevTableName = "DBaseRevision"
PerformUpdate
End Sub

Any ideas why my macro's wont run in the mde

Thanks

Fozzie

 

[Fozzie22]

Its all good I fixed it. I was trying to open a module using the macro but I changed it to a run code and ran the function. It works a treat now

Thanks Anyway for you help on other matters

Fozzie