Search results for query: *

Hi Laura, I am afraid that my SQL Server knowledge is limited. I was able to create a data connection using the ODBC driver for SQL Server Db. This links some tables to my Access 2000 front end and I can now read and write data to the tables. However, this connection does not allow me to...

Thanks PHV, FINALLY! I see it. Thanks for your perseverance with me - I must be going blind in my old age! Very much appreciated. Regards, PaulG. "God is a DJ Life is a dance floor You get what you're given It's all how you use it

Hi PHV, Yes, External Data->Link Tables is what I used to link the SQL table to the fonr end but I can't see any checkbox for remember password during the configuration of the link. Can you actually see the checkbox in Access 2000 when configuring the table link? Regards, PaulG "God is a DJ...

Hi PHV, Is the Linked Table Manager the one found in Tools/Database Utilities on the Access 2000 main menu toolbar? If so, I can't see a remeber password checkbox there. I also can't see one in the link table dialogue itself. If you can point me to it I would be very grateful. Regards...

Thanks chiefman, I'm hoping to keep the VBA approach as the last resort. All I need is a stable connection to a couple of linked sql tables which I can just run some queries against without having to re-enter the password each time the front end starts up. I know the VBA approach will be much...

Hello All, I have a problem with an Access 2000 front end which needs to take data from an Access 2000 Db and pass it to a remote SQL Db. I added the SQL tables by creating an ODBC Data Source and then using it to link SQL to the Access 2000 front end. This works fine and I can read and write...

Frink, Thanks for your thoughts on this question even though it is quite aged now! I ended up implementing a similar approach but instead created a completely separate database instead of an empty file in order to track sync requests. Here is how it works. Remote user A logs in to the...

Silas, Thanks for that but I would have to set the flag on the Master Db so the other slaves could see it. However, I am not sure that one slave could read the flag on the master whilst another slave was synching with it. We would run into the same problem in that the master will probably not...

Tim, Ok here is the code which I mentioned. Some of this code I have taken from various points on the net and other sections I have actually coded myself. There are probably better alternative ways of doing all of this and I am sure others might want to advise you as well. However, all of...

Hi Tim, Yes, there is also a sync button that the user can click at any time in case there are updated store or contractor details which need to be pulled down. So you could have the user initiate a synch each time they log onto the network. However, there is an alternate approach. For my...

Tim, I have exactly the same sort of set up which you are describing. In that I have a split mde front-end with all the forms and queries etc. I also have a backend with a master on a file server and replicated copies on the PCs and therefore local to each front end. I have done this in...

Hi pelagic, Just re-read your question. Only PROPERLY this time! My answer only works for an Access form of course. It looks like you are trying to pass a value from a VB form which I don't have a clue about! Sorry for wasting your time mate! Regards, PaulG

Hi pelagic, Another way to do this is to place an unbound textbox in the header of the report and reference the textbox on the form directly. This will work fine as long as the form with your textbox on it is open at the time the report is printed or previewed. So for a textbox called txtName...

Hi votegop, There are 2 reasons why I have a replicated "local" back end. The main one is a performance issue in that when users are hitting the master back end directly the whole thing runs too slow for their liking with the order creation process just taking too long. I've looked...

I have a split Access 2000 Db with a front end on each pc. Also on each pc I have a local, replicated copy of the back end. The master back end is on a file server with a fast(ish) connection to the networked PCs. Each morning when a user logs on at their workstation the front end creates a...