Recent content by pgraju

Hi all! I have been working on a relational database and have been putting it together as an ER diagram which I have attached (it has no relationships at the moment). Here are how the tables are related: Each Diary (diaries) has many Questions (questions) Each Question (questions) has many...

*Bump* Can anyone help with this?

Hi All I need to schedule the opening of a MS Access database which is password protected. I think the best way to do this would be to use schedule a batch process to run, can anyone help with the script to create a batch proccess to only OPEN and CLOSE an MS Access database? Thanks

RoyVidar, That didn't work either I still got the error message. *** Would anyone know a way of storing a queries results into a table on a scheduled basis?

Guus, After storing the SQL query into a new query it still ran fine. The only problem is when I try to import it into Excel using Microsoft Query... Could there be another reason for this?

Database Design... Hi andy, It might be a good idea to reconsider how you are setting up your tables, rather than have all the information about a customer/employee/person in one field, why not try and split it up. So for example. Example Table Person_Id Person_Name Person_Address...

Hi all, I seem to be getting this error when I try to import a query from MS Access to Excel: Now, it runs fine in Access and seems to be a Microsoft Query problem, I know there are some issues around the performance and capability of Microsoft Query but hopefully someone can have a look at my...

Another way... Hi, This is how I would go about it (PM me if you would like a copy of a sample mdb). 1. Make sure you have formatted your dates to dd-mmmm-yyyy in the design view of the table which contains your date. 2. The query below will display a count of the month driven by the user...