RE: Append Query Unable To Display Link List Tables

I suggest doing so for testing purposes. That way you could eliminate your PC
as the problem.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"hspgapsemc" wrote:

No because these files are not shared with any other computer.


"Jerry Whittle" wrote:

Have you tried opening the databases with someone else's computer?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"hspgapsemc" wrote:


All the mdb files I am trying to work with are in the same folder. When I
want to look for a 2nd database, Access no longer looks within the same
working folder as it did before. It now defaults to:

C:\Documents and Settings\HP_Administrator\Application Data\Microsoft\Access

When I browse and open the correct database, there is no list of tables--it
is just blank.

I converted this database to Access 2003 from Office 97 last year and it has
been working fine until today.

I also noticed that for some reason my entire folder was marked read-only.
I just corrected it, but still have the problem.

I installed the SP3 Hotfix today, but my problem is not solved.

Any suggestions?


"Jerry Whittle" wrote:

Are you saying that you are attempting to link to the tables in the other
folder or doing something else?

Do you have read, write, create and delete permissions to the folder holding
the other database file?

Has someone converted that database to a different version of Access?

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"hspgapsemc" wrote:

I am trying to run an append query, both new & old without success. It just
started today & I have not made any changes to my Access Options. When I
want to append to a table within the same database--no problem. When I want
to append to a table from another database, the default folder location to
find the database has changed. When I browse and indicate the correct mdb
file, the list of tables does not appear--the pull down list is blank. I
have compacted & repaired without success.
.

Relevant Pages

  • RE: Append Query Unable To Display Link List Tables
    ... Jerry Whittle, Microsoft Access MVP ... Keith Bontrager - Bicycle Builder. ... All the mdb files I am trying to work with are in the same folder. ... When I browse and open the correct database, there is no list of tables--it ...
    (microsoft.public.access.queries)
  • RE: Troubleshooting Errors with Access 2003 Database
    ... All users have the same priviledges on the folder. ... Jerry Whittle, Microsoft Access MVP ... access the database tables. ...
    (microsoft.public.access.gettingstarted)
  • RE: Report Query
    ... Jerry Whittle, Microsoft Access MVP ... Now, with that being said, short of rewriting my database, can anyone suggest ... I highly suggest getting some relational database training or reading ...
    (microsoft.public.access.queries)
  • RE: Problem with new database
    ... privileges to the folder holding the backend database file. ... Jerry Whittle, Microsoft Access MVP ... employees, work locations, and various bits of information. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: folder security nightmare to allow .ldb file deletion
    ... I thought the file would inherit permissions from the folder? ... Depending on the user permissions, MichKa has a solution to that issue at ... Doug Steele, Microsoft Access MVP ... "If you plan to share a database, the .mdb file should be located in a ...
    (microsoft.public.access.security)