Search results

Hi Learn - your question is a pet project of mine You are asking where do I get something like MS Access except to create web databases? You are finding it difficult because.... it pretty much doesn't exist. (there are programs that are best described as 'getting there' but event management is...

NG - really great idea I try to practice humility not because I enjoy it but because I selfishly believe that it is the best way of getting better. I am a strong believer in the idea of Categorical Imperative - ie that there is an optimal solution or group of solutions that are independent of...

...... Thanks

Access front end with link to SQL Server - Where are the Queries RUN? I probably should know this but If you have a series of ETL queries , written and stored in an MS Access front end linked to SQL Server. If you run a script of those queries - what engine performs the heavy lifting - are...

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...