Error While Create Tables using SQL file in microsoft access

[R.V.]

Hi,

I am doing exercise 10.1 of TestStand manual. I have created DSN & database file in microsoft access database. but while creating the table using the sql file (Access Create Generic Recordset Result Tables.sql), I am getting error & not able to create the table.  

I have attached snapshot of error in ErrorPic.docx file. Any suggestion will be helpful for me.

[Corey.Rotunno]

Hi,

I see in the error message that it is a read only database, so that's a problem.

[R.V.]

Hi Corey Rotunno,

I saw that it is showing that the database is read only. I am using this database after reading the steps given in the manual. 

this point is strange for me that the database is showing read only even I have followed the same steps given in the solution of exercise.

I think I am doing something wrong while creating the database or there is something else. 

[Corey.Rotunno]

Have you tried checking the file properties in Windows Explorer? Depending on where you created the file Windows may have enabled the read-only check box automatically. If you un-check that I suspect you may good to go. If that's the problem, that is.

[R.V.]

Hi Corey Rotunno,

Yes, you are correct. I tried that option & after that I was able to perform the sql commands. Now I am trying further exercises on database.

Thanks for the help. 🙂

[Corey.Rotunno]

Good to hear. Not sure why Windows does this. It's gotten me more than once.

FYI - If a post solves your issue mark it as an accepted solution by going to options>Accept as Solution or I think there might also be a big button next to "reply". This way other people know the issue has been resolved without reading through the thread. It also bumps the reputation of the forum member who posted the solution.