Access 2007...

[SteveF]

I'm getting old too It's been a while but I found brilliant help here when developing my work database so...

I have a couple of databases developed in Access 2007. They've been working fine for years but my computers are starting to expire now and the databases are less happy running on the new PC. I have a new laptop running Windows 11 and the databases give me a 'runtime error' now.

Is Access 2007 dead/incompatible with Windows 11?

I have a legit boxed copy of A2007 within Office Pro 2007 on a dusty old boxed disc but am assuming this is dead as well. If so then what are my options for running and working on databases?

I have a small membership database that uses barcodes to scan customer entry/sign in that I would like to do some work on. Is that going to be something that I can't do because of the age of the original database or do they last forever like I want them to?

Thanks for help, as ever.

 

[Gasman]

No. I have 2007 on a Win11 24H2 and it runs fine.
I have 2019 on this laptop. Groupon is constantly sending me emails for discounted Office.

I only upgraded as I could not open a lot of the DBs posted here, so was limited in what I could help with. 2007 was fine for my purposes.
Outlook was a major change from 2007 to 2019, but Access pretty much the same.

Why not say what the error is?

 

[SteveF]

No. I have 2007 on a Win11 24H2 and it runs fine.
I have 2019 on this laptop. Groupon is constantly sending me emails for discounted Office.

I only upgraded as I could not open a lot of the DBs posted here, so was limited in what I could help with. 2007 was fine for my purposes.
Outlook was a major change from 2007 to 2019, but Access pretty much the same.

Why not say what the error is?

The error is what I said originally, it just says 'runtime error'. I was just guessing at compatibility because of the age, 2007 is a long long time ago in computering world

 

[Gasman]

Are you able to run the source accdb or mdb?

 

[SteveF]

Are you able to run the source accdb or mdb?

No, I don't have access on this laptop. If 2007 is compatible though I may be able to start there

 

[Gasman]

I suspect an error with code or data if using a accde/mde and error not recognised?

 

[Gasman]

I can test for you, if it is not confidential?

 

[SteveF]

I can test for you, if it is not confidential?

That would be really helpful, thanks. I'll get a copy posted

 

[Gasman]

That would be really helpful, thanks. I'll get a copy posted

You can PM it if you prefer?

 

[gemma-the-husky]

Is your new install of Access the same bitness as the old one? Changing from 32bit to 64bit inadvertently might cause an issue. 32bit used to be the default install, but now it's 64bit. You would most likely get error messages, but you never know.

What error are you getting? Does it crash access, or is it reporting the issue?

 

[SteveF]

That would be really helpful, thanks. I'll get a copy posted

This is the database. All it was designed to do is recorded customer entry in a members' club, the customer just scanned a key tag and the DB recorded their entry. It helped us fulfil a licensing requirement.

I'm wondering now if we could use it for the basis of a loyalty scheme for a bar. The customer would scan at each purchase and each purchase would generate 'points' that would accumulate and which they could then spend at the bar as a cash/discount amount.

My DB skills are somewhere in the basic/non-existent kind of region but I've always tried to apply logic to these problems and that kind of works.

If the database is running fine then I can have a look at the next step.

Thanks all for help

 

[Gasman]

That is the FE?
Now for the BE.

You should have Option Explicit in every module?
You need to add it to the two forms. They still compile.
To have it automatically from now on, go into Tools/Options in the VBA editor and select Require Variable Declaration

 

[bob fitz]

This is the database. All it was designed to do is recorded customer entry in a members' club, the customer just scanned a key tag and the DB recorded their entry. It helped us fulfil a licensing requirement.

I'm wondering now if we could use it for the basis of a loyalty scheme for a bar. The customer would scan at each purchase and each purchase would generate 'points' that would accumulate and which they could then spend at the bar as a cash/discount amount.

My DB skills are somewhere in the basic/non-existent kind of region but I've always tried to apply logic to these problems and that kind of works.

If the database is running fine then I can have a look at the next step.

Thanks all for help

It would be helpful if you could also post the backend database file.

 

[SteveF]

Is your new install of Access the same bitness as the old one? Changing from 32bit to 64bit inadvertently might cause an issue. 32bit used to be the default install, but now it's 64bit. You would most likely get error messages, but you never know.

What error are you getting? Does it crash access, or is it reporting the issue?

Hi Dave, been a while

I haven't installed Access on this one. I was curious about compatibility but it seems like compatibility isn't an issue. I'll see if I can get it installed, it's a legit copy albeit a bit old

 

[Gasman]

Why are the linked tables not showing up in the LTM?

 

[SteveF]

It would be helpful if you could also post the backend database file.

Ahem, apologies...

 

[Gasman]

Whilst there is not a lot I can do, I managed to add myself.
Reports seem OK, if empty.?
Added a clock in and that also works.

 

[SteveF]

Whilst there is not a lot I can do, I managede to add myself.
Reports seem OK, if empty.?

There's honestly not much to see, it does very little other than record the date/time of the scan.

I think my initial questions are answered. The database itself is still functioning correctly and there's no reason why I can't get Access 2007 to run on this computer.

I'll figure out the install via an external disc drive somehow and go from there.

I think this is a good starting point for the loyalty scheme I'm thinking about, thanks for reassurances

 

[Gasman]

I would say that I ran it on this laptop with 2019, but can transfer it to the server if you must have it tested with 2007, but I see no issues with it.

 

[SteveF]

I just think it must have been written with 2007 so that's my starting point. Thanks for looking, much appreciated