ADP File Is Not In The Correct Format...

I have looked in several forums trying to find an answer to this question, but so far no solutions. I created an Access database (mdb) for stand-alone use. One of my users has used the database for quite some time, but when she recently tried to open it, she was shown the following error message:

"The ADP file is not in the correct format for a Microsoft Access project."

In all the forums in which I have found any information on this, they refer to a file created to relate to SQL. This is not the case...it is a straightforward Access (mdb) relational database that will no longer open.

I'm not sure how I am going to be able to repair the database if I can't get it to open. Any help on this matter would be appreciated. I do not have any idea what might have transpired to cause the problem.

View Replies


ADVERTISEMENT

Correct File Format - Version: 2000 (9.0)

Hi,

I am trying to save a .csv file as a .xls file but am having trouble with the FileFormat as keep coming up with runtime error or when I have tried something else it didn'e save correctly.. Can anyone help please.

Have placed code below:

TensorData.Workbooks.Open "C:Documents and SettingsAdamMDesktopExcel MacroORR ALL.CSV"

TensorData.ActiveWorkbook.SaveAs "C:Documents and SettingsAdamMDesktopExcel MacroORR ALL", ".xls"

Thanks
Stretch

View Replies View Related

ADP File Is Not In The Correct Format... - Version: 2000 (9.0)

I have looked in several forums trying to find an answer to this question, but so far no solutions. I created an Access database (mdb) for stand-alone use. One of my users has used the database for quite some time, but when she recently tried to open it, she was shown the following error message:

"The ADP file is not in the correct format for a Microsoft Access project."

In all the forums in which I have found any information on this, they refer to a file created to relate to SQL. This is not the case...it is a straightforward Access (mdb) relational database that will no longer open.

I'm not sure how I am going to be able to repair the database if I can't get it to open. Any help on this matter would be appreciated. I do not have any idea what might have transpired to cause the problem.

View Replies View Related

Which Is The Correct Format - Version: 2003 (11.0)

I've just upgrated to 2003 and when I open my database in a merge with WORD I get this screen:

Open Data Source:
OLE DB Database File
MS Database via DDE
MS Database via ODBC

Is one better than the other? So far I have used OLE DB but I'm cornerned that by using the wrong type I might corrupt my DB.

Thanks in advance.

View Replies View Related

Import Wizard (Excel Correct Format)

I am trying to import an Excel2002 file into Access2002 using the import wizard. There is a hidden worksheet named 'Data' with 5 ranges defined (Page1-5), one of which I am trying to import: I am getting the following error message –

“Import Spreadsheet Wizard -- The wizard is unable to access information in the file ‘D:xxxx.xls’. Please check that the file exists and is in the correct format.”

I have successfully imported other Excel files from the same folder, but using a different original file. The original Excel file giving me the trouble was created in 1999 but has been saved with Excel2002 version.

Can anyone tell me what causes the “correct format” error? I am confident it is something having to do with the Excel file. I've attached a zip file with the problem workbook.

Thanks in advance for any assistance.

View Replies View Related

Correct Week Number Format In A Query

Wondering if anyone can advise...

The 1st/2nd Jan of this year were treated by most people as still being week 53 of 2004, and week commencing 3rd January being week 1 of 2005. In VB I have a formula to do this:

WeekNo = Format(Now(), "ww", vbMonday, vbFirstFourDays)

However my problem now is that I need to replicate this format in a Query within Access. The formula

WeekNo: Format(Date(),"ww")

treats 1st/2nd Jan as week 1, the 3rd as week 2 etc. Any idea how I can get it to treat 3rd Jan as week 1 instead?

There's a challenge for someone!! Help appreciated.

View Replies View Related

Export As XML In Correct Format - Version: 2002 (10.0) XP

Good morning,

A state environmental agency is starting to require us to use electronic notification whenever a pollutant is discharged into a stream or creek. We have been using fax to notify them, but we store this data in Microsoft Access.

The state agency has an online form we can use to enter the information or we can upload a XML file. They have provided me sample XML & XSD files. I was able to import the XML into Access without any problems, but when I export the XML file it appears to be in a different format.

My knowledge of xlm is very limited and would appreciated any help with this.

I have attached the sample xml file.


Thanks for any help, Rob

View Replies View Related

Unable To Correct Format Of A Total. - Version: 2000 (9.0)

Hello:

Please help!!!

