Search results

Hi, yes there are no views used in this database. It's all tables. Thanks.

I also did a test run w/ using the SQL statements gathered from the pass-through query. It runs, but I get the same error message if I don't have db_ddladmin permissions. DoCmd.RunSQL "INSERT INTO tblEmployeeInfo SELECT qryServerEmployeeInfoNew.* FROM qryServerEmployeeInfoNew;"

Thanks for the reply. I'm unsure whether DoCmd.Runsql will work in this case because I'm pulling data from one server's db to another server's db. So the sql statement doesn't seem to execute...but i don't get an error message either... Dim strSQL as string strSQL = "INSERT INTO...

Hi, I have a client-server setup with a SQL Server 2005 backend, with an Access 2003 client front-end forms. On this front-end I have several pass-through queries which basically transfer some records from another SQL Server 2005 database to this database, on different servers. Through VBA, i...

Hi again, something's been bothering me and perhaps I've been confused but, when I created my linked tables, I created a File DSN long with it. I then used this File DSN to connect to the sql server. But, when I look at the linked table's Description, nowhere does it point to that DSN file...

Thanks for the reply again WayneRyan. Ok I removed the <=29 from the GROUP By and it works now! Thanks a lot for your help! I learned a lot about how GROUP BY works now just from this problem alone.

Thanks for the reply WayneRyan, I followed your suggestion by removing the =True from the HAVING portion, but the same error message persist. I tried another approach by inserting this statement into SQL Management Studio and tried executing the query against the db and an error popped up...

Hi, I have a problem with my query which works fine prior to upsizing to SQL Server. Now I have an Access Front-end with SQL Server (2005) back-end client/server setup. This problem has bugged me for over one full day and I can't find anything that seems to solve it. Any suggestions is...

Thanks for all the replies! I was thinking that once a link has been established via DSN file, each table will have a connection string already inserted to connect to it, thus the DSN is no longer needed for the remainder of the connection. But then I was thinking at how it would 'refresh'...

Hi, I have an Access Front-end and a SQLServer (2005) back-end setup. The tables are basically linked into the Access front-end via ODBC link with a DSN file. In addition, the authentication is through Windows Authentication. My question is, once the Front-end Access file has established the...

Thanks for the reply Bee, What I meant was whether TFS provides source control support for MS Access. I understand that VSS is a viable option for Access, but wanted to know whether TFS has the same capability for Access. TFS seems to have a feature of source controlling in Visual Studio, but...

Hi, I am trying to source control my modules and macros for my Access 2007 databases. I have installed the office developer's kit which enables the Source Control feature. In the features of Source Control, MS mentioned that developers may use Visual Source Safe or 'other' source control apps...

Thanks for the reply SQL_hell. This is exactly what I wanted. One question though... I'm using SQL server 2000. I see the append (which is by default) but I do not see 'replace data'. I do see 'Delete rows in destination table' so I'm assuming what they're doing is removing the SQL server table...

Hi, I have upsized my Access 2000 back-end tables into SQL Server 2000 successfully and did a simple table-link of those to my Access front-end. I did many testing with test data, but now it's time to move in the live data (in Access). Is there a way to move just the Access data into the...

Thanks for the reply moniker. I'm not too familiar with the DoEvents function. But I will give it a shot. Thanks! In addition, when importing to the temp folder, I placed a break right after the parsing so that I could check where the last record was broken before the EOF. Sure enough it was...

Ok I don't know but it appears that I had the rst = db.openrecordset("tmpStudentImport", dbOpenSnapshot) line declared before it was imported so that may have caused the problem?? So my guess is, the tmpStudentImport was left open while an import was going on, therefore the EOF may have...

Hi, I have a relatively slow machine and it seems to be affecting the way I import an excel file data to a temp table, while immediately looking into that temp table afterwards. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "tmpStudentImport", "C:\StudentImport.xls", True Do...

Yah, basically that's what I've been doing :( (the manual export). Mmm, write code to transfer...not a bad idea. I'll think about it thanks!

Hi, in Access (2003)(VB) there's an export feature to export module/macro code onto text. Unfortunately there is no easy way to export all modules/macros at once. Further more, macros need to be converted to VBA code first, then exported. Is there a wizard or some sort that does this all at...

Ahh I see. Thanks again!