Search results for query: *

This is an image of the error that I am getting when I try and link a Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server...

Anyone submitting the form on the internet was getting the prompt for the login and password. It was like network authentication was suddenly being required. The hosting company re-installed the front page extensions and rebooted the server and the form started working i.e. not requiring a...

Hi There - I have a form made using front page. It was working fine, then all of the sudden after submitting the form, it requested a login and password. beth@integratedresourcemgmt.com

Hi There - I am trying to create SQL statement in Enterprise Manger where the columns are combined like: [FirstName] & " " & [LastName] AS Expr1 It gives me the error: "invalid column name". Is there a way to combine columns that anyone knows of? Thanks, Beth beth@integratedresourcemgmt.com

Hi There - I am trying to find out if it is possible to create a query in an access data project (.adp) located on my computer that links to a sql database. I was able to generate a query in Enterprise manager, but couldn't figure out how to save it. I am unsure, but I guess the routine would...

Hi There - I am not running SQL server. It is just an .adp that was generated based on the data in the SQL server. If you open it via FTP with a connection to the web files it updates automatically on my hard drive. That is why I don't want the data disturbed and want to import the tables...

Hi There - I guess I am confused. I ran the code above and it won't work with an .adp as you can't link the .adp tables. But it does work perfectly with an .mdb. Imported all the tables very well. I am wondering is there any code that will import all the tables from an .adp. I tried to...

Hi - I tested the code written on 9/11/03 above and it works perfectly importing from an access database, but it links the tables rather than imports them. I just need to find a way to import the tables from an .adp. I am searching and found one article on the Microsoft knowledge base, but it...

Hi - We created a database as an .adp from the SQL server. We want to be able to run queries in on the data and have created an MS Access database so that the .adp is not disrupted as it is a live connection with the SQL server. So I need to find a way to import data from the .adp into the...

Hi - I was wondering if this will work with a Microsoft Access Project or .adp file? I tried changing this line DoCmd.TransferDatabase acLink, "Microsoft Access", _ to DoCmd.TransferDatabase acLink, "Microsoft Access Project", _ and when I ran it I got the message...

Hi - I was able to get my system to delete multiple tables, but now I need to import multiple tables from an .adp. named "sql_db". Is there a way to import all the tables from this database at one time? I am going to search around, but if anyone has any information or can help with...

Hi - I am getting closer: Function DeleteImportErrorTablesNew() Dim db As DAO.Database, t As DAO.TableDef, i As Integer Set db = CurrentDb() For i = db.TableDefs.Count - 1 To 0 Step -1 Set t = db.TableDefs(i) If t.Name Like "ML*" Then...

Hi Paul - Thanks I did finally find those MSys tables by changing the view. Anyway, thank you for your help. I ran the module and I got a compile error "next without for" highlighting this line: Next tbl I am trying to read everything I can find. So, i'll look around but if you...

Hi Paul - Thanks I set the Microsoft DAO 3.6 Object Library. When I run the function, I am getting a "run-time error 3211" that says "The database engine could not lock table "MySysAccessObjects" because it is already in use by another person or process." It...

Hi and Thank You! I created the module and added the run code in the macro. I ran the macro and got a compile error at: tbl as TableDef "user defined type not defined" I named my module: "deletetables" and put the following in the run code's (macro)function: deltables...

Hi - Is there a simple macro or query that can be run to delete all the tables in a database? Thanks, Beth beth@integratedresourcemgmt.com

Great Thanks. Now I am stuck on the syntax to get to the source database. At "Source" I am typing: c:\mydocu~1\goorin\Web\_datab~1\pensac~1.mdb and or c:\mydocu~1\goorin\Web\_datab~1\pensac~1 I am getting "invalid argument". I may need to simplify the location. Any...

Hi - I need to figure out how to import access tables from one database to another using a macro. I set the action on the macro to "RunCommand" and at the command line I see an option to set it to "Import". Now I just need to figure out how to import some tables from...

Hi - We have moved 6 end users over to Outlook Express from Outlook 2000 & 2003 and they are now sucessfully sending and receiving emails. We checked with the host and there is no record of issues. I set up an email client with one of the end users names in Outlook Express and was able to...

Hi - We checked the incomming and outgoing mail servers and they have not been changed by the AV software. Actually, this client has a firewall. That was checked as well. Across the board for almost all the end-users Outlook 2000 is starting to fail. Does this make any sense? -Beth...