A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Wrong Database Format



 
 
Thread Tools Display Modes
  #1  
Old June 12th, 2004, 03:25 PM
Kentucky5
external usenet poster
 
Posts: n/a
Default Wrong Database Format

I have a database that when I try to open it says that it
is the wrong format, is there a way to fix this so that I
can open the database?
  #2  
Old June 12th, 2004, 06:39 PM
Joseph Meehan
external usenet poster
 
Posts: n/a
Default Wrong Database Format

Kentucky5 wrote:
I have a database that when I try to open it says that it
is the wrong format, is there a way to fix this so that I
can open the database?


Maybe if we knew what format the database was in and what version of
Access you are working in.

Is it possible the database was created in a newer version of Access
than you are using?

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math



  #3  
Old June 13th, 2004, 12:58 AM
Kentucky5
external usenet poster
 
Posts: n/a
Default Wrong Database Format

I have Access 97 I am not sure what version the database I
am trying to open is. I even tried linking to the
database and that did not work or importing the data and
that could not read it either. Is there any way around
this?

Thank you
-----Original Message-----
Kentucky5 wrote:
I have a database that when I try to open it says that

it
is the wrong format, is there a way to fix this so that

I
can open the database?


Maybe if we knew what format the database was in and

what version of
Access you are working in.

Is it possible the database was created in a newer

version of Access
than you are using?

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math



.

  #4  
Old June 13th, 2004, 01:12 AM
Joseph Meehan
external usenet poster
 
Posts: n/a
Default Wrong Database Format

Kentucky5 wrote:
I have Access 97 I am not sure what version the database I
am trying to open is. I even tried linking to the
database and that did not work or importing the data and
that could not read it either. Is there any way around
this?


Not if we don't know why.

If the database is from a newer version or is not an Microsoft Access
database, you may not be able to open it.

Is this database on your machine or are you accessing it via a network
connection? Do you have full rights (read, write, delete etc.) to the
folder where the database is located? Try saving a simple text file to the
same location, then open it and make changes, then save it. Close the text
editor. Now re-open it and see if the changes are there, now try deleting
it.

Try to find out what program and version of that program was used to
create the file. Is it a MDB file or an MDE file or what?

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math



  #5  
Old June 13th, 2004, 02:10 PM
Kentucky5
external usenet poster
 
Posts: n/a
Default Wrong Database Format

Yes I have full access to the folder. Under attributes
nothing is listed. I says it is a Microsoft Access
Database. I even had someone with Access 2000 try to
access and they got the same message about the format. I
even tried the repair tools in Access but continued to get
the same message. HMMMMMMM

Thanks
-----Original Message-----
Kentucky5 wrote:
I have Access 97 I am not sure what version the

database I
am trying to open is. I even tried linking to the
database and that did not work or importing the data and
that could not read it either. Is there any way around
this?


Not if we don't know why.

If the database is from a newer version or is not an

Microsoft Access
database, you may not be able to open it.

Is this database on your machine or are you accessing

it via a network
connection? Do you have full rights (read, write, delete

etc.) to the
folder where the database is located? Try saving a

simple text file to the
same location, then open it and make changes, then save

it. Close the text
editor. Now re-open it and see if the changes are there,

now try deleting
it.

Try to find out what program and version of that

program was used to
create the file. Is it a MDB file or an MDE file or what?

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math



.

  #6  
Old June 13th, 2004, 07:27 PM
Joseph Meehan
external usenet poster
 
Posts: n/a
Default Wrong Database Format

Kentucky5 wrote:
Yes I have full access to the folder. Under attributes
nothing is listed. I says it is a Microsoft Access
Database. I even had someone with Access 2000 try to
access and they got the same message about the format. I
even tried the repair tools in Access but continued to get
the same message. HMMMMMMM


It's beginning to sound like a corrupted file. Maybe someone else will
have a better idea.


--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math



  #7  
Old June 13th, 2004, 09:52 PM
Tony Toews
external usenet poster
 
Posts: n/a
Default Wrong Database Format

"Kentucky5" wrote:

I have a database that when I try to open it says that it
is the wrong format, is there a way to fix this so that I
can open the database?


The JetComp tool may be of use.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  #8  
Old June 14th, 2004, 02:57 AM
Van T. Dinh
external usenet poster
 
Posts: n/a
Default Wrong Database Format

1. How do you know it IS an Access database? It doesn't sound like you
know for sure ...

2. If is is in A2K2 or A2K3, you won't be able to use A97 or A2K0 to open
the database.

3. It could also be corruptions. See Tony Toews' article:

http://www.granite.ab.ca/access/corruptmdbs.htm

--
HTH
Van T. Dinh
MVP (Access)


"Kentucky5" wrote in message
...
Yes I have full access to the folder. Under attributes
nothing is listed. I says it is a Microsoft Access
Database. I even had someone with Access 2000 try to
access and they got the same message about the format. I
even tried the repair tools in Access but continued to get
the same message. HMMMMMMM

Thanks
-----Original Message-----
Kentucky5 wrote:
I have Access 97 I am not sure what version the

database I
am trying to open is. I even tried linking to the
database and that did not work or importing the data and
that could not read it either. Is there any way around
this?


Not if we don't know why.

If the database is from a newer version or is not an

Microsoft Access
database, you may not be able to open it.

Is this database on your machine or are you accessing

it via a network
connection? Do you have full rights (read, write, delete

etc.) to the
folder where the database is located? Try saving a

simple text file to the
same location, then open it and make changes, then save

it. Close the text
editor. Now re-open it and see if the changes are there,

now try deleting
it.

Try to find out what program and version of that

program was used to
create the file. Is it a MDB file or an MDE file or what?

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.