Search results

UPDATE: I have resolved this issue after using solution found here: https://stackoverflow.com/questions/41031457/extracting-offline-mac-address

Hi When building systems I like to secure it with a license so it can't be grabbed by anyone other than the client it was intended for. To this end I invented a MAC address checking method which only allows pre-approved machines to run the system otherwise it will automatically close down...

Hi I am having trouble with a query in SQL Server. I am trying to locate the records created on today's date. I have a field which logs the date it is created but whichever way I try, the results are always blank. It does sometimes works in MS Access. Here is the SQL of my query: SELECT...

It may help to copy and paste the file so it is in a location where MS Access trusts?

Yes this is the actual error occurring - it just pops up repeatedly with no other option than to force system to close. It most often happens after distribution although on occasion I find it in the Master FE. @Pat Hartman I use a very similar method to distribute my FE to users when an update...

I see. Well this is not the case as all users are connecting via cable.

It is generally the users versions being corrupted during regular use. The users are not using the master FE as I can see there is no locking file. I am unsure what you mean by connecting wirelessly - all users are on the same LAN?

What would you suggest?

No it is only one file that is having changes to it and primarily by myself - if there are other developers involved they would also log in to the same machine and work on the same file. (which ultimately will be the master version of the next version distributed to users)

The master version is under development so it seems to corrupt every now and then.

We are doing exactly that - there is one master version which is copied to each user and the FE is linked to the SQL server tables using ODBC connection - is this not correct?

Hi We often encounter this issue on a database which is under development and being used by end users. In short it becomes corrupt and can no longer work - the only way to resolve is to do a complete rebuild of the system ie copy all objects into a new database project and re-link the tables to...

Hi I'm looking to write a query in SQL server (which I am converting to PT for Ms Access). It should be returning all records which were created this week ie since Monday. I have searched for the best way to do this but have not found a satisfactory solution. Any ideas please?

So what data type should I use when I set it up now in MS Access (before migrating)?

Hi I'm building a database which will be migrated to Azure. The client would ideally like an image of each item on record. However when I checked up how compatible this would be I found the Attachment field type is not supported by Azure. Are there any other other options I could try?

I am attempting a simple export to RTF format from the print preview of a report (there is no code in the report) but it keeps bringing up a syntax error. What is going wrong here?

Hi I'm at my wits end with an issue I'm having with subform. Hope someone can shed light on this please. I have been trying to add a subform to a main form which has a PT query as its recordsource and got an error. I've done research and found the reason why it happens here...

If I create a query of last invoice for all students, then query against it to filter out only those more than a month, append to create new invoice entries. Invoice date would be lastDate + 1 month. Are my thoughts on the right lines? I'm concerned that the end date for pupil may mean an...

Hi Can someone help me with creating an append query to create invoices once a month if child is registered. It will run when main screen opens but user may not open DB every day so how to i program it to check if last invoice was 30 days ago and create new record? I would also like to do a...

It should not have affected it but maybe check that all the relevant fields exist in the query. What is your back end?