My user has an Access database that uses a Word Document (v.2000) as a form to merge data from a table in the database to print letters.

Here are three examples of how the <<Total>> merge field will print:

$438.78
$900.9
$167.103

As you can see the first total is fine; however, the second total is missing a digit and the third total has three decimal places.

I attempted to correct this problem by using the FORMAT function FORMAT([total],”$0.00”). No matter where I put this function (in the form or query and changed decimals from Auto to 2) it still won’t correct the problem.

Does anyone have any suggestions?


Thanks in advance!!!!!!!!!!!!!!!!!!!!


nbeni,

View Replies View Related

Function To Send In Text In Correct Format? - Version: 2007 (12.0)

Can someone direct me to the right direction for creating this type of function.

Currently I have a sql statement set up like this:

Select * from employee_table where employee_name in ('Joe', 'Bob', 'Steve')

I am using a form to have the user enter in the list of names they want to search in an unbounded text box call emp_name.

Since the user will enter in Joe, Bob, Steve into the text box, I need a function that will be able to take in that information, place a single quote around each name and separate them by a comma, so that it will look like the SQL statement above.

I'm guessing it might look like this?

StrSQL = "Select * from employee_table where employee_name in (" & StringFunc(emp_name) & ")"

Any help would be greatly appreciated.

View Replies View Related

Force Correct Textbox Entry Format ? - Version: 2002 (10.0) XP

I have a textbox whereby the users are required to enter a name (Last Name, First Name). What I'm seeing is every other format under the sun including simply initials. I want this field available to group on at the end of the month. Currently, that's not possible because of the trash being typed in this field a thousand different ways. Is there a way to force the Last Name, First Name compliance at the before update event level ?

View Replies View Related

How To Update Network Link To The Correct File.

I have 2 files with linking tables. Both are posted on the same network drive for the office to access. However some users have their drive link to drive E: and some to G:, etc. How do I get the file to automatically find what drive the user has and update the correct link in Linked Table Manager?

Thanks for your helps,

Penguin

View Replies View Related

Help "ADP Not In Correct Format" Error When Opening My MDB - Version: 2000 (9.0)

So this morning I go to run my .mdb as usual & get the error:

"The ADP file is not in the correct format for a Microsoft Access project"??

I'm not sure what an ADP even is?
I've tried compact/repair via access and the Jet utility but neither will run on this.
Also tried importing tables/queries to a new DB but I get the same error.

Any thoughts as to what happened and how to recover my .mdb?

Thanks,
NickB

View Replies View Related

Auto Save A PDF File Using Specific File Name Format - Version: 2003 (11.0)

I am using a script which I had found here on utter access. I have copied and pasted it below. Now this script is exactly what I was looking for however, I need for a way to automate the process even further so that it does not ask for a location to save to but determines that based on the script. I am using Adobe Acrobat Professional 7.0. The script below simply changes the printer that it prints to.

default_p = Application.Printer.DeviceName
Application.Printer = Application.Printers("Adobe PDF")
DoCmd.OpenReport "rptResaleInvoice", acViewNormal

Please let me know if any more details are required.

View Replies View Related

Unrecogonized File Format

Hi there,

While i am trying to open the access database its giving me below error:
"Database ###### needs repair or its not access file format"

And i am not able to open it because of that.
Please advise if something can be done.

Thanks
Danny

View Replies View Related

Change File Format

Hi all,

I had a form with a command button which invokes email sending option to send a report..I am using code from a sample database . The code which I am using is here:-

'This will create the e-mail

DoCmd.SendObject acReport, "Rpt_Customer", "RichTextFormat(*.rtf)", "", "", , "Customer Report", "", False, ""

'Tbis explains all the section of the e-mail see SendObject in help
Rem example from help DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]


The code is working perfect and my question is that can I change the file format from RichTextFormat to word format????? I tried by chaning "WordDocument (*.doc)" but it didn't worked???? Is there any way I can change that to word format (*.doc)???? any suggestions appreciated .

thanks in advance
Thanks

View Replies View Related

Converting A File To MDE Format!!

I have a database with 12 tables,8 modules and 20 forms. But when I try to convert it to an MDE file it gives me an compilation error, that the size of the file is too large.

Can anyone tell me why??

View Replies View Related

Extraxt And Format Data From Txt File

Does Access able to extract and format data from Access such as follow:

