64 Bit Machines

[DruidAllanon]

I'm having trouble getting a runtime version of access to open a database that has scripts in it. The database opens and runs fine on 32 bit versions of Windows XP, but not on 64 bit versions of Windows XP. Runs fine on Windows 7 64 Bit as well. When the database opens, a script runs to determine the username of the person logged in and then logs them into the database. Basically, it checks to make sure the user logged in has access to the database, then opens the main form.

Any ideas?

 

[Banana]

If it's running fine on 64-bit Win7 but not on 64-bit XP then it can't be bitness that's the problem but rather something to do with Win XP.

What is the script language? VBScript? Batch? PowerShell? Is it even installed on the Win XP 64-bit?

 

[DruidAllanon]

It's all in VBA... I think it might have to do with the structure of Win XP 64 Bit... it's notoriously unstable...

 

[SpentGeezer]

As you are running on multiple environments, scrap the script and use a password protection instead

 

[DruidAllanon]

Unfortunately, I'm not a programmer (or DBA for that matter), I'm an engineer and I'm learning a lot of this stuff as I go. I don't really know what you mean by multiple environments. Also, there are a lot of scripts that I have embedded that make the database functional. So it's not just this script that's the problem...