Error Accessing MSAccess database on network drive




On a network drive accessed by all users,I have created a directory with all security permissions to . Copied the MSAccess database to this directory and granted full control to Everyone.


From a personal web server on my machine , I am trying to access a MSAccess database on a network drive and get the following error.

I also created a folder on my C: drive.
When I change the database path/namt to clannedactivitypact.mdb everything works fine.
But when I try to access the database on the network drive, I get the following error

Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'gperationssupportplannedactivitypact.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/html/html/Jon/jon_entry.asp, line 79


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)

Page:
GET /html/html/Jon/jon_entry.asp



Would appreciate some help with this
Posted On: Tuesday 20th of November 2012 04:28:07 AM Total Views:  371
View Complete with Replies

RELATED TOPICS OF Microsoft SQL Server PROGRAMMING LANGUAGE




How do you create an upload on a form so that the file gets sent to the database?

, I have a form written in JScript and ASP and I need to create an upload area for files of any type, ...etc. The data in the form currently gets sent to a SQL database. How does the uploaded file get to the sql database I read somewhere that the field type is "image" The other challenge is that an email gets sent to a person with a link to view the web based form with all the data. But how is this person going to view the uploaded file Ideally I'd like for them to receive the file as an attachment. Is this possible Please help! Thank you, Barnes
VIEWS ON THIS POST

410

Posted on:

Tuesday 20th November 2012
View Replies!

Script to insert 1000 rows in a database table

Please guide me as to how to write a script to insert 1000 rows in a table automatically for SQL Server. the table has structure like Table1(id int,name varchar, date datetime,currency money) Thanx in advance.
VIEWS ON THIS POST

238

Posted on:

Tuesday 20th November 2012
View Replies!

Help with my connection to SQL Security database!!!

