Recent content by SparkByte

Yes I had found several table relinkers but non deal with ODBC linked tables. Specifically SQL server client version 10. I found Peters Software where he has TableLinker as a free download. This is close and can handle ODBC linked tables. I think that with a few mods it will do what I need...

Figures just after I 'clean' my old files. I had a sample MDB that had a table and a module that you can add to an exist mdb/accbd. Once added to your front-end. run the module to add all the linked tables to the LinkedTableList table (for lack of its real name). The table list held...

I know it has been a while since you posted this question. But here is a script I put together from SEVERAL examples on the net that you may be able to modify or make use of. To use it LinkAllTables("SQLserver", "MyDatabase", True) It will get a list of all the user tables in the SQL...

I need a way to determine if the SQL native client is installed on a workstation and what version so that the ODBC connect string can be adjusted to meet the workstations config. Does PC have SQL Server client? Yes -----> What Version -- | --- Connect using to Installed SQL Client No ------>...

This took a few days of playing but I finally got it working. You will need to use this code in a Print Button on your form. Change the strReportName to your report. Change the constant for the printer to your desired printer. ' Set Default Printer to the Windows Default Printer Set...

Anyone know of a way to validate an email address against the Exchange GAL? I have a need where only requests from "valid" emails can be processed. In this case a 'valid' email is one that is listed in the Exchange Server GAL. And yes this is VERY big. Requests for information come in from...

Sorry bad Discription after rereading. So say John Smith calls in and requests XYZ documents, these documents are of XXX type so they would be a Track 2 request, which means that there are 7 checkboxes that could be selected depending on the type of information they need out of the requested...

I have just inherited an Access application that no less than 3 other people have made major changes to and I am trying to clean it up and move the data over to a MS SQL backend. So far I have modified the column names to conform to standards (no column names like [Delete]) (Not joking)...

Thanks for your help. I found the answer. http://support.microsoft.com/kb/304179 John Fuhrman

Well I believe your suspiian on #2 are correct. I am at a loss as to why though. The account used to attatch to the backend SQL server has full sa priv's. Strang thing is that the ADP file connected to my SQL 2005 and SQL 2000 servers both behave the same. I can't add records to the table...

I have a "New Call" form that works just fine in the original Access Application but now that it has been converted to an ADP (Access Project) I cannot find a way to get the form to start on a new record. I have tried Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec 'Startnewcall_Click...