Recent content by iancampbellian

database size ensure you don't have any bitmap icons of a large size. When embedded the size of the database will grown substantially. as pat says you also need to compact. after 97 there is a setting to do so before the database closes.

97 and 2000 yeah you can use different front ends...just ensure the back-end is 97...you can convert the 2000 backend to 97 (tools menu)

out of memory two things to do. 1. improve the query so it is only asking for the records you need (i.e. filter it) 2. up the VIRTUAL MEMORY setting on your PC's.

help please i'm trying to give users temporary admin security permissions so they can relink (via a button) to different back end databases. i've created a connection but can't get it to work if i try and refer to the access workgroup security file. can this be done? if so what is the...

outlook express save (export) the query in access as a csv txt file. import from outlook express the csv text file.

kia ora don't know if this is want you want but.... you can use a hyperlink to email: e.g. mailto: jonah.lomu@kidneys.com the link will open up your default mail client

excel import crash some suggestions. ensure the access file is compacted and repaired before the import. test importing on a test excel file to ensure it's not the excel file itself. are you importing using the menu, a macro or vba code? windows xp is based on windows nt which is derived...

access shortcuts you'll find that users with multiple versions will have their msaccess.exe files in different folders. in the shortcut you send them you can tell it which version to fire up. the first fires up access xp/2002 (office10) "C:\Program Files\Microsoft...

linking tables if you're changing the back end data lots of times you'll probably want to code it with vba and link it with a command button on a form. It also allows users to link easily to different backends if you wish to give them permissions to do so. to summarise, the code should bring...

my question http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=49373 pat here's the link. i've used system.mdw and db1 for testing purposes. hope to hear form you. regards

agree with your comments re design....quite right to normalise. unfortuantely it can be a bit tricky to explain to new users in a forum like this. sometimes quick fixes are good until you learn such concepts. have you checked out my question re linking / workgroup files and security in the...

dap try creating the procedure before you convert it. best idea for users new to scripting.

known conversion problems some problems with recordsets....need to replace "." with "!" e.g. forms.[field1] needs to be forms![field1] have you compacted and repaired and compiled the code again? generally conversions go quite smoothly.

delete using an update first try doing an update query then a delete query as i suggested...it works....forget about inner joins etc etc...you'll tie yourself in knots.

delete solution create a new field in the table with the records you want to delete...call it Delete and make it a yes/no type. then run an update query on this table to make the records you want to delete equal yes (-1) then delete the records with a delete field =-1