Punktum i database giver fejl

Kan du ikke omdøbe no. til no alle de steder hvor det optræder!~)

i dine forespørgsler kan du så ikke omkranse feltnavnet [no.]
måske virker det?

you could also make a view in SQLServer and giv ethe field name an alias

SELECT no. AS SillyNameToUse FROM ....

then link the VIEW instead of the table

Terry --> How do i link the view? Do you mean a Query as a view?

Spg --> Nej, det kan jeg desværre ikke da det er en firmadatabase i 9 lande med adskillige tabeller som linker til netop no.

Jesperfjoelner --> Forklar lige hvordan jeg gør det :-) for den eneste måde jeg ved hvordan man linker en tabel i Access er ved at stå i "Objects" fæltet "Tables" og højreklikke og vælge "Link Tables" Er der en anden måde?

:-)

Its a while since I worked with Access and SQL Linked tables but I'm sure that if you make a view (In SQL Server) then you will be presented this as a table in Access when you make a link.

>>Terry
You're right. Views are included.

thanks fdata, I thought so :o)

Still i don´t know how to do that. I don´t have access to the SQL Server. Isnt there another way to do it in Access?

You will need to talk to the person responsible for the SQL Server. Either give the field a valid name or use make a view. Thats your options!

another idea would be to make an Access Data Project which links directly to your SQL Database. But if you arent familiar with them then they can be a bit of a mouth full.

Ok! i´ll talk to the responsible! Thank you and have a nice weekend :-)

Good idea :o)

and a good weekend to all