Q: Has anyone gotten an Access Application running on a U3 Thumb Drive?

Hi,

I just bought a SanDisk Cruzer 4GB "U3" thumb drive. Is it possible
to run an Access 2003 MDE off of one, complete with data? If so, what
would I have to do to get it to work?

Just curious. No Biggie! I thought I'd take a break from writing
code and try something different. I guess I could go fishing :-)

-paulw

Aug 26 '07 #1

Subscribe Reply

2857

Tony Toews [MVP]

PW <pa************ **********@remo vehotmail.comwr ote:

>I did not realize that these USB Thumb Drives aren't reliable. Looks
like we should tell our clients to not back up to them any longer!

No, they're fine for backup as hard drives are amazingly reliable despite the fact
that they fail. However I would never, ever use a thumb drive as part of my backup
strategy as you need multiple generations of a backup and some of those generations
must be offsite.

Your hard drive fails and so does your thumb drive. Now what? You need to have, in
my opinion at leat three preferably five devices that you cycle through.

The most recent two or three of the generation must be offsite away from your
computer. Theft, fire, etc are the reasons for that.

Me? I burn a DVD every two or three days. With a zipped, passworded backup of my
files.

>>Also ensure that you power off the device using the icon in the Notification area of
the Task Bar before putting your system on standby, hibernating or removing the
device.

I don't think we have any clients that are saavy enough for that Tony!

Then suggest DVD/CDRs.

>Writes to the thumb drives can be delayed by several seconds at least.
I've seen that behavior myself. The Windows Explorer screen indicating it is
copying files has disappeared but the thumb drive light was still on.

Well, I don't think we're going to market this feature :-). What
would I have our clients do anyway? Just use Installation sheild to
install our application to the U3 Thumb Drive? I guess the choice
would be to the thumb drive or the hard drive, but not both?

Don't forget the Access runtime has to be installed on the computer. It's just the
FE/BE MDB/MDEs that can reside on the thumb drive.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Aug 28 '07 #2

Bob Alston

PW wrote:

Hi,

I just bought a SanDisk Cruzer 4GB "U3" thumb drive. Is it possible
to run an Access 2003 MDE off of one, complete with data? If so, what
would I have to do to get it to work?

Just curious. No Biggie! I thought I'd take a break from writing
code and try something different. I guess I could go fishing :-)

-paulw

Should be a short break as it will work just like any other disk drive.
Be careful when removing it to first stop the device via the icon in the
lower right tray. Failing to do so can render the device unusuable - I
know from experience.

Bob

Aug 28 '07 #3

On Tue, 28 Aug 2007 05:31:14 GMT, "Tony Toews [MVP]"
<tt****@teluspl anet.netwrote:

>PW <pa************ **********@remo vehotmail.comwr ote:

>>I did not realize that these USB Thumb Drives aren't reliable. Looks
like we should tell our clients to not back up to them any longer!

No, they're fine for backup as hard drives are amazingly reliable despite the fact
that they fail. However I would never, ever use a thumb drive as part of my backup
strategy as you need multiple generations of a backup and some of those generations
must be offsite.

Your hard drive fails and so does your thumb drive. Now what? You need to have, in
my opinion at leat three preferably five devices that you cycle through.

The most recent two or three of the generation must be offsite away from your
computer. Theft, fire, etc are the reasons for that.

Me? I burn a DVD every two or three days. With a zipped, passworded backup of my
files.

>>>Also ensure that you power off the device using the icon in the Notification area of
the Task Bar before putting your system on standby, hibernating or removing the
device.

I don't think we have any clients that are saavy enough for that Tony!

Then suggest DVD/CDRs.

>>Writes to the thumb drives can be delayed by several seconds at least.
I've seen that behavior myself. The Windows Explorer screen indicating it is
copying files has disappeared but the thumb drive light was still on.

Well, I don't think we're going to market this feature :-). What
would I have our clients do anyway? Just use Installation sheild to
install our application to the U3 Thumb Drive? I guess the choice
would be to the thumb drive or the hard drive, but not both?

