Search results

  1. A

    SQL server express edition

    Hi Guys We have an application built in MS Access , we are now thinking to change it to web based app. So the backend will be changed to SQL server but as its licence is very costly so I gave my mangers suggestion of using SQL server express edition. Now I have some questions from my manager...
  2. A

    Open a copy of the Access application rather than the actual shared file

    Yes it worked great. Thanks Frothingslosh :)
  3. A

    Open a copy of the Access application rather than the actual shared file

    Gasman, I have tried the code and there are few things as below: 1. If the "fe_version_number" in table "tbl-fe_version" matches with "tbl-version_fe_master" then code works perfectly fine and the database gets opened. 2. If the version number doesn't match then the message comes up "Your...
  4. A

    Open a copy of the Access application rather than the actual shared file

    sorry to be a pain ridders. But thanks a million for all your help so far.
  5. A

    Open a copy of the Access application rather than the actual shared file

    Frothingslosh , What I need to know is the structure of the linked tables (field names ,data types etc...)? Hope it makes sense.
  6. A

    Open a copy of the Access application rather than the actual shared file

    ridders, I am still not able to open linked tables :( Though I can see everything else when I open the database by pressing shift. I can see all the code etc... its just the linked tables , I want to know the linked tables structure so can pls send the tables structure ? Thanks
  7. A

    Open a copy of the Access application rather than the actual shared file

    Yes Ridders, I used shift key as you suggested but still getting that error :( Can you remove the link in the table and send me the accdb? I will make them the link tables in my database. Thanks
  8. A

    Open a copy of the Access application rather than the actual shared file

    Gasman, coming to conclusion so early is not that good. I knew I had to amend the code but what I meant earlier was even when I try to open the table using shift key , the path error message is coming up.
  9. A

    Open a copy of the Access application rather than the actual shared file

    Thanks Ridders, I am getting the attached error message when trying to open the linked tables :(
  10. A

    Open a copy of the Access application rather than the actual shared file

    Hi Gasman I tried this link but when I try to run the FE Updater.exe file then it gives me "This program is blocked by Group policy, For more information, contact your system administration. "
  11. A

    Open a copy of the Access application rather than the actual shared file

    Hi Frothingslosh Sorry I didn't get it. As I have never used Batch file and access database together, just can't understand what do I need to do? Do I need to make any changes in Access database? What changes need to be made in the batch file if my actual accdb is stored in the...
  12. A

    Open a copy of the Access application rather than the actual shared file

    Frothingslosh, I have taken your code as below. This code is written in a module. I have created tables as you suggested in that thread, 1. Local table in access frontend: This table is called tbl-fe_version, this table has 2 fields (ID,fe_version_number) . ID has autonumber datatype and...
  13. A

    Open a copy of the Access application rather than the actual shared file

    Galaxiom, sorry what do you mean by distributing FE? At the moment I have asked users to save a copy on their personal drive and then start using it. SO whenever I make a change to the master file , I ask users to copy a new version on their drive and delete old one. Just wondering what else...
  14. A

    Open a copy of the Access application rather than the actual shared file

    Frothingslosh, don't we need to save batch file with extension .bat rather than .txt ?
  15. A

    Open a copy of the Access application rather than the actual shared file

    Minty, If I save FE locally on the users machine then whenever a change is made in the system then a new copy will need to be made on the users machine. Is it right?
  16. A

    Open a copy of the Access application rather than the actual shared file

    Hi All I have created Access application which is split into frontend and backend . There are around 1000 users who will be using the file. So instead of opening the shared file , I want to build a functionality so that when the user open it then a copy of it gets saved to their personnel...
  17. A

    API in access database

    Thanks guys. I will dig into it more to find out the possible options. :)
  18. A

    API in access database

    Hi Guys 1. To elaborate is it possible to migrate access frontend to XML ? I have heard its possible to migrate access backend to SQL server . 2. What would be the best option for a web based frontend? If we need to migrate Access frontend to web based , will a complete rewrite be required or...
  19. A

    API in access database

    Thanks Guys for all the information. As I discussed earlier my whole application is built in Access, I got these questions from my Boss: Q. What is the feasibility of getting Access products into an XML format, do you have ASCII text capability? Q. Does the above result in complete rewrite or...
  20. A

    API in access database

    Thanks CJ_London, I haven't used API before so just wondering is it easy to use ApI. My whole application(Frontend and Backend) is built in access . It records all the employees activities like Reviews,Meetings,absence,call audits,action plans etc...so do I need to use a different frontend and...
Back
Top Bottom