I was recently looking for some assistance on this issue from my hosting company but they informed me that they can not help me with this problem. I am forwarding my initial question to them on here in hopes that maybe one of you can help me with this very frustrating problem. Any help on this matter would be great. Thanks a lot in advance.
Hello,
I am the web master for doglegdiscs.com and I have a question about databases. I will preface my question with this; I am fairly new at web design, so please bear with me on my questions. My question/issue is this; I have uploaded the entire site to the server but am having problems with the Access Databases contained with in the site. Let me first say that everything works great on my iis server. However, once uploaded to the server, I am unable to write to the database. I can view everything in the database but if I try to update the database, I receive this error:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/gb/gb_add.asp, line 115
I have investigated this error and have done everything in my power to rectify this, but to no avail. The database directory has the correct permissions set and I also uploaded the databases into the db_access folder on the server. Do I need to upload the entire folder into that directory or just the databases? Could you please give me a step by step on how to set up access databases? I must inform you that I have set up the connections to be dsnless. If you could please help me with these issues I would highly appreciate it. It is driving me crazy trying to figure this one out and not to mention portraying me as an inexperienced web designer. I thank you in advance for any solutions you can give me. Thank you very much for your time.
Hello,
I am the web master for doglegdiscs.com and I have a question about databases. I will preface my question with this; I am fairly new at web design, so please bear with me on my questions. My question/issue is this; I have uploaded the entire site to the server but am having problems with the Access Databases contained with in the site. Let me first say that everything works great on my iis server. However, once uploaded to the server, I am unable to write to the database. I can view everything in the database but if I try to update the database, I receive this error:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/gb/gb_add.asp, line 115
I have investigated this error and have done everything in my power to rectify this, but to no avail. The database directory has the correct permissions set and I also uploaded the databases into the db_access folder on the server. Do I need to upload the entire folder into that directory or just the databases? Could you please give me a step by step on how to set up access databases? I must inform you that I have set up the connections to be dsnless. If you could please help me with these issues I would highly appreciate it. It is driving me crazy trying to figure this one out and not to mention portraying me as an inexperienced web designer. I thank you in advance for any solutions you can give me. Thank you very much for your time.