Don't forget the Access runtime has to be installed on the computer. It's just the
FE/BE MDB/MDEs that can reside on the thumb drive.

Tony

Thanks again Tony.

-paul

Aug 29 '07 #4

Similar topics

9737

Why can't access a file under mapped network drive from Web Servic

by: moonriver | last post by:

I write a program accessing files in network drive o:. It is doable as a standalone application. However, if it is running under windows service, the following exception will appear: 13/07/2004 10:24:48 AM run() error: System.IO.IOException: The specified network password is not correct. at System.IO.__Error.WinIOError(Int32 errorCode, String str) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare...

.NET Framework

2737

Unable to open / design saved form in Access 2000

by: elieli_132 | last post by:

Hi, My problem is the following: Made changes to code in form and closed the form. Now unable to open / design the form. - Tried copying and pasting - the new one does not open /display. - Tried compacting / repairing but same situation.

Microsoft Access / VBA

3696

Architectures for multi-user access database

by: premmehrotra | last post by:

I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops. Following problems occur: 1. Access is way too slow in WAN environment. Server is located in New Jersey and users are in California and Puerto Rico. 2. Database often becomes corrupt 3. When one user updates some data in the database, other users...

Microsoft Access / VBA

3220

Access Scalability - records vs. filesize

by: deko | last post by:

Do I get more scalability if I split my database? The way I calculate things now, I'll be lucky to get 100,000 records in my Access 2003 mdb. Here some math: Max mdb/mde size = 2000 x 1024 = 2,048,000k Let's say on average each record in the database consumes 15k 2,048,000/15 = 136,533 records

Microsoft Access / VBA

9758

VB.Net file access problem with UNC

by: Sarah | last post by:

I need to access some data on a server. I can access it directly using UNC (i.e. \\ComputerName\ShareName\Path\FileName) or using a mapped network drive resource (S:\Path\FileName). Here is my problem: my vb.net program has problems with UNC. If the UNC server is restarted or goes off-line, my VB.net program crashes. The code for UNC access to the file is included below and is put in the tick event of a form timer control running every...

Visual Basic .NET

12201

Raw disk access

by: Daniel Rudy | last post by:

How does one access the raw disk? I have a USB thumb drive that will have many megabytes of data on it. What I want to do is access the device raw and do reading from/writing to the usb device itself. No partitions, no mounting, just raw disk access to data in predefined structures that is on the device. I have looked at Advanced Unix Programming (ISBN 0-13-141154-3) by Marc J. Rochkind and it does mention a few things about it, but I...

C / C++

3746

Trigger/Event when a usb thumb drive is inserted? (vista)

by: kilik3000 | last post by:

Is there a way to catch an event/trigger that *might* be fired when a usb thumb drive is inserted into a Vista PC? The reason I ask is that I'd like to catch that event and back up the content of the thumb drive to the local machine with a custom process. I realize there might be some security issues with this...but it would sure be useful if I could do it. -Thx

C# / C Sharp

4494

Access 2003 v/s Access 2007

by: prakashwadhwani | last post by:

Hi !! I'm about to develop a new project for a client. Should I go about it in Access 2003 or 2007 ? Purchasing it either for me or for my client is not a major consideration here ... what I'd like to know is the stability, speed & ease of use of both the products. I believe Access 2007 has a new file format too and that it may be slower.

Microsoft Access / VBA

2266

Copying a whole thumb drive in VB

by: skygremlin | last post by:

I am trying to write a simple VB app to copy all directories and files off a thumb drive to a directory on a pc. I have a couple things I am trying to automate. Final Build will: - Have multiple USB connections for multiple drives to copy from at the same time - Have seperate directories for each individual who will copy to the pc - Have a list box where I would like to choose which directory (Individual) to copy files to, and a...

.NET Framework

8944

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9306

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9234

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9180

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6733

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6030

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4805

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3259

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2721

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP