Search results for query: *

Hi everyone, I finished converting form MdB to ADP frontend with a SQL Server backend. I put the FE on a WAN that users access through a shortcut on their desktop. The problem is that the ADP takes a long time to open for others, on my computer it is relatively fast. Is this normal? How...

Hi everyone, I finished putting all of my access tables into SQL Server 2000, i have all my procedures set, now I want to make an .adp front end, because im told this will allow multiple users into one database without corrupting the file, which has happened several times already. users will...

Hi, I have a table with duplicate records of each time a student took a test. I want to group each student into a single record table, but I need it in a specific sequence. If they ever have a Pass then use that, else if they did not pass use the last not pass, else if they never took it...

Hi everyone, Im trying to go from Access to SQL. I want to set up a "macro" type procedure that does several operation. Update a table, drop a table, and create several other tables. When I use the stored procedure in SQLServer I can only use 1 Go. Does this mean I have to do one for each...

I am trying to copy data from one table to another, but the tables have different variable names. So I have a table named LayoutMatrix that has the names from one table that correspond to the names of the other table. Ie. ID, OldName, GlobalFieldName. I cant append it using SQL, but sometimes...

Hi everyone, Im am making a table programatically and appending to it from several tables in the database. The problem I have is that some fields are set to null due to Type Conversion, how can I find what these fields were, ie.e create a Paste Errors Table similar to the one Access creates...

I have a file dsn that I use to link SQL tables to access, the problem is that I Saved it on say L:\Data which is how it looks on my computer but others have different paths on their computers. I know the UNC path, but when I use this to create a file dsn it says fiel error #566. Is there a...

Hi, Im trying to make a table using fields names, type, and size listed in another table named FileLayout. I get Type Conversion Error on the line where I create the fieldtype. Should I use something instead of String?? Function CreateTable() Dim db As Database Dim rs As DAO.Recordset Dim tdf...

Hi, I have a table with 200 fields for which I want to add descriptions. I have another table with two fields. FieldN and FieldDescription that lists the descriptions of each field in order of apperance. Is there any code out there that can allow me to do this easily? Thanks in advance...