Search results

See my response to Gasman. In correcting the code - I found I had a typo in myBackEndDB name that compounded the debugging :cry: After correcting the typo and the code the link now points to the path where I was debugging the code. Looks great and I believe it will do just what is required for...

Oops I did change it in the call to the function missed it in this part of code.

sxschech Thought the code was working when I copied the FE and BE to a different location but then when I deleted the old BE, I found it wouldn't work. I used msgbox to try to figure out what was occurring . The problem seems to be in this portion of code. 'get tables in back end database...

ty DBguy I have booked marked that link

Thank you sxschech. I will try this, can see a couple things I am going to have to learn. :) I have never written code in access as a "function" procedure a new learning path:giggle: keep me occupied while I am locked away from all the COVID-19 creatures out there ! Where do the last lines of...

:giggle: Lifes too short not to be able to laugh at yourself. In my mind I still look a lot like your avatar ;).

I haven't had a chance to investigate prior suggestions but this looks like an elegant solution that might work to automatically solve the problem. If you could supply further code I would appreciate. I am assuming this would go in "on Load" of my main form?

Gas I will also look into Pat Hartman's solution, thamks. Regards Bill

Yes! that's my concern. Mick I will investigate your templates and see if I can implement a solution that I can handle :) Regards Bill

Thanks Adam, I am not sure about expansion though, we battle to maintain our little sub branch numbers but we punch above our level :)

Well at the moment it is permanent in that it was my job as Vice President to maintain these records, this year the district branch decided to have "Database system" written in "YUCK" excel, which is great for what it was designed for, so many people with a little knowledge think its a database...

Umm well not so much the security as in deliberately wanting to hack, but there are people with enough knowledge to be dangerous in wanting to fiddle and not really knowing the consequences of the action. This association nationally been around for over 100 years , this year my branch...

After splitting the database I find that this is not a suitable solution for this application. Unless I am missing something, every-time the FE and BE are moved to a different directory, pc etc the tables links need to be updated everytime.

Just to make it clear this database is only going to be used by one user at a time on that users PC. The user is a member of an association so the database would be passed to whoever is elected to the position to maintain the records. So I can't see how a password would do the trick... I know...

G'day, I'm confused I split my DB thinking that it would be safe from users fiddling. I was shocked to find that the tables can be changed, if that happens the front end would/could have problems. What am I missing and what can I do about the tables?

Adam Well ty for your compliment "Forum Troll" :p I already have one to post, not sure if it going to be a "smart one" lol. Regards Bill

I did a little programming in my past employment, self taught. Been retired for 20 years and find I am not as sharp as I once was.;) I have been searching for information in the forum, currently I am designing an access database.:unsure: Regards