Dear friends, I have single big table in Ms access 2k daabase and i need a way to copy this table and then populate my two already ready tables on sql server . I can use Migration tool but is there any way we can do it from Ms access like a form which executes the stored procedure or ODBC connection. what i am thinking is to create a ...
i have a database that is written in access. the access mdb file connects via ODBC to a local mysql database. i have a bunch of sql and vba code in the access file. i dont expect the database to surpass 100mb. currently it is around 10mb. i will need to have multiple user access. (no more than 10 users at a time) i need to convert this ...
Hello, I'm developing an application which needs to store large amounts of data. I cannot use SQL Server Express edition since it requires separate installation and our target customers have already loaded us with complaints about our previous release with SQL Server express. Now my choices are between SQL Server compact and Access. ...
ms-access is connecting to a local mysql database the following code returns an error: Public Function run_sql(strSql As String) On Error GoTo lblError CurrentDb.Execute strSql, dbFailOnError lblExit: Exit Function lblError: MsgBox Err.Number & ": " & Err.Description Resume lblExit End Function strSql = "DELETE FROM tblUs...
i have this problem: http://stackoverflow.com/questions/1355234/ms-access-could-not-delete and i found a potential solution here: http://support.microsoft.com/kb/240098 however it asks me to follow these steps: Open the delete query in Design view. On the View menu, click Properties. Set the UniqueRecords property to Yes. Save the ...
Can someone explain to me how VBA for Access could ship without a simple Max(x,y) Function? I know it can be done: IIf(x > y, x,y) but really... why? ...
The Microsoft Jet Database Engine Stopped The Process Because You And Another User how to solve this problem in ms acess. ...
I have two tables (persons and projects) which are in a many-to-many table, thus linked together by a third table persons_projects In ms access I now created a form showing data from the projects table. What I want is to have a subform showing all persons- datasets which participate in this project. In this subform it should also be po...
Good Day I have created a program in ms-access 2007, (in house program), Is it possible to create a stand alone program from access (.exe) thank you ...
is it possible to write data to AccessDB from Excel macro, how? I have a small MBD file where I want to import data from excel sheet? ...
these are both listboxes. why does one have brackets around it? [relationslct].Value = other_relations_lst.Value ...
when i am running the following code: listbox1.requery which query is this going to run? where can i edit this query? ...
the row source for a listbox looks like this: SELECT users.id, users.first, users.last, chavrusas.luser_type AS user_type, chavrusas.id, users.title, users.city, users.state, users.home_phone, users.email FROM Users INNER JOIN chavrusas ON Users.id=chavrusas.luser_id WHERE ((chavrusas.ruser_id)=id_txt and chavrusas.ended=false) AND (c...
access is connecting to a mysql database. the rowsource of one of a listbox is: SELECT...FROM something INNER JOIN... i cannot find this 'something' anywhere. does it have to be a table? ...
i am connecting access to a mysql db. i need to put together two statements and make them into one. for example: SELECT users.id, users.first, users.last, chavrusas.luser_type AS user_type, chavrusas.id, users.title, users.city, users.state, users.home_phone, users.email FROM users INNER JOIN chavrusas ON ...
i have a huge sql query that is attached to the rowsource of a listbox. the SQL statement seen here: http://stackoverflow.com/questions/1358642/ms-access-select-from-another-query actually returns the correct information if that information is under 2 records. however if it returns more than 2 records it still populates the listbox...
I am considering the use of a tab control on a parent form for which I would like to have around 20 tabs. Each tab I am considering the use of one or two separate sub forms. Each sub form will have varied complexity in coded logic. By taking this approach will I severally reduce the performance of my application? I am currently using thi...
I have a page in one of my client's websites that generates an extensive report pulling data from numerous tables throughout the website's MS Access database. One of the unfortunate architectural issues of the website is the existence of two nearly identical tables that represent the same "type" of data, but one is an "old" version and t...
What is the purpose of BOUND COLUMN property of listbox? ...
Hi, I am generating report in excel sheet(which is coming from Microsoft Access). For 100 records, it can generate the excel sheet in 2 to 3 seconds. But, it takes 10 minutes for more than 2000 records. Is there a solution or is there any other way to generate report in excel sheet? ...