RE: Append Query Unable To Display Link List Tables


I tested my mdb files on another computer & the append query works. Any
maintenance suggestions for my regular PC would be helpful. For instance,
can I repair Access, do I need to reinstall Access, or could it be a general
PC problem??? FYI--I ran an append query today on my regular computer
involving 2 completely different mdb files, and I had no problem.

"Jerry Whittle" wrote:

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: suedo ULS
    ... The MDE files are in the same folder, ... > structure, the mdb files are in the same folder, 3 levels deep. ... > my own desktop with a test database, but don't know how to implement in a ...
    (microsoft.public.access.formscoding)
  • Re: about mutiple databases
    ... > reside in the same folder or not... ... >> I have a great problem of the database management of my project. ... have many database (.MDB files) with same data structure ...
    (microsoft.public.vb.general.discussion)
  • Re: about mutiple databases
    ... reside in the same folder or not... ... Chris Hanscom - Microsoft MVP ... > I have a great problem of the database management of my project. ... have many database (.MDB files) with same data structure ...
    (microsoft.public.vb.general.discussion)
  • about mutiple databases
    ... I have a great problem of the database management of my project. ... have many database (.MDB files) with same data structure ... (assuming that all .mdb files in the same folder) ...
    (microsoft.public.vb.general.discussion)
  • about multiple database
    ... I have a great problem of the database management of my project. ... have many database (.MDB files) with same data structure ... (assuming that all .mdb files in the same folder) ...
    (microsoft.public.vb.database)