where does access save files and in what format?

[goosh]

i need to know in what format access saves files and where it saves to so i
can find a file i may have deleted. thanx whoever helps

 

[Rick Brandt]

i need to know in what format access saves files and where it saves to so i
can find a file i may have deleted. thanx whoever helps

It saves then wherever you tell it to. "My Documents" is likely the default
location. It creates files with an mdb file extension (if that's what you mean
by format).

 

[Dirk Goldgar]

i need to know in what format access saves files and where it saves
to so i can find a file i may have deleted. thanx whoever helps

Access database files usually have the .mdb extension -- unless you did
something unusual with yours, that's the file extension to look for if
you're trying to track down a database that you've misplaced. Bear in
mind that a single .mdb file may contain many tables, queries, forms,
reports, macros, and modules, so if you've accidentally deleted a
*table*, that table had no existence outside of the database that
contained it. If you *have* accidentally deleted a table, you may be
able to get it back, if you haven't closed the database yet. If you've
closed the database, though, only a data recovery specialist is likely
to be able to retrieve any data from the table -- and then, only if yoiu
haven't compacted the database.

Access doesn't create .mdb files in any one location. When you create a
new database, it prompts you with a browse window for where you want to
create the file, and what its name should be.