Some advice needed please about Access transfer to a new computer

[tbjmobile@gmail.com]

You would need to allow macroes and possibly trust the location of the db?


Is it confidential?, you could upload to here? Compact and zip if large.

Thanks Welshgasman, it is confidential because it contains all the client details, but if you think it would help, I could make a copy of the db and strip all the confidential stuff out, replacing it with just a few dummy clients, property addresses etc.. If someone here wants to have a look at it I'm happy to pay a reasonable fee if that is allowed.

[Welshgasman]

You can make a copy and then run this function to obscure the data.
Randomizing Data for Posted db's | Access World Forums

No need for a fee, for me at least, and if someone offers to help for one, I would be wary TBH.

[tbjmobile@gmail.com]

Thank you June 7. I've looked at Micron's instructions. If my daughter agrees, and I'm sure she will, it will probably take us a few days.

[tbjmobile@gmail.com]

You can make a copy and then run this function to obscure the data.
Randomizing Data for Posted db's | Access World Forums

No need for a fee, for me at least, and if someone offers to help for one, I would be wary TBH.

O.k., thanks. Your offer and help, and that of the others is greatly appreciated.

[davegri]

If someone here wants to have a look at it I'm happy to pay a reasonable fee if that is allowed.

I've looked, amended and reposted hundreds of DB downloads over the years without any fee ever coming into question. I'm sure the regulars here can say the same.

[tbjmobile@gmail.com]

Thank you, davegri, as I said to Welshgasman, you're all very kind, but I try not to take anything for granted.

[tbjmobile@gmail.com]

Hello Everyone, we are very grateful for the offers of help if I upload the file. I have read Micron's article of how to do so, but of course we have to prepare first so I have a couple of questions about what you will need;
Do you need as brief a description as possible of the purpose of he db?
How many records do you need to assess the problem?
Would a few screenshots of the db working help, the one on the laptop that is near to failure?
That's all I have for now but please add to, or subtract from this suggestion.

[Micron]

hard to say how much info anyone would need. Maybe start from a general overview but expect questions, not only for clarification but for others to evaluate approaches/suggestions that they might be considering. The number of records required is also fluid as it depends on the problem. Make sure that you can replicate the problem with your test db. At the risk of being too cautious I'll say it again - do NOT run that code on your original db or any db that you might ever need for backup. Make a new copy, give it a name that distinguishes it from any backup that you need to keep and go from there. Also, make sure you post how to replicate the issue. It would be nice if in this copy you removed any protections such as hiding the nav pane, re-enable disabled shortcut keys, remove any password protection (unless it is relevant to the problem), etc.

EDIT - if the db is split, don't forget to upload both parts.

[tbjmobile@gmail.com]

O.k. thanks Micron. I'll start work in the morning in the most logical way I can think of and we can take it from there. I don't know what split db is so I guess I would do, if it was!

[Micron]

Every db should be split. Forms, reports, queries, modules, code should all be in the front end (FE) db. The tables are in another - the back end (BE) and the fe is linked to those tables.

[Welshgasman]

Every db should be split. Forms, reports, queries, modules, code should all be in the front end (FE) db. The tables are in another - the back end (BE) and the fe is linked to those tables.

Tell that to a user over in another forum. He is now trying to make different dbs from his one db which is not split.

Some days I create 20 or more objects, which is why I am now dealing with more than 12,000 objects.

:-) roflmao

[tbjmobile@gmail.com]

Hi again, Everyone, I should be ready to upload the files at some stage tomorrow, so a few questions please;
The overview is a .txt file, shall I send it seperately?
Same question about a folder containing a few error message images (not big files) and then the db which is now about 4.5MB.

[Welshgasman]

Compact the DB and zip all your files into one zip file would be my suggestion.

[tbjmobile@gmail.com]

O.k., will do.

[Micron]

Maybe the text file could just be a table with a single field that is a long text (memo field). Or you could upload both.