Error 3044


I have a front end DB that will open fine on all computers except one. When the DB is opened, a prompt for the username and password appears. After the username and password is entered, they click the enter command button which then opens the Home Form. The Home Form has an OnOpen event with an embedded macro to open a hidden form that I keep open during the entire session. According to the message box the problem is with this form. When the enter button is clicked we receive an error message box with the details below:

Macro Single Step (MsgBox Name)

Home: Form: OnOpen: Embedded Macro (Macro Name)

Open Form (Action Name)

3044 (Error number)

FrmKeepOpen, Form,,,,Hidden (Arguments)

The 3 button options on the message box are "Step" which appears disabled, "Stop All Macros" which appears enabled and highlighted, and "Continue" which appears disabled.

This message only appears on one computer.

Any ideas as to how to fix this error?


Sponsored Links:



hi,

access version 2003

i have bought an Access program for my business and am using a .mdb database with this software.

i have installed the software on a new PC , but get the following ERROR when running the software:

is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. (Error 3044)

shall be very gratefull if anyone can assist me with solving this one !

thanx
m




Hi,

When I run the following code I get a Run-time error '3044':

Private Sub Command0_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "qry_cost_01_update_month", acViewNormal, acEdit
DoCmd.OpenQuery "qry_cost_02_update_WL_categories", acViewNormal, acEdit
DoCmd.OpenQuery "qry_cost_03_update_wouldbe_W_category", acViewNormal, acEdit
DoCmd.OpenQuery "qry_cost_04_update_invoice_W_category", acViewNormal, acEdit
DoCmd.OpenQuery "qry_cost_05_wouldbe_cost", acViewNormal, acEdit
DoCmd.Close acQuery, "qry_cost_05_wouldbe_cost"
DoCmd.OpenQuery "qry_cost_06_invoice_cost", acViewNormal, acEdit
DoCmd.Close acQuery, "qry_cost_06_invoice_cost"
DoCmd.OpenQuery "qry_cost_07_update_savings_master", acViewNormal, acEdit
DoCmd.OpenQuery "qry_cost_08_breanne_report", acViewNormal, acEdit
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_cost_08_breanne_report", "U:Logistics SavingsSavings", True
DoCmd.SetWarnings True
End Sub

In the debugger, the bolded line is highlighted. "Logistics Savings" is a folder in my U Drive. If I make the path "U:Logistics Savings" the spreadsheet exports directly to my U Drive with the name "Logistics Savings.xls". I need to export the spreadsheet to my U Drive, Logistics Savings folder, and name the spreadsheet "Savings.xls".




I am getting run-time error '3044' 'phoenixsharedreviews.mdb' is not a valid path.

Under the debugger, here is the highlighted text, I don't understand, because there is no path in this field...:

DoCmd.RunSQL "UPDATE Tbl_ReviewRecord INNER JOIN Tbl_MasterReviewRecord ON (Tbl_ReviewRecord.Interval = Tbl_MasterReviewRecord.Interval) AND (Tbl_ReviewRecord.Year = Tbl_MasterReviewRecord.Year) AND (Tbl_ReviewRecord.EID = Tbl_MasterReviewRecord.EID) " & _

" SET Tbl_MasterReviewRecord.TL_EID = [Tbl_ReviewRecord]![TL_EID], Tbl_MasterReviewRecord.OM_EID = [Tbl_ReviewRecord]![OM_EID], Tbl_MasterReviewRecord.Prod_Speed = [Tbl_ReviewRecord]![Prod_Speed], Tbl_MasterReviewRecord.Quality = [Tbl_ReviewRecord]![Quality], Tbl_MasterReviewRecord.Safety = [Tbl_ReviewRecord]![Safety], Tbl_MasterReviewRecord.Innovation = [Tbl_ReviewRecord]![Innovation], Tbl_MasterReviewRecord.Commitment = [Tbl_ReviewRecord]![Commitment], Tbl_MasterReviewRecord.Conduct = [Tbl_ReviewRecord]![Conduct], Tbl_MasterReviewRecord.Attendance = [Tbl_ReviewRecord]![Attendance], Tbl_MasterReviewRecord.Teamwork = [Tbl_ReviewRecord]![Teamwork], Tbl_MasterReviewRecord.Dept_Comments = [Tbl_ReviewRecord]![Dept_Comments]," & _

