Search results

Just a hunch but don't use * in the replace string. The code builds an SQL updated query and * is seen as a wild card which will do something very weird probably in an update query. How about change PINK to BLUE

and here's a function to randomise a field if you need it - not sure if this randomises two records of the same string the same or differently . I guess you might want to test that. (Looking at its use of the Rnd Function I think they might be different which may make it unsuitable) Public...

I did a quick tinternet search and came back with this. I would probably create a table to hold all the field names in and with the recordset write the table names to the table. Public Functions ShowTableFields() Dim db As Database Dim tdf As TableDef Dim x As Integer Set db = CurrentDb For...

I think this is the key key point. Users should NOT have access to the database file. (backend)

Security is tricky because you are trying to prevent access to something whose whole point is to give access - that's the oxymoron. I think provided you take into consideration the characteristics of MS Access it can be made perfectly safe. There's a lot you can do with RDP - Configuration...

Good luck - re creating stuff from the ground up is an excellent way to make some of those improvements in design and particularly structure you forgot to make the first time round. I've redesigned one system from the ground up and it was well worth it. I presume you can at least get the data...

Yes it can be done. Split the database https://www.youtube.com/watch?v=u2IFTHgZQzg Put the back end with the data on a SAN somewhere Place copies of the front end on each local computer and then link to the the file on the SAN server with the database back end and link the tables.

Hmmm so IT are telling you they have the correct privileges or you absolutely have seen it yourself? Firstly if you have control take a copy of the front and back end and set it up on a local computer and see if it works as expected. If it does then I would suggest this is a strong suggestions...

Try something like this: CurrentProject.Path will identify what location the db is in eg MsgBox "the Current location of the database is " & CurrentProject.Path Have some kind of IF switch on database open that tests whether CurrentProject.Path is what you wish it to be including its name...

Its a major advantage of MS Access as a platform that there is a huge amount of experience out there. All these people poring over it means it must be one of the best understood platforms out there. PS if you are wanting consultancy you could do worse than look to someone of the luminaries on...

Ridders - yes that was me - if an application is really getting business critical I would suggest you get a professional in to take a look over it to see if there are any glaring mistakes. Your methodology sounds robust but having a second pare of eyes over maybe your code may bring up something...

Andy and Boer - congratulations on creating what sounds like excellent systems. The only other thing I would add is I like rolling backups for my development copy. So I can click a shortcut on my desktop and it will give a backup as for that second or minute. I have only had a development copy...

Glad you have identified an option to improve things If you do need to do automated compacts and repair here's how I have done it in the past. rounduptheusualsuspects.org/?p=1386

Unfortunately I've seen Brent Ozar a well respected SQL DBA / developer completely criticizing MS Access, unfortunately for the wrong reasons - (he completely ignored the front end form designs available in MS Access). It was disappointing because he seemed to be trolling another forum at the...

She is talking pure nonsense MS Access engine is the 7th most popular database engine in the world https://db-engines.com/en/ranking and it looks from that source that it is actually getting more popular. Visual Basic ranks amongst the top 20 most popular languates in the world...

It is called SQL Database More information here Link to SQL Database information It is quite easy to get lost in SQL Azure as there are SO many options. Microsoft are offering various FREE introductory offers at the moment. It is worth signing up for something - probably best in your own time...

OK you sound competent to good at access (apologies if I am underestimating you) I'm going to suggest some steps for you probably in this order. This happens to have been my journey as well. Download SQL Server Express and get it installed somewhere on some kind of network would be good but...

There is one further practical consideration for making ID field integer Autonumber primary keys have to be integers. Plus if you want to use referential integrity I think access requires integers. Unless forced if you want a long life just use integers for keys :rolleyes: The students and...

I would definitely research single azure backend linked to the required number of front ends. Creating your own transfer protocols probably is for the confident and interested. A developer SQL Azure database starts at about £5 month this should be all you need until you have the principle up...

I changed unstable to - complicated and confusing to put together. Undoubtedly a measure of my knowledge - I've only dipped my foot in web applications development. I find web form design more intricate and tricky there are less people about to ask questions and error trapping is sparser...