Access Question

[ampal]

I have a data base that is on our server, a real simple access customer lookup. It can be open from 2 different workstations. It is not opened through Access, it has it's own exe file, but you can open it with Access. Someone told me it was a Access Runtime setup. I would like to copy it to another workstation, but if I just copy the exe it wont work. Can someone give me any ideas about how I can get a copy the user end to another workstation.

Thanks
Mike

 

[dhookom]

Access Run-time is opened through Access. The run-time install limits the features that are available such as not being able to view the database window. You would need to "Install" the run-time version from setup files. I am not aware of any method (legally) of copying just the required files from one computer to another.

Duane
MS Access MVP

 

[ampal]

Thanks Duane,

So if I install Access Runtime on the new machine. Then copy the .EXE file to the new machine it should work. The new machine actualy has Office 2k on it with Access. So because this exe file was created for a runtime it wont work with a full version. Do I need to make sure I have a specific version of runtime?

Thanks again for your help

Mike

 

[dhookom]

Creating a run-time with Access does not create an EXE of your application. Your application stays as either and MDB or MDE (possibly ADP or ADE).

Duane
MS Access MVP

 

[ampal]

Then maybe this exe is a VBA program to look at the MDB. There is a small server that has the MDB file on it. The work stations (2 of them) have an EXE file that they use to look at the database on the server. Does that sound possible?

Thanks
Mike

 

[dhookom]

This could be a Visual Basic or many other applications. If it is an exe then it is not Access.

Duane
MS Access MVP