" Tbl_MasterReviewRecord.Above_Comments = [Tbl_ReviewRecord]![Above_Comments], Tbl_MasterReviewRecord.Below_Comments = [Tbl_ReviewRecord]![Below_Comments], Tbl_MasterReviewRecord.Gen_Comments = [Tbl_ReviewRecord]![Gen_Comments], Tbl_MasterReviewRecord.Cell = [Tbl_ReviewRecord]![Cell], Tbl_MasterReviewRecord.JobCd = [Tbl_ReviewRecord]![JobCd], Tbl_MasterReviewRecord.JobDesc = [Tbl_ReviewRecord]![JobDesc], Tbl_MasterReviewRecord.Badge = [Tbl_ReviewRecord]![Badge], Tbl_MasterReviewRecord.Writeup = [Tbl_ReviewRecord]![Writeup]" & _

" WHERE (((Tbl_ReviewRecord.Year)=[Forms]![Frm_Admin]![cmboBxYear]) AND ((Tbl_ReviewRecord.Interval)=[Forms]![Frm_Admin]![CmboBxInterval]) AND ((Tbl_ReviewRecord.TL_EID)=DLookUp('[TL_EID]','Tbl_TL','[TL] = ''' & [Forms]![frm_Admin]![CmboBxTL] & '''')));"




Hi
I have an issue with Acess 2010 and error 3044

This is a database that was created in access 2003 and has been ported onto a Windows 7 Network and Access 2010.

The application is split into two parts Front End application and the backend data which located on another machine on the network.

The application has been relinked with the new location and when run directly from Access 2010 works without an issue. However when the application is run for a desktop shortcut to will show the error following error.

There is an incompatible element in the automatic Configuration Table of

Will Not be set. Please report the problem to your local supplier.
‘O:BxxxxxData2BxxxBE.mdb is not a valid path. Make sure that the
path name is spelled correctly and that you are connected to the server on which
the file resides.

The users all have full admin rights on the PC and the shortcut has the run as administrator selected.

The shortcut code is shown below:

The Target is: "C:Program Files (x86)Microsoft OfficeOffice14MSACCESS.EXE" /runtime "C:Program Files (x86)XXXBXXXXBXXXXX.mdb" /wrkgrp "C:Program Files (x86)XXXBXXXXXCXX_XX_Apps.mdw

The Start In is: "C:Program Files (x86)XXXBXXXX"

Well thats it ,any help to sort this out would greatly appreicated! Attached Thumbnails     Reply With Quote 12-10-2012, 12:10 PM #2 June7 Super Moderator Windows XP Access 2010 32bit Join Date May 2011 Location The Great Land Posts 15,107 Googel: Access 2010 workgroup administrator

Does this help http://www.dbforums.com/microsoft-ac...ss-2010-a.html




