Search results

I ran an append on the linked table and then dropped the table as suggested. It works well. For reference I think that Access preserves indexes... when importing from sql serever, although I think theres a limit to the number of indexes access can cope with.

Hi There, I have to manually Import some sql server tables that are hugh and i want to atomate the process. I have some code for attaching DNSless tables but really i need to import them. I tried to run make tables on the attached tables but the performance was dire. Importing the tables proved...

Firstly, i am a sql newbie so apologies if this is an obvious answer I need to joing a table to another but unfortunatly theres no one to one relationship. What I would like to do on the table with mutiple records is is group by the key and sum by amount . I then want the query to select the...

Does anyone have a vba function that replicates excels NormSDist. using the inbuilt excel function is slow and cumbersome when trying to update 1000s or records. i manged to find a vba equvilient for NormSInv but not NormSDist. Any help is appreciated

Can anyone reccomend a piece of softwear that will assit me in drawing a schema of an access database. at the moment I'm trying to use the reverse engineer function in viso but its very difficult to master. I cant resize any of the shapes and its difficult add not select queries. Any help isa...

Thanks for your help boblarson. The link proved useful.

many thanks for the help chergh. where would I find details on what a bubble sort is? thanks again

Does anyone know how to do this. I need to pass three numbers to a function in VBA. eg 4,4,6 The function should look at the lowest two numbers and and return the highest. if the lowest two are the same it should return that value. 2,3,6 would return 3 4,4,6 would return 4 Any help is a...

Thanks. Simple but effective

Hi there, it must be friday as I'm drawing a blank. I have a function that passes three integers to the function eg 2, 5, 6,. i need to extract the max eg 6. any ideas?? Many thanks

perfect, Many thanks .

Below is a table that I want to look up from a query. Basically I want to look up a value (e.g 3.56) and find which PRA it fits in so in this case 3.56 is between 3 and 6 so the value returned is 0.7. Where it gets complacted is that the 3.56 is generated on the fly in the query. Can I use a...

I know that this could open a can of worms but is the above statement true. I have always avoided using delet and append due to database bloat. I know its more difficult to set the field types in a make table query but it means that the database doesn’t need to be compacted nearly as much as...

i have just taken over I have just taken over some database which have a load of tables and queries that I suspect are no longer requirer. Is there anyway to see when a table or query was last USED in a database?? Any help is appreciated

I guess what i want to do is import a file and automatically know how many blanks are in each column

As part of my job I am constantly comparing files from a production environment against those from a UAT environment. The checks are generally the generic before I reconcile the monetary values I check that the static data population is the same. Basically I import the files into access and then...

Thanks Doc Man. The reason i need to set up a worgroup is for the purpose of user recertification (SOx 404) . I need to assign only a small group of users who can access the database. Disablining features of the database without a workgroup means than anyone with access can open the database...

I have searched and searched and your right, Its all covered here. The trouble is I still can't get the thing to work and I'm going to fail an audit point tomorrow. What I did was. Create a workgroup (i lose the admin account when I do this as it defaults to my xp login) Secure the database...

Hi there, I'm trying to put in place a workgroup and I'm struggling with it at the moment. I created a seperate workgroup and have a command line short cut to it. When I try to add a user to the admin group permissions it works fine except that I can't open any of the forms in design mode. It...

Does anyone know if its possible to save screen prints in a table?