Search results

  1. E

    Access Database Backups (multiple)

    yes from what I can see each team had their own dev person and there databases that should not even exist. As I said steep learning curve as databases are new to me :D As for the locations of the databases I did a little cheat and in the space of an hour managed to collect every path of each...
  2. E

    Access Database Backups (multiple)

    I have recently made a career change and now work with access. With no prior exp this has been an intimidating 1st month :) I would like to create my 1st new db from scratch. I want to create an access database to manage all my critical database backups as currently we have around 2000+ on the...
  3. E

    Paid Membership ideas

    I'm new to these forums and to access as well. I personally would not have joined if there was a fee because I did not know if the forum was any good. If you are going to introduce a fee I would suggest some sort of initial trial to give people a taste of whats here. As for other ways of making...
  4. E

    Tip The Ten Commandments of Access

    great post. Actually quite handy too for the new guy (points to himself)
  5. E

    Macro Fun

    Thanks for the tip. After a while of reading managed to fix this. docmd.sendobject worked great - 10 points to you ;) Just thought I would put some closure on this post
  6. E

    Question ADO Connection string Fun!

    Thanks for your input. Turns out the server I was given to host the ASP was on its way out. I now have a new server and It is working fine. Wish It happened before I went through all of this :)
  7. E

    Question ADO Connection string Fun!

    Right... I can confirm that I have permission to the network location in the connection string. I created a htm page using the access page wizard to test the connection to the networked database and It worked fine. So I would have thought I am missing something in my connection string in the...
  8. E

    Question ADO Connection string Fun!

    well I have permission from my domain account to that location but I did not consider that the server hosting the asp page would need permissions. So that is what I am looking into now :) What can I say. Big learning curve ;)
  9. E

    Question ADO Connection string Fun!

    please ignore last post... It was a typo... my error is still Error Type: Microsoft JET Database Engine (0x80004005) The Microsoft Jet database engine cannot open the file '\\ukaccounts\accounts\Revenue\SYSTEMS_FINANCE_DO_NOT_USE_OR_DELETE\DO_NOT_USE\Tonys Corner\Product Control Backend...
  10. E

    Question ADO Connection string Fun!

    Morning! :cool: thanks everyone for your input so far. I can confirm that the connection string was indeed my first issue I can confirm that all local tests now work Now back to that nasty long unc path :) Woking 'adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source='c:\asp...
  11. E

    Question ADO Connection string Fun!

    hahaha :) Heres a chunck of the code I have included someof the connections I have tried and If they have worked. Hope this is clearer. <html> <head> <title>My First ASP Page</title> </head> <body> <body bgcolor="white" text="black"> Set adoCon = Server.CreateObject("ADODB.Connection")...
  12. E

    Question ADO Connection string Fun!

    I have been designing asp pages to connect to access databases to display information to users. This works fine on my local machine but when i point my adocon to network locations it does not work. I am 90% sure its because the network path contains spaces but I have been unsuccessful in...
  13. E

    sub on from

    holy hell... Im sooo sorry for posting before slapping myself ;) Thanks for the help and I am sure there will be many more posts like this..hahahan :D
  14. E

    sub on from

    I am still learning access and have put together the following sub on a combo box. When a user changes the value I would line another field to change value. Only problem is that its not working and I cannot see why. Probably simple but thanks of any suggestions -----------------------------...
  15. E

    Macro Fun

    I am currently working on a macro that generates 5 reports. These reports are then emailed to a user. If the report has no data then I want it to not be sent. Could someone suggest a way of doing this in the macro? Would appreciate any help or direction as this is my first week @ this job :)
Back
Top Bottom