I have back end database with several tables which resides on networks server. 2 applications on different workstations are connected to this database. Sometimes we are experiencing that application no 2 (no 2 because it's the second in the row that connects to DB) causes this error. I haven't tested it but I think I've noticed that error arises when application no 1 access the database and then application no 2 tries to access it.
Can multiuser network environment cause this error?
I don't think it's the bad link to the tables because after we shut down application no 1, the second app started up immediately.
I'm asking this because I wanted to give some nicer error message to the user if this is multiuser environment issue, but wanted to make sure first.
Thank You




Hi All,

I have a form setup for importing text files based on which check box is checked. I keep getting runtime error 3044 "invalid path"
I am using the UNC path for each file. Any idea where I am messing up?



	Code:
	Private Sub Command32_Click()
'When Check Box is Checked Import that Groups Transactions
If Me.Check0.Value = -1 Then
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 4
TRANS.txt"
Else
If Me.Check1.Value = -1 Then
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 5
TRANS.txt"
Else
If Me.Check2.Value = -1 Then
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 7
TRANS.txt"
Else
If Me.Check3.Value = -1 Then
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 8
TRANS.txt"
Else
If Me.Check4.Value = -1 Then
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 11
TRANS.txt"
Else
If Me.Check5.Value = -1 Then
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 12
TRANS.txt"
Else
'Import ALL AP Transactions. To prevent Duplicate Imports Uncheck Groups Individual Check Boxes
If Me.Check_All_AP_Transactions.Value = -1 Then
Me.Check0.Value = 0
Me.Check1.Value = 0
Me.Check2.Value = 0
Me.Check3.Value = 0
Me.Check4.Value = 0
Me.Check5.Value = 0
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 4
TRANS.txt"
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 5
TRANS.txt"
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 7
TRANS.txt"
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 8
TRANS.txt"
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 11
TRANS.txt"
DoCmd.TransferText acImportDelim, "Transaction_Import", "Transaction_TextFile_Import", "ADDWDDTLS7B1Transaction FilesGRP 12
TRANS.txt"
 
End If
End If
End If
End If
End If
End If
End If
 
End Sub





Hello,
I need help to fix a path....
I got an Access DB and try to open it but is showed "not a valid path, Error 3044"
I know I need to change the path, but where I can find wrong path and fix it? Seems I didn't see anywhre that have a path....
any help would greatly appreicated!




Hi and sorry if this is posted in the wrong section. Also I'm very new to access and still am trying to learn.

We have a database on a server in another location, i had to copy all the info and now have it on my pc.

When i try to link to one of the databases it get this message:

Run-time error '3044':

'f:dbfilesBCprodTMdata.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the flies resides.

Any help on how to link the files correctly?

and also if someone could help with this too, we have another server set up and all the info from this database will be uploaded to it, how do I connect this database to the server for the files to be uploaded?

Thank you so much if you can help!




Hi Everyone
Looking at a different approach and really struggling, I have a macro that when a user clicks a button it does a transferspreadsheet command, problem is the excel file is on a USB, if the user doesn’t insert a USB i get a 3044 error message, how do you trap the error to show custom error message to say please insert your usb

Tried all sorts of things but nothing for me works can anyone advise please just let me know, below is the code i use

The code is Private Sub Image19_Click()
‘Deletes all the contents on the table realy for an new upload
DoCmd.OpenQuery "DltConsignmentMasterAll", acViewNormal
‘ imports the new information
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "TblConsignmentMaster", "Z:UploadsConsignment Lists To Upload.xlsx", True
‘Cleans the table of any blanks imported
DoCmd.OpenQuery "DltCleanConsignmentMaster", acViewNormal
MsgBox "Done"

End Sub




Based on what lagbolt warned, a "string" doesn't work for the path name, so the blue text (mypath & objWkb) was replaced with the full path and file name (G:DataFolderDataFile1). Before doing this replacement, I confirmed that lagbolt was correct in predicting that the blue text would cause the next error.

Perhaps a string can't be used to describe a range, just as it didn't work in describing the path and filename . . .

Quote: Originally Posted by cyb3rwolf Hmm... I'm assuming the .Name property is the same as anything else i've worked with, should return the name of the worksheet. Let me try it and i'll get back to you shortly.




http://www.access-programmers.co.uk/...d.php?t=171030

kathy - i put this thread in the general area, dealing with a backend corruption i had experienced and resolved. corruptions tend to manifest themselves with strange spurious errors, and standard routines start to fail

clearly you understand what you are doing, and yes there is almost bound to be some performance degradation using linked tables compared with non-linked.

one real additional issue with non split databases is that it becomes very hard to modify the functionality - whereas this is easier when the data is separate.

also, if the database itself uses local temporary tables, then you HAVE to have a split database, or ensure only one user can be in the dbs at a time, or one user may overwrite another users temporary table

in balance i would certainly side with bob and separate the data from the code, but its your system - as long as its backed up regularly, no doubt you can always recover to a safe point anyway.




TallMan,

JANR caught that one for me and I removed the tick mark. Back to getting the error.




I am now getting a new error & I know it's something simple I'm just not seeing & it's driving me crazy. The error is missing operator in query expression 'Vendor Hotline Log.Status = "Closed"'. I think it might be in my query in the Status field I have this in Criteria

	Code:
	 In (([Vendor Hotline Log].[Status])='Open' Or ([Vendor Hotline Log].[Status])='Closed')





Hi all,

Hoping you can help. We have circa 12 users accessing SQL Server 2005 (SBS Server 2003) from Windows XP / Access 2007 front ends. The system has been live for 12 or 13 years with very little issue. 60 odd MsSQL tables and a good number of views.

Application will update one particular table using DoCmd.RunSQL. For the last couple of years, we would occasionally will receive a ODBC Timeout error when updating this one table.

All other table updates and views etc will be fine, just this one 'problem' table.

A SQL restart would normally fix this problem, but in the last couple of months, the frequency has increased and restarting the db would always fix the problem.

Updated access frontend and sql backend to use Stored Procedures and pass thru queries and we thought we had solved the problem, but alas the next day we began to receive ODBC FAILED errors. Restarting the db would not always solve the issue.

All users access MsSQL using the same SQL username. Have tried differing combinations of network group permissions and using direct SQL usernames.

All clients use SQL SERVER odbc connector. Have also downloaded SQL Native Client odbc to an XP machine, but this did not resolve the issue either.

Strange thing is - if someone else logs onto the same local machine, they can perform the update. This user also happens to be a server admin.


If I log into the (SBS) server remotely and run the application from the server desktop, the update also works fine also.

If I then make a 'problem' user a server admin, the update on the 'problem' table works fine.

What has come to light today is the server people did driver update on the server a few weeks ago - which apparently included a SQL driver update...Not 100% sure on this though...

Question is, could some memory allocation settings or similar have been changed as part of the update? It's all very odd




Did some quick research on Liability Insurance for Small Business or for Self-Employed Contractor. This poll / discussion is asking what do you pay? For 2013, my requirements changed.
There is
General Liability Insurance
Professional Liability Insurance (a.k.a. Errors and Omissions)
The Professional Liability Insurance can cover things such as Amendatory Endorsement - Claims Made By Any Regulatory Authority or Governmental Agency

Spent some time going over these. Found my general liability was cheap, but most things didn't cover real-world events. Not going to give any advice here except to shop around and ask hard questions.

For 2013 with $1,000,000.00 USD for each General and Professional:
General: Year: $276
Professional Year: $1,350
In general these were up about 45% from a poll with technology types back in 2003.

Please be incouraged to respond and discuss this.
Thanks.

If you are a consultant, self-employed, or independent, you have an increased chance of being required to get Professional Insurance.
Here is an intereting study / survey that includes Database Programmers:
http://betterley.com/samples/teoms12_nt.pdf
Coverage for the liability arising out of the de-sign and manufacturing of technology-related products, the creation and implementation of soft-ware, and the provision of related services, is a growing business, with specialty coverages de-signed to cover the Errors and Omissions liability that may not be covered under traditional liability policies. Tech E&O coverages can be purchased for technology consultants, systems integrators, application service providers, Internet service pro-viders, Internet retailers, cloud services providers, network electronics manufacturers, medical tech-nology manufacturers, and telecom companies.




The following Code pops up when I run the "Web Compatible" check?

ACCWeb107014
Error text A Table should have a Primary Key and it should be a number with field size 'long' to be compatible with the Web.
What it means The indicated table has one of the following problems:
· The table does not have a primary key.
· The data type of the primary key is not Number.
· The primary key Field Size is not Long.
What to do Change the existing primary key in Design view so that it has the correct data type and Field Size; or, create a new primary key for the table, using the AutoNumber data type. If Design view is not available, create a new table, and add to it the columns from the original table; then drop the original table.
My "EmpID" is the first four letters of the Last Name and the first 3 of First Name.

Is that NOT going to work? I know it says it won't, but I'm surprised that it doesn't.




(Previously posted to Reports section, incorrectly. Sorry.)

I'm using MS Access 2003.

I have a form that displays in datasheet view. When I select a record and hit my keyboard's Delete button, I see the following error:
Quote: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. This error *always* appears when deleting any record from this form. After clicking OK on this error, if I refresh the form, the record in question has indeed been deleted.

We use an Oracle back-end, and I have tried dropping the associated triggers and refreshing the table links, but the error message persists.

Some web pages suggest database corruption, but if I Compress and Repair, I still have the problem.

Any other ideas of where to look?

Any help you can give would be appreciated.

Thanks.

Wayne




I'm using MS Access 2003.


I have a form that displays in datasheet view. When I select a record and hit my keyboard's Delete button, I see the following error:
Quote: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. This error *always* appears when deleting any record from this form. After clicking OK on this error, if I refresh the form, the record in question has indeed been deleted.

We use an Oracle back-end, and I have tried dropping the associated triggers, but the error message persists.

Any other ideas of where to look?

Any help you an give would be appreciated.

Thanks.

Wayne




I know that this topic has been discussed, but I can not get my report to work. I have 2 text boxes that are giving me this message. I think that I should use the Nz function, but no matter what way I type it in, there is always an error message. I think it has to do with the fact that the calculated field is from a sub report. Could someone help me out. One of the fields as it stands is [Copy of Payments].[Report]![Text24]