Update Front End FILE

[smtazulislam]

Hello,
I have a master copy (.accdb) where some form already updated and further need to update day by day. I would like to update the user file FE by (.accde file) by a BUTTON click, that TODAY update files can work the user. So, how can I create .accde file from .accdb file automatically. This database work with 5 Computers.

Any help will appreciate...

 

[theDBguy]

I suggest you just create the accde manually and just make copies of it.

 

[smtazulislam]

I suggest you just create the accde manually and just make copies of it.

last six months I do that. But lazy to do same work again and again...

 

[oleronesoftwares]

Using Sys Cmd to Create an ACCDE - Access 2007 VBA - Engram9 VBA

More savvy Access developers may recall the undocumented SysCmd option 603, which, in previous versions of Access, creates an MDE from an MDB file. Although

www.engram9.info

Read the article in the link, it might be useful

 

[AngelSpeaks]

How are you distributing the FE? This is probably what you need to work on. There are two common methods.
1. Shortcut that runs a batch file to download and open the FE
2. Shortcut that runs a load .accdb/.accde that checks the version and downloads a new version as necessary and then opens the FE and closes itself

Once the shortcuts are distributed, all you need to do is to replace the "master" FE on the server and the next time the user opens the app, he gets the updated version.

Pat, could you please tell me where I can find the version? Also, user's copy of Access is on Citrix server and when I tried to create a short cut to run it, it couldn't find Access. User's IT guy said Access had to be launched on Citrix and database opened from there.

What I would like to setup is a batch file to copy a fresh FE (to resolve my FE bloat issue) and then launch the FE.

 

[AngelSpeaks]

Thanks Pat. Your explanation of version is what I was asking. In VB.Net they have a version property. I thought Access might have the same thing.

 

[AngelSpeaks]

When I searched Access version, the only hits were for the versions of Access and not the databases.