Thanks for the tip. I was able to determine in the expanded view that the text file had some security on it that disabled me from viewing it. So, after some permissions and folder sharing enabling, it works like a champ.
Thanks again!
I checked those things. SQL Server agent is running but I did check the log and it tries to run when I wanted it to but is "failed" on each attempt.
I did a right click on that area (the job in particular) and clicked on "Start job." I din't notice anything change but then again, I need to...
I have a text file that I want to import into my database on an hourly basis. I set the job up to run at 15 minutes after the hour yet it doesn't run unless I manually execute it. Is there a step I am missing or somewhere I can go to find out what I am asking for is not happening?
Oh yeah, it is that easy and I can view all day the linked table. It is only when I open the table up to edit it that I get the error message (something like) "recordset is not updateable."
I think that the fact that it is a separate, different flavor and linked table says to...
WOW! You have just the problem that I am trying to create. I want a handful of people to be able to update the SQL yet the majority of people will be using a read-only ASP utility. If you are having difficulty getting this turned off, maybe it won't be hard to allow it.
Have you discovered...
I was originally in this situation, but now find myself needing to migrate the main table to SQL and I am going to front end with ASP code. I do want the MSAccess database front-end to stick around though for just a few individuals that will update the SQL table. All the other users will just...
I have found that moving the main table off to SQL and linking it while maintaining the other elements (forms, queries, macros, etc.) has worked wonders. In fact, if you are bold enough, advance it all to ASP and the speed becomes quite incredible.
I have an MSAccess database that is queried using the standard set of forms, queries, macros and reports. I am going to move the main table to SQL and access the database with ASP pages as these functions are going to be integrated into a website. I do however have a handful of individuals...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.