abc/d e4.5% 0216 010203 USD22.35 - extract 'abc', '010203', '22.35'.

abc - it's always in front, it's either 'abc' or 'wxyz'. If 'abc' is not shown, just input 'wxyz'.

'010203' - it will be in the middle, it may appear as abc010203 or abc222010203, always in 6 digit.

22.35 - always at the back, after three alphabet, if it's not shown, just input 0.

I have been able to do it in Excel, but I am wondering if it can be done in Access so that I can eliminate the process to import the text file into Excel.

Please advise and thanks.

View Replies View Related

Odd File Format For Import By Bank

Hi:

Working with a bank that wants a file from us so they can import into their check reconciliation program. Got the export from the accounting program working for the info they need, but the bank guy says he needs a file structure like this:

(first row is header..don't worry about what the stuff means for now)
1234578990000000000000000
(rest of rows are details)
1234589000807091234
1234589000807093456

notice the line breaks between header and rows? Wouldn't this call for a line break and mess up an import program? Bank guy isn't a database person and is clueless

Thanks......

View Replies View Related

Mdb File Format - Version: 2003 (11.0)

Is there a benefit to converting my mdb to Access 2002/2003 file format as opposed to the default 2000 format?

I have just split my project and will be packaging it with VSTO 2005 Access Developer tools.

View Replies View Related

Email Table In Text File Format

Hi,
I am trying to email a table in text format using :

DoCmd.SendObject acSendTable, "Table", acFormatTXT, , , , "Results", "Attached are the reslts"

It sends the file in text file format, but it adds "-" & "|" characters all over the file. Is there a way that I can send the file in simple "Comma Separated" file format.

Thx,

Jatz

View Replies View Related

Email Table In Text File Format

Hi,
I am trying to email a table in text format using :

DoCmd.SendObject acSendTable, "Table", acFormatTXt, , , , "Results", "Attached are the reslts"

It sends the file in text file format, but it adds "-" & "|" characters all over the file. Is there a way that I can send the file in simple "Comma Separated" file format.

Thx,

Jatz

View Replies View Related

Access File Format - Version: 2003 (11.0)

Hey,

I noticed something that seems odd to me. I have Access 2003 and whenever I try to create a new database, it creates it in the Access 2000 file format. Why is that?? Should I use the converter tool to convert each database to the 2003 / 2002 format? Whats the difference?

View Replies View Related

Send File In Csv Format - Version: 2002 (10.0) XP

I need to send a table as an email attachment with a csv file format.

View Replies View Related

Error 321 : Invalid File Format - Version: 97 (8.0)

Hi,

I hope someone can help me. I have a VB app that uses Access 97. One of my users, only one, gets this error message when she tries to perform a task in the App. The Access file is shared across a LAN and since noone else is experiencing this error, I can't imagine that it actually has anythign to do with the file.

Can someone please point me in the right direction? There seems to be nothing out there on the web that helps with this problem.

THANKS!!!

View Replies View Related

Access 2000 File Format - Version: 2003 (11.0)

I recently installed Access 2003 on my computer and noticed this message at the top of my forms "Access 2000 File Format" - I read somewhere here in the forum why it's showing this message but I wanted to know if keeping this format prevents me from using any additional funtionality 2003 may have.

Thanks!

View Replies View Related

Unrecognized File Format Error - Version: 2000 (9.0)

I am using Access 2000. There are some mdb floating around on the server that were created in 97. I converted one of these to 2000. The mdb is the employee master list (first name, last name, active are the fields). I am trying to use this in an Excel user form but when the VBA runs I get an "Run-time error 3343 Unrecognized Database Format" error. Anyone know what I need to do to fix this?? I checked support.microsoft.com but the http://support.microsoft.com/kb/238401 did not seem to apply. I can open the file in Access, just not via Excel.

View Replies View Related

Database Doesn't Support The Format Of The File, So It Can't Loa - Version: 97 (8.0)

Hi

The subject heading is the error message that I get from my database when I move from record to record on a form that has graphics.

The database was working fine for some years and all of a sudden it has started showing this error.

I store the graphics on my hard drive using "Me![ImageFrame].Picture = PathName & Me![ImagePath]" to show them on the form. Like I say it has been working fine for ages but now all of a sudden it is throwing up this error. The files are jpg. I have change a file to wmf and it works fine but I prefer to use jpg.

Can anyone help? what has caused this and how can I fix it?

I have MS Office professional 97 running on Windows XP Home.(Old I know but why should I enrich MS when it is all that I will ever need!) I have tried reloading the graphic filters from disc with no effect. Is it a corrupt or missing file? If so what File? can I replace it.

My thanks in advance.

Lex

View Replies View Related

Exporting To A Text File With A Format Not Supported By Transfer

Sometimes the TransferText function will not give you the specific text file format you need. This example code demonstrates creating a text file that includes a header record and a footer record. The concepts can be extended to other specific format requirements as well.

Built in A97, and uses DAO. Should work in later versions fince.
--------------------------------------------------------------------------------
Public Sub WriteTestB()
' this function is an example of exporting a query's output to a text file using
' Print # to write to the file line by line
'
' note that since it uses DAO methods a reference to DAO must be set in Tools/References

Dim rs As Recordset ' Recordset to access the query data
Dim intRecordCount As Integer ' used to count records

'open the recordset to get the query data
Set rs = CurrentDb.OpenRecordset("qryCustomerSummary")

' open the text file for output
Open "c: empoutdata.txt" For Output As #1

' print a header with the current date
Print #1, "HDRCstDta " & Format(Date, "yyyymmdd")

intRecordCount = 0

' loop through all records in the query
Do Until rs.EOF
' write a record to the text file, formatted as follows:
' Customer ID, padded on the right with spaces to eight characters,
' ContacteName, padded on the right with spaces to 25 characters
' (left is used to make sure it doesn't exceed 25)
' TotalOderValue, 8 digits before decimal and two after, zero filled
Print #1, Format(rs!CustomerID, "!@@@@@@@@"); _
Format(Left(rs!ContactName, 25), "!@@@@@@@@@@@@@@@@@@@@@@@@@"); _
Format(rs!TotalOrderValue, "00000000.00")

