Search results

Thanks for all the insights, I suppose I was tryng to determine the point where access becomes useless over a LAN. For example just how many users will access (split) really work comfortably with (10,20 or even more). Reading all the comments above I am also beginnning to see that access may...

Hi all, I develop reasonably complicated network solutions with a split database scenario, Typically My clients have 4-5 users. This works fine and performs well, however I am constantly being reminded to upsize to sql server everyere, on websites etc. I have a fear that my databases may not be...

Data Files do you work on their live backend file or do u give them a new one and import their data?

Hi all. I deploy runtime split end solutions to my clients. When updates need to be done to the front end I just give them a new runtime front end and it will reconnect to the backend file via code. I am not sure how to go about updating the backend easily or maybe the backend shouldnt require...

Hi, I have searched for days and cannot seem to solve this deployment problem. I know this is a popular question but cannot seem to find an answer. Basically I want to deploy a custom Icon with my runtime and have the runtime application relink to the new icon path. I am beginning to think this...

Thankyou all for the help, the dmax function as a default value expression seems to do the trick perfectly. a dlookup function to validate also works a treat. Thanx again

I have a field that needs to be autoentered(defaultvalue) when a new record is added. This default value is quiote awkward and I simply can't get it to work. The field is "Ref_No" in a table called "Registrations". To simpliy this example I will use one other field only. "Department" In the...

Hi, I have a split database front.mdb back.mdb Does anyone know how to run the compact command from the front end interface that will acually compress the data at the back?