Make MDE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a database that opens and updates a load of tables (imports append queries etc) every morning

This is the master database. There is an mde database that all the users use

Is there a way that I can delete the mde file after upload, copy the master db as the new mde file - all through code

Ideally I would need to compact the databse first, and I have an idea that there may be problems if users are currently logged on to the mde database

Can anyone advise?

Thank you

Tim
 
Hi Tim,

Here's an article that can get you started with kicking users out of
database
How to Shut Down a Custom Access Application Remotely
http://support.microsoft.com/default.aspx?scid=kb;en-us;304408

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."



--------------------
| Thread-Topic: Make MDE
| thread-index: AcQBRrXL6kR9XazGQd2n0hGQ+DMMAg==
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
| From: =?Utf-8?B?VGlt?= <[email protected]>
| Subject: Make MDE
| Date: Wed, 3 Mar 2004 09:41:08 -0800
| Lines: 15
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.modulesdaovba
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.modulesdaovba:125791
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| Hi,

I have a database that opens and updates a load of tables (imports append
queries etc) every morning.

This is the master database. There is an mde database that all the users
use.

Is there a way that I can delete the mde file after upload, copy the master
db as the new mde file - all through code?

Ideally I would need to compact the databse first, and I have an idea that
there may be problems if users are currently logged on to the mde database.

Can anyone advise??

Thank you,

Tim
|
 
Back
Top