473,378 Members | 1,393 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Access not working (can't query or create report)

Hi!

In the company where I'm working there are 5 machines setup with Access
2003 and some with 2002. On all but one access isn't functioning
properly.Everytime someone tries to query or create a report using ANY
table, access claims that there were no fields in the table, but that's
not true.

Also it seems as if we are having some kind of language versions
conflict. They only have and ever had German versions installed, but
some dialogues in access appear in English. Not that it would be much of
a problem, but maybe it's a symptom related to the issue.

It would be really nice if anyone could suggest a solution.. been
searching for days now.

Maybe is there a fast possibility for wiping all dlls office is using
off the system and reinstall them?
Reinstalling office the normal way does not help.
The one system on which access is working fine, has the exactly same
version installed: Access 2003 with SP1, Access 2002 with SP1.

Thanks for any help!

Regards,
Max
Nov 13 '05 #1
3 2270
"Max Riedel" <no****@antispammmmmmmm.org> wrote in message
news:43**********************@newsreader.inode.at. ..
The one system on which access is working fine, has the exactly same
version installed: Access 2003 with SP1, Access 2002 with SP1.

Have you taken steps to ensure that the two versions can co-exist on the
same machine and run without error?

Keith.
Nov 13 '05 #2
Keith wrote:
Have you taken steps to ensure that the two versions can co-exist on the
same machine and run without error?

Keith.


Thanks for your answer!
I think I messed up my previous message.. I didn't want to say that both
versions were installed on the same machine -in fact there's only either
access 2002, or 2003 installed-, but that all the machines who have
2002 or 2003 installed, had office sp1 and respectively office sp3
installed as well. The only machine on which access seems to work fine
is one of the clients access 2003 is installed on. So the same errors
occur on all the other pcs and it doesn't matter if they run access 2002
or 2003.
Nov 13 '05 #3
Thnx to someone in another group the problem is now solved..
As suggested the problem causer was the AV software, that blocked VBA
Macros and therefore caused the wizards to misfunction.

Thnx for all your help!
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Joris Kempen | last post by:
Hi people, I know that the question has come around sometimes: How to open an Access Report using ASP and export it to for example RTF. I'm trying to implement the first method of David...
17
by: Jon Ole Hedne | last post by:
I have worked on this problem some hours now (read many-many...), and I can't solve it: In vba-code I create a table with Connection.Execute, and add some data to it. This table is saved in the...
5
by: Robert | last post by:
Hello Accessors I have some reports created in Access that are very good for what they do. However, it seems to me that when you are displaying information you don't need to print out that a...
2
by: Jonathan Goldman | last post by:
Hi- I have a relatively simple report that I open in an Access '97 VBA procedure, using the Docmd.OpenReport "rptName", acViewNormal syntax. The problem is that doing this usually crashes...
9
by: Colin McGuire | last post by:
Hi, I have an report in Microsoft Access and it displays everything in the table. One column called "DECISION" in the table has either 1,2, or 3 in it. On my report it displays 1, 2, or 3. I want...
15
by: brettclare | last post by:
I have linked a large SQL Server table to Access, however 'only' 2,195,439 records are shown and are available to query. Can I increase the size (cache??)/number of records showing in Access? ...
3
by: StBond | last post by:
Hi everyone, I am new to Access and Visual Basic so things my be getting across a bit cloudy. I only started using VB for one week. I am having a little problem with the database that I am...
2
by: Dean Slindee | last post by:
Anybody written code in VB.NET to: 1) show a print preview window of reports already written and stored in an Access 2002 database; or 2) execute the print of a report stored in an Access 2002...
2
by: amith.srinivas | last post by:
Hi all, From a word macro in VBA, I am trying to create a report in access DB. The report is based on a query with a parameter. I am using Set rpt = Application.CreateReport rpt.RecordSource =...
2
by: Andy | last post by:
Hi guys I having a problem creating a report in Access 2003 project talking to a SQL database through and ODBC connect. After hours of trying things from Access Help, MSDN and Google I still...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.