I am trying to connect to the Security table to authenticate users. It works well on my box when Im logged in but it isnt working when I have another user try to connect or when I try to connect remotely. I get a SQL error on the aspx page (System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON') but I have already removed the anonymous login for IIS and I have the connection string set to SSPI (.ConnectionString = "data source=servername;initial catalog=Security;Connection TimeOut=30;integrated security=SSPI)with the web.configs identity set to impersonate=true />. Do you have any other ideas or do you know of another way I can authenticate users and get a return value\t\t
VIEWS ON THIS POST

315

Posted on:

Tuesday 20th November 2012
View Replies!

SQL Server registration errors (NEWBIE)

Odd problem - I'm running SQL 7 (client install) and cannot connect to the server, but only from my machine. From any other machine on the LAN that I've tried (after installing the client and adding my domain acct to the machine) I get in fine. I cannot connect using ISQL either. Any ideas I'm really hoping to avoid a machine reformat.
VIEWS ON THIS POST

256

Posted on:

Tuesday 20th November 2012
View Replies!

SQL server remote connection error

I am getting this error when I execute a query on a remote server. [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData (CheckforData()). [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation. Connection Broken This only happens when my query is run between these dates '5/1/2003' '5/30/2003' The query returs an extended cost- I have checked the totals for that quarter is over 1900000.00 If I run for the first quarter of this year the total is just under 1800000.00 and it executes fine. here is my query SELECT TOP 15 t.description, Amount = CASE WHEN t.Extcost_priceUSD IS NULL THEN 0 ELSE t.Extcost_priceUSD END FROM ( SELECT DISTINCT a.description, (SELECT sum(d.Extcost_priceUSD) FROM POS_DataTable d WHERE d.description = a.description AND d.ship_date >= '5/1/2003' AND d.ship_date = '5/1/2003' AND ship_date
VIEWS ON THIS POST

285

Posted on:

Tuesday 20th November 2012
View Replies!

The "undefined error"-problem

hi! i wonder why I sometimes get a message saying "undefined error on line X". The SAME script can work several times before this error turns in, but when it well has turned in there's no return.... it'll stay there.... Now my question is WHY do I get this message..The error ALWAYS occour at the line WHERE this code is written:RecSet.Open SQL, Connect, adOpenStatic, adLockOptimistic
VIEWS ON THIS POST

137

Posted on:

Wednesday 21st November 2012
View Replies!

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

I am trying to update a table but unfortunately i see the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '('. /Sales/RS/rs_display_po_am.asp, line 192 from the code below. Not sure why it is playing up Sub ScomInsertSOCust(psinvadd, psdeladd, psackadd) set comInsertSOCust = Server.CreateObject("ADODB.Command") comInsertSOCust.ActiveConnection = MM_conn_to_EFACs_STRING_ap comInsertSOCust.CommandText = "UPDATE dbo.salesorders (scustadd, sdeladd, sackadd) VALUES ('"& psinvadd &"', '"& psdeladd &"', '"& psackadd &"')" comInsertSOCust.CommandType = 1 comInsertSOCust.CommandTimeout = 0 comInsertSOCust.Prepared = true comInsertSOCust.Execute() End Sub
VIEWS ON THIS POST

283

Posted on:

Monday 26th November 2012
View Replies!

Why do i get this relationship error?

Hi , how are you all I get the following error when i try to create a relationship between two tables: 'tblProductTypes' table saved successfully 'tblProducts2Displays2Stores' table - Unable to create relationship 'FK_tblProducts2Displays2Stores_tblProductTypes'. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_tblProducts2Displays2Stores_tblProductType s". The conflict occurred in database "intranet", table "dbo.tblProductTypes", column 'productTypesID'. ..but i dont understand why The datatypes are both the same, so surely this should not happen
VIEWS ON THIS POST

244

Posted on:

Monday 26th November 2012
View Replies!

How to display SQLServer error messages?

. Simply put This is the error message that I get when I use the wrong credentials to log in to my sql server 2000 database, via ASP login page. Code: Technical Information (for support personnel) Error Type: (0x80040E14) /baselogin.asp, line 11 What I need it was something like this: Code: Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E14) Column 'tblCustomers.cust_id' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause. /baselogin.asp, line 11 Why can't I get a full error message I'm using Win2k Advanced Server, and MS SQL 2000. I've tried disabeling: "Friedly HTTP error messages" in internet explorer I've tried enabeling: "Send detailed ASP error message to client" in iss default web site properties Can someone help me\t
VIEWS ON THIS POST

234

Posted on:

Monday 26th November 2012
View Replies!

Syntax error converting datetime from character string

hi I'm having problem with sql query i'll explain u what i'm trying to do when a user sends enquiry for a product it goes to table propertyhittable where hitid the index. if the receiver replies to the enquiry, his reply goes to table mailbox and all subsequent mail correspondence goes to mailbox. now on my Inbox Page i have to dispaly all the enquiries like gmail (each mail clustered with all past correspondence) I used the following query: select HitId,hitid as mailid,Login_Id,Star,Subject,Prop_Code,visitdate, replydate,mailread from propertyhittable where login_id'71727' and deleted=0 and prop_code in (select prop_code from resi_sell where login_id='71727' union select prop_code from comm_sell where login_id='71727' union select prop_code from land_sell where login_id='71727') union (select mb1.Login_Id,mb1.Star,mb1.Subject,mb1.Prop_Code,mb 1.maildate as visitdate, mb1.maildate as replydate,mb1.mailread,mb2.hitid,mb2.mailid from (select hitid,max(mailid) as mailid from mailbox group by hitid) as mb2 inner join mailbox as mb1 on mb1.hitid = mb2.hitid and mb2.mailid = mb1.mailid where login_id71727 and deleted=0 and mb2.hitid in (select hitid from propertyhittable where login_id='71727') ) order by replydate desc i got Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string.
VIEWS ON THIS POST

288

Posted on:

Monday 26th November 2012
View Replies!

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

I received an error message that I can't seem to resolve. The following: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Text Driver] Query must have at least one destination field. /process1.asp, line 16 Any assistance with the above will be greatly appreciated.
VIEWS ON THIS POST

245

Posted on:

Monday 26th November 2012
View Replies!

Incorrect Syntax error

I amgetting this error in SQL. Error in SELECT clause: expression near '='. Missing FROM clause. Missing or incomplete SELECT clause. Unable to parse query text. Code: SELECT dbo.TestResult.RunId, dbo.TestResult.TestName AS Project, dbo.TestResult.IsRunnable, dbo.TestResult.Owner, dbo.TestResult.CategoryFullName, dbo.TestResult.CategoryId, dbo.TestResult.StartTime, dbo.TestResult.EndTime, dbo.TestResult.SubTestCount, dbo.TestResult.SubTestPass, dbo.TestRun.Name, dbo.TestRun.FileStorage, dbo.TestRun.TestsTotal, dbo.TestRun.TestsExecuted, dbo.TestRun.TestsPassed, dbo.TestRun.TestsCompleted, dbo.TestRun.TestsFailed, dbo.TestRun.TestsNotRun, dbo.TestRun.TestsInconclusive, dbo.TestRun.TestsAborted, dbo.TestRun.RunUser, dbo.TestRun.PublishUser, dbo.TestRun.DateCreated, dbo.TestRun.DateQueued, dbo.TestRun.DateStarted, dbo.TestRun.DateFinished, dbo.TestRun.RunHasCoverage, dbo.TestRun.RunPassed, dbo.TestRun.BuildUri, dbo.TestRun.TeamProject, NSEQAEngine.dbo.TestProducts.Product AS Product, NSEQAEngine.dbo.TestProducts.Script AS Script, NSEQAEngine.dbo.TestProducts.Component, NSEQAEngine.dbo.TestProducts.Description, NSEQAEngine.dbo.TestProducts.Responsible, NSEQAEngine.dbo.TestProducts.ResponsibleEmail, NSEQAEngine.dbo.TestProducts.Manual, NSEQAEngine.dbo.TestProducts.Comment, dbo.TestResult.TestOutcome As Status = CASE WHEN dbo.TestResult.TestOutcome = 'Completed' THEN 'Passed' WHEN dbo.TestResult.TestOutcome = 'Failed' THEN 'Failed' WHEN dbo.TestResult.TestOutcome = 'Incomplete' THEN 'Debatable' WHEN dbo.TestResult.TestOutcome Is null THEN 'Debatable' END, dbo.TestResult.TestType = CASE WHEN dbo.TestResult.Testtype = 'Unknown' THEN 'TestComplete' WHEN dbo.TestResult.Testtype = 'other' THEN 'NSE QA Portal Test Type' WHEN dbo.TestResult.Testtype Is null THEN 'Invalid' END, FROM dbo.TestResult INNER JOIN dbo.TestRun ON dbo.TestResult.RunId = dbo.TestRun.RunId LEFT OUTER JOIN NSEQAEngine.dbo.TestProducts ON dbo.TestResult.RunId = NSEQAEngine.dbo.TestProducts.RunID WHERE (NSEQAEngine.dbo.TestProducts.Component '')
VIEWS ON THIS POST

226

Posted on:

Monday 26th November 2012
View Replies!

UPDATE: worked around the code = 3001 error

I replaced the recordset command line with adCmdTableDirect and it fixed that error right up. I have another error now.. I'm a SQL noob any help is appriciated. -- Database error Procedure = usp_Childs_Name The database could not retrieve the Birth record(s) because of the following unexpected error: Procedure 'usp_Childs_Name' expects parameter '@ChildsLast', which was not supplied. Microsoft OLE DB Provider for SQL Server Return code = -2147217904
VIEWS ON THIS POST

195

Posted on:

Monday 26th November 2012
View Replies!

what's the error in my mssql statement? :(

hi i always used this type of command PHP Code: \t\tresponse.write("") \t\t\t\tresponse.write("") \t\t\t\tresponse.write("") \t\t\t\tresponse.write("") \t\t\tresponse.write("") to send out my data to mssql.. but problems will occur when the users fill in the CommonName fields with values with whitespaces and/or ' how should i fix this in java there's some method called preparedstatement.. how about in asp any help is greatly appreciated.
VIEWS ON THIS POST

194

Posted on:

Monday 26th November 2012
View Replies!

Syntax error near keyword 'BEGIN'

never mind
VIEWS ON THIS POST

157

Posted on:

Monday 26th November 2012
View Replies!

error checking in ASP

hi !! i have another problem in my coding... how can i add an error checking in my page\t because i have a customer registration page where a customer will input items the page... how can i have an error checking in the page, just like having an error like "username should not be more than 12 characters" or to have an error checking account like "the password you have entered is not the same" because there will be a field with "password" and "re-type password..."
VIEWS ON THIS POST

193

Posted on:

Monday 26th November 2012
View Replies!

Timeout expired error on SQL Server query with subquery

hi, i have an ASP page that is querying an SQL database, and a SQL timeout expired '80040e31' error occurs on the recordset.open line. The query is resonably standard, except there is a correlated subquery to do a COUNT of 'other users' who registered lately against the same school. Is there a way to make the query more efficient, (uncorrelate the subquery or something) so that the timeout error does not occur I could take out the subquery, and then do a seperate query on each userID to see if there are 'other users' for that user, but i think that might be less efficient than using the subquery (only about 1 in 10 users has 'other users'). The users table has about 40000 records, and no field is very large, varchar 300 would be about the biggest.
VIEWS ON THIS POST

286

Posted on:

Monday 26th November 2012
View Replies!

ORA-12560: TNS:protocol adapter error

hi ppl, i tried to connect oracle server installed in a remote machine located in the same network and oracle client is installed in my local machine. when i try to execute the SQL statements from my client machine i am experiencing the following problem :- ERROR: ORA-12560: TNSrotocol adapter error i had given the oracle server machine's IP address correctly in the "Net Configuration Assistant". kindly reply me at the earliest, regards, Ramamoorthy
VIEWS ON THIS POST

175

Posted on:

Monday 26th November 2012
View Replies!

How to trap error for duplicate key

With VFP, I have created a Form based on remote view of a table in MS SQL Database, that have a primary key. If the record is new, after I have enter the primary key, I need to control if the code exist already. I have not problem with the dbf file, but I have some difficulty with SQL database. Someone can help me, in order to resolve this problem Thank you. Best
VIEWS ON THIS POST

205

Posted on:

Monday 26th November 2012
View Replies!

Timeout error

I have an excel program that runs every 10 minutes that gets data from files and inserts it in a table in the SQL server. Most of the time it runs ok. However when the network has heavy use, it generates a "Timeout" error. How do I prevent this
VIEWS ON THIS POST

176

Posted on:

Tuesday 27th November 2012
View Replies!