Databasen "" kan ikke åbnes. Det er måske en database, som programmet ikke genkender, eller filen kan være beskadiget.

try compact repair.

http://office.microsoft.com/en-001/access-help/compact-and-repair-a-database-HA010341740.aspx

Opret en genvej til din database, gaa i egenskaber og tilfoej mellemrum /compile til stien.

Brug genvejen og se om det faar orden paa databasen!~)

Jeg kunne godt køre en compact repair, og det vil jeg også gøre i morgen, men databasen er helt ny. Den er bygget op af data fra tabeller der linker via odbc. Det sker ca. hver gang jeg bygger databasen.

Det burde ikke være nødvendigt, eller tager jeg fejl?

" Det sker ca. hver gang jeg bygger databasen."

Do you mean "compile"?


Its shouldn't be necessary to compact/repair the dB all the time so something is obviously wrong.

"Jeg får følgenden fejlmelding når jeg forsøger at køre eller gemme forespørgsler i min database"

How can you do this if you cant access (get into) the dB?

Are you using some other programming language to access data in the dB? If that's the case then its here you need to look for the problem I think.

No, I don't mean compile, there is no VBA code to compile in the db. I have som querry's taking data from some linked tables building some new tables.

I do get into my db. That's what's strange.

I get the message when I try to do somthing with the db, like saving something or running a querry.

Some times i get the message:

"Databasen "aggregate type" kan ikke åbnes." I don't know what "aggregate type" meanss.

aggregate http://www.thefreedictionary.com/aggregate

I guess your grouping records and maybe summing (adding) values.

When you get the error is it when doing operations with the linked tables?

Its years since I played around with linked tables but I seem to remember that problems can occur. Data types are different so can give problems.

What database type are your linked tables from?

I do both. Most of the querrys include some linked tables. They come from an oracle db.

I have no access to change anything in the linked tables.

Anything that can be done?

Not sure if it will help but try looking at pass through queries.
It will help in performance too.

If your not working with great amounts of data and only reading then maybe copying the required information to local tables and working with these could help.

Otherwise I think you will have to try and find out if its a specific data type from Oracle which is causing the problem and try and convert it in the query before using it in aggregates.

I don't know what a "pass through querie" is. Could you explain it to me?

I'm trying right now to copy all the linked tables to local, but some of them are big so it's not a good solution. It taks to long time, but if it works, it works.

how would you look for the datatype thats causing the problems?

Here's an article on passthrough queries. I guess your using a newer version of Access but its very similar.

http://www.mssqltips.com/sqlservertip/1482/microsoft-access-pass-through-queries-to-sql-server/

The problem may have nothing to do with  datatypes.

I'd start by making a very simple  query to see if I can provoke the error and slowly add fields/calculations until the error occurs.

Thanks for the link. Sadly it seams like I can't make a passthrough queries to my oracle db. I behind Citrix and a lot of security. Would I be right to asume that t-sql will only work for a sql-server and not for at oracle server?

Thanks for your help, at least I have learned a lot.
Drop an answer.

If you can link the tables from the Oracle dB then you should also be able to create pass-through query. Its not that difficult :-) Give it a try some time.

thanks.

missed your question regarding T-SQL, sorry.

http://en.wikipedia.org/wiki/Transact-SQL

Just Microsoft and Sybase which in fact Microsoft originated from.

You can't use T-SQL in your Access dB but you in your SQL server.