Access 2007... (3 Viewers)

[gemma-the-husky]

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

You mean you are getting errors on your old PC then? Has anything changed?

 

[The_Doc_Man]

Getting a "runtime error" is sort of a no-symptom symptom. Usually there is a specific number or text associated with the Runtime Error. Knowing the error number and/or text (in full) might give us a hint.

 

[SteveF]

You mean you are getting errors on your old PC then? Has anything changed?

It's errors on the new one which led me to think there might be compatibility issues.

The old PC refused to boot in the end. I have a few databases that ran quite happily on the old machine but not so much on the new one.

I've ordered sn external drive, see if I can get this copy of Access loaded and take it from there. That seems to be the starting point.

 

[Gasman]

It's errors on the new one which led me to think there might be compatibility issues.

The old PC refused to boot in the end. I have a few databases that ran quite happily on the old machine but not so much on the new one.

I've ordered sn external drive, see if I can get this copy of Access loaded and take it from there. That seems to be the starting point.

Don't you have a friend that would just copy the CD to a USB stick for you?

 

[SteveF]

Don't you have a friend that would just copy the CD to a USB stick for you?

Hadn't thought that might work, I assumed it would need the original discs. I'm not brilliant with this stuff

 

[gemma-the-husky]

It's errors on the new one which led me to think there might be compatibility issues.

The old PC refused to boot in the end. I have a few databases that ran quite happily on the old machine but not so much on the new one.

I've ordered sn external drive, see if I can get this copy of Access loaded and take it from there. That seems to be the starting point.

But didn't you say you don't have Access installed on the new PC. (#14) How can you be running an access database?

 

[SteveF]

But didn't you say you don't have Access installed on the new PC. (#14) How can you be running an access database?

Runtime on the new one, that sort of installed itself when I transferred my invoicing package across

 

[gemma-the-husky]

Runtime on the new one, that sort of installed itself when I transferred my invoicing package across

Well runtime will crash instantly on any unhandled error.

If you were getting errors on your old machine that you could recover from, you will not get that opportunity to resolve the problem with run time.

You are OK running well tested apps on run time, but you still really need a development machine available.

 

[Isaac]

Agree with the last post. Runtime apps will crash the app and sometimes give very vague error messages. Your only reasonable way forward is to debug the error using the full version of Access, it's that simple.

 

[SteveF]

Agree with the last post. Runtime apps will crash the app and sometimes give very vague error messages. Your only reasonable way forward is to debug the error using the full version of Access, it's that simple.

Installed access today and the database is running quite happily now so that's the first part of my question very much sorted. I'll have a look at the database over the weekend but am very hopeful that it can be modified to work as I want it to.

Excellent progress.

 

[SteveF]

My idea is that the customer scans a key tag which carries a barcode each time they make a purchase. The database was just designed to collect entry data, as in when the customer entered the bar. I think it should be simple enough to add another field to that table to collect a value amount, like 30p or 10%, and then we should be able to query/report that amount as it cumulates and redeem it periodically as and when the customer wants to spend it.

I'll copy everything first so my ham fistedness can't do any harm and start having a look.

 

[The_Doc_Man]

I'll copy everything first so my ham fistedness can't do any harm and start having a look.

EXCELLENT decision. Whenever you are about to do anything major, ALWAYS ALWAYS ALWAYS have a backup copy. When I was working for the U.S. Navy as a contractor, we ran daily backups, even weekends, since the systems were automated and transferred bulk data during slack hours - like weekends. Backups are the key to retaining your sanity. And restoring a database is maybe a hundred or maybe a thousand times faster than rebuilding a database by replaying transactions.

 

[Gasman]

My idea is that the customer scans a key tag which carries a barcode each time they make a purchase. The database was just designed to collect entry data, as in when the customer entered the bar. I think it should be simple enough to add another field to that table to collect a value amount, like 30p or 10%, and then we should be able to query/report that amount as it cumulates and redeem it periodically as and when the customer wants to spend it.

I'll copy everything first so my ham fistedness can't do any harm and start having a look.

So what happens when I buy a pint?