intRecordCount = intRecordCount + 1
' move to next record in query output
rs.MoveNext
Loop

' print a trailer with the record count
Print #1, "TLRCstDtaRec=" & Format(intRecordCount, "000000")

' close the text file
Close #1

'close the recordset
rs.Close
Set rs = Nothing

End Sub

--------------------------------------------------------------------------------

View Replies View Related

File Created In Access 200 Format - Version: 2003 (11.0)

I have created an Access database in Access 2003. I am now ready to look at a multiuser environment. In investigating this I was told to convert my databse to the 2003 format. Why would Access 2003 create a database in Access 2000 format?

View Replies View Related

Access 2000 File Format - Version: 2003 (11.0)

I have just created an adp front end to a SQL 2005 back end in Access 2003.

When I worked on the front end, the application was titled "Access 2000 file format". I naively assumed that this meant the project would work on a machine running Access 2000.

However, when I open my adp on my user's machine (running Access 2000), various errors occur:

Defaults on forms are incorrect (a checkbox whose default is true is false).
DoCmd.OpenReport causes a debug - wrong number of arguments.
Stored procedures don't seem to work (A listbox driven by a query held in a SP is empty, etc).
Other errors.

Any ideas?
As a last resort, would moving the user to Access 2003 definitely work?

Fergus

View Replies View Related

Wrong File Format To Create An .MDE - Version: 2003 (11.0)

I created a database using Access 2003 but when I tried clicking on the toolbars ---TOOLS---DATABASE UTILITIES---Make MDE file....I get an error message saying I can't create an MDE using Access 2000 File format.

Do I have to convert this database??? I thought I was 2003? What should I do and how?

View Replies View Related

File Format Not Supported Error - Version: 2000 (9.0)

I am linking to JPG photos outside my DB. I just got a new PC with XP. I get "Microsoft Access doesn't support the format of the file \ChaplinScienceGroups......., so it can not load the picture" -- It worked before with Win 2000. It also works on other XP machines around the office here. Why my PC? Any ideas? ....

View Replies View Related

Create Button, Export Five Report Same Format To Five Sheet Of One File Xls

Hi
Please help me,
I have the form, in this form there is list of value which run query and resulting the report. For example if I have 5 item in list, i have to choose one of then and the query running and the report is print preview.

My question is,
How to export all 5 report to 5 sheet in one excel file.
I know may be the problem in format if I send to excel, but I will fix it in the excel. The most important is, I export the report to excel, each of the report in each of sheet of excel.

Thanks in advance
sorry my english is not good.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved