Dot .. ...... .....

[Haute Route]

Good day. I am new to Access but would like to get a copy of the Sweets.mdb practice files. Are they available to download? Thanks

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[theDBguy]

Hi. Welcome to AWF!

I am not familiar with that.

 

[Uncle Gizmo]

would like to get a copy of the Sweets.mdb practice files

Hi welcome to AWF... I'm not familiar with a sample database called sweets either? You can download many sample databases through your actual Microsoft Access interface, see the beginning of this YouTube:-

VBA Beginner - Setup the Northwind dB - Nifty Access​

And if you want the original Northwind databases, they are available here:-

Northwind Downloads - Nifty Access

Northwind Downloads Microsoft provide some very nice downloadable databases which you can use to get an insight into how Microsoft Access functions. In particular, and I believe it was the first, or at least one of the first examples, "The Northwind Database" is a fine example of an invoicing...

www.niftyaccess.com

both of them, the old one version and the new version...

 

[jdraw]

Welcome to AWF!

Good day. I am new to Access but would like to get a copy of the Sweets.mdb practice files. Are they available to download? Thanks

You may be looking for one of the resource databases that accompany the Function X tutorials.
Here is a link to a zip file of all the support materials.

 

[GPGeorge]

Sometimes Google is your friend, sometimes Bing is better. You might get results from Duck Duck Go, as well. Unfortunately, this is the only reference I turned up with "sweets.mdb" in it. Apparently it really was a thing at some point.

 

[isladogs]

Well that really is obscure...
MSSweets.mdb was an example database included with Access 1.0 back in 1992 - 30 years ago ...

I've just opened it for the first time in Access 1.0 to get that screenshot.
I've attached the file but unless you have Access 95 or earlier, I doubt you will be able to open it.
If you are that desperate for it for some reason, I can probably convert it to a later file format but would have to charge for my time

BTW posting a thread with . as the title made it difficult for me to select

 

[The_Doc_Man]

You dropped a note in my profile on this subject. Sorry, I don't know what that is.

(a) I don't have it or at least don't recognize it.
(b) since it isn't something I wrote, I would only be ethically able to point you to the file and its owner unless there was a "public share" declaration. But since I don't have it in the first place, I don't know its shareable status either.

 

[KitaYama]

Well that really is obscure...
MSSweets.mdb was an example database included with Access 1.0 back in 1992 - 30 years ago ...

I downloaded the file just because I was curious to see if Office 365 opens a 30 years ago file type.
As I had guessed Access refused to open it.

 

[isladogs]

It would need to be converted several times from Access 1.0 to 2.0 to 95 to 97 to 2000 ... all of which would take time.
At that point it would be possible to convert it to ACCDB & in theory run in A365 BUT...
...Access 1.0 had Access Basic rather than VBA so I very much doubt all the code would work

 

[GPGeorge]

Well that really is obscure...
MSSweets.mdb was an example database included with Access 1.0 back in 1992 - 30 years ago ...

View attachment 98033

I've just opened it for the first time in Access 1.0 to get that screenshot.
I've attached the file but unless you have Access 95 or earlier, I doubt you will be able to open it.
If you are that desperate for it for some reason, I can probably convert it to a later file format but would have to charge for my time

BTW posting a thread with . as the title made it difficult for me to select

How on earth did you know to find it there?

 

[isladogs]

How on earth did you know to find it there?

Hi George
I had a distant memory from a thread I wrote a couple of years ago...

A trip down memory lane

Whilst the site was down today, I was going through old files and found a long discarded copy of Access 1.0 from 1992 so decided to install it on a VM as part of my research into system tables. Its on just 6 floppy disks and that includes Northwind and two other sample databases. The basic...

www.access-programmers.co.uk

Helpfully I had included a screenshot with the list of example databases, all of which I still have on a VM just waiting for the day when someone starts a thread like this one.

BTW thanks to whoever renamed this thread to make it easier to select.

 

[oleronesoftwares]

Welcome @Haute Route to the best online forum for Ms Access developers.

 

[Haute Route]

Good Evening Isladogs,
thanks. The Sweets database actually accompanied the Access 2 Step by Step book; it was on only one floppy disk. Files were smaller in those days.... Access did refuse to run, but I have an older version on a retired lap top and will try that.

 

[isladogs]

Hi
The whole of Access 1.0 was on 6 floppy disks plus another 3 disks providing support for SQL Server & around 6 sample databases including Sweets.

IIRC, you will need Access 95 or earlier to open & convert the database.
If that is a problem for you, you can email me using the link below about doing the conversion for you