Search results

As a matter of interest @isladogs my build version is 19029.20184 which was released on the 12th August. I didn't apply it so it must have been an automatic update. In that respect why haven't I got the latest 20208 which the article says was released on the 19th? I'm a bit wary to update myself...

I mentioned I was using 2016 but not the build version which is as you rightly point 2507. I'll read the links which hopefully tell me how to apply the fixed build. Do you know when this "went wrong" as I'm sure the linked table manager worked not more than 2-3 weeks ago

Incidentally, I've just tried to run the database documenter and got these 2 messages when I've switched tabs Could this have something to do with it?

OK the connect property has no value. Madpiet says it, or access think it's a local table. It is not so how can i rectify that

t thanks, i'll take a look

done that to both front and back end

It's not in the navigation pane where I'm not seeing them. It's when I click linked table manager

i don't know how to do it. are you suggesting writing code? the link is there as i can display the contents in the FE and if I hover my mouse over the table in nav pane I can see the link.

On the external tab the only access to click is export. There is one under new data source which i've tried already. I tried it on one file and it creates a linked table with a suffix of one. THat doesn't appear when I try the normal method either

Not unless I've hidden by mistake. It worked a week ago. But I'll double check

no they were originally linked (and still are), I just can't see them to relink

Yes they do and if I hover my mouse over them I can see the link. If I open the link manager it shows me nothing. If I select all (from nothing) and click the re link box it throws up a window so I can get the location of the linked table (if I knew it). This was working a few days ago as I put...

I'm using access 2016 btw

I'm working on a small database that has linked tables to effectively 2 back ends I went into the link table manager to not only check what's linked to what but to relink everything as well Lo and behold the list of linked tables is empty I can display the contents of each table so they are...

Thanks to everyone's input. I went down the MSysQueries and Objects route and got what I was after

Thanks to everyone. I've used the long hand method!

Yes I am talking about the wizard *I hid that fact in the title!!). I have a date and time field for example. The report has a control that just about manages to get the month and a "/" in.

for everyone else that's suggested things I will take a look at your advice but at the minute I have to finish the current project before I start investigating whether or not the other queries are using the to and from dates correctly

you may well be right. I actually didn't have the + 1 and it wasn't working if the date was equal to the to_date. After some investigation i noticed the date had the time in it as well so I had to add the + 1 in