Recent content by CJKCyclone

Background - Access 2k2 front end and backend application....Transferred the backend to SQL Server 2K. Getting error that "You must use DBSeeChangesoption with OpenRecordset when accessing a SQL Server table that has IDENTITY column" When I do this...my code looks like this: Dim db As...

Put in the code for dbSeeChanges as described in another... post and I am now getting "ODBC - Call failed" ARGHH!

I have an application with an Access 2002 front end linked to Access 2002 db. I am trying to convert the db side to SQL Server 2000. Everything appears to link up properly and I can run most everything with no problems....upon further testing I have gotten this error and I am stumped... "You...

I need to find a way to integrate our software that was created in Access 2000 with another business system. Our plan is to just export a file (flat text, excel, etc) containing the data to a certain directory and the business system will come get it on a daily basis. I'm wondering if it is...

to pop up? Access 2000 We have a form where we can type a path to a database file. We'd like to have the functionality to click on a button that says "browse" and have a browse dialog box pop up. Any ideas? TIA

Bueller?...Bueller?...Bueller? Anyone?...Anyone?

We have software that has an Access front-end talking to a separate access database file. Is there a way I can make the front-end file ask me which Access database I'd like to connect to at start-up? To clarify, I want a one to many relationship between the front-end and the database. I realize...