Where has the content gone?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with Access 2003. When I tried to make a query/report with help
from the guide, it did not show me the various field content of the table as
I am used to. I am working on a Danish version, however this operation is in
English language. I have tried to make an error recovery and update, but I
still get no fields to play with for my query/report. If i do not use the
guide, I can get all the fields I want. How do I get my guides to work again?
I can of course use the design mode, but the guide is so much easier/faster.
I look forward to hearing from you... :-)
 
Hi,


The "Field List" is filled by Access when you open the report (in Design
view). If you change the table, or the query, the list is not "requery"
automatically. Try to re-open the report to get the most up-to-date list in
the "Field List".



Hoping it ma help,
Vanderghast, Access MVP
 
Hi and thanks for your fast reply.

Unfortunately it did not help me much. I have tried to modify, reopen and a
lot of other stuff. The result is still: when I try to use the guide for the
query, I get no list of fields, when I choose a table. In contradiction to
all the versions prior to 2003 I have worked with. It is of course possible
to make it manually, but it is kinda annoying that this is malfunctioning.
Therefore, if you - or others - have alternate ideas to solving this, I'd be
most glad to hear about it.

:-)
phanto

"Phanto" skrev:
 
Hi,

I think that I may have found the error source, but not the solution:

I have been playing with security settings and has a mdw-file. I am working
with the database at home and at work. At work I succeeded in getting the
mdw-file deleted and I got the fields back. Unfortunately it has not been so
easy at home. Is there some way I can nuke the mdw-file so I can get back to
normal. I have tried to delete the file, but it keeps coming back!

Would it help if I killed the entire office package? or are there other,
more gentle solutions?


Best regards

phanto

"Michel Walsh" skrev:
 
Hi,


The security is always present. To "make it transparent", define a User
Admin, no ending s, and supply an empty password for that user. You can add
restrictions, or remove them, for that "user", in fact, any user that can
then log into your database, without supplying any credence.

Other users would still work fine, if they log into the database with
supplying their user name and password (probably, then, with greater access
to the resources than the user not supplying any id).



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top