How To Store And Access Reservation Data (was Small Project)
Jan 11, 2005
I have a project need to store the information of reservation. For example, somebody wants to reserve a laptop. She will sign in the date from calender to use. I would like to let the administrator to access the database and update the database in the intranet. Also the user who want to reserve a resource can access the intranet to fill a form, after approving it, she can borrow the resource. Of course, this is small database. And we also have a report on this.Do you have any idea how to do it? I appreciate.
View 1 Replies
ADVERTISEMENT
Jan 18, 2004
Hi,
I'm just about to launch a forum, and right now its built in ASP classic with an Access db. I origianlly used Access because most hosts charge extra for MS-SQL server. Recently I switched to Jodohost who offers Access, MS-SQL and MySql for at no additional cost. So now that I have the option, I would like to pick the best solution before I launch.
* My questions are...
- What is the best db solution to go with for a currently small forum?
- How problematic do you think a data migration would be in the future if I stayed with Access for now and upgraded to MS-SQL with a full forum?
- Is it just smarter to go with MS-SQL now, with an empty forum, regardless of any preformance issues because potential migration problems are a greater risk?
- At what point does the speed of MS-SQL at high volumes over come the potential lags in accessing MS-SQL if it is hosted on a different machine from the one hosting the webpages?
* And please keep in mind...
- I have no db training. I can muddle through Access well enough, but administrating MS-SQL I think might be another story
- This fourm will start off very small, but could grow to be quite large
- I may not stay with jodohost, and would therefore likely have to pay more for MS-SQL (which I woudl rather not do)
View 1 Replies
View Related
Dec 25, 2006
I want to store a small cirle in a text field. Can anyone tell me how I can enter it in ascii code.
Thanks
View 4 Replies
View Related
Jan 17, 2008
Hello,
I've created a Report Model Project that can be used by Report Builder to generate ad-hoc reports. I'm trying to create a connection string in my Report Server Project that points to the Report Model Project data source view.
All I can do is create a regular datasource, which bypasses the metadata contained in the Data Source View.
Basically I want my Report Server Project and my Report Builder reports to leverage the same metadata. Is this possible? If so how do I get the connection string?
Thanks!!
-Matt
View 1 Replies
View Related
May 29, 2008
For some reason in a Team Foundation Team Project that has multiple project types (SSRS, SSIS, WebSite, C# Business DLL...), the SSIS project makes itself the startup project to the team project. If I explicitly set another project as the startup project to the team project and then select an SSIS package in the SSIS project in the team project, the SSIS project becomes the startup project automatically.
I am using Visual Studio 2005 SP1.
View 3 Replies
View Related
Aug 27, 2007
I am trying to come up with a query for a reservation system for a small hotel. I have come up with 5 tables, of which only two will be used when searching for a vacant room. The first table is a roomTable and this contains info regarding the rooms at the hotel. eg room# floor, serviceStatus. The primary key in this table is room#.
The second table involved is a Session table. This table has a session number as primary key, and also has room# as foreign key. This table also contains a sessionType, startDate of a session and an endDate. Every time a room booking is made or a user is checked into the hotel a session is recorded into the sessions table.
When searching for room, the user supplies the date when the session should start and the date when this session should then end. I need a query that will enable me to pick all those rooms that are in the roomTable but do not have sessions running during / between the startDate and endDate specified by the user.
If anybody could be of assistance I would be most greatful
View 1 Replies
View Related
May 14, 2006
Hi,I am using Access 2000 to access a SQL Server 2000 database. The records areread only, and I can't make any changes to them. How can I change this? I'vechecked Help, but don't seem to be able to find what I need to know.Thanks! Jill
View 1 Replies
View Related
Dec 22, 2014
when to use table variable and temp table. i told the interviewer that when rows is less like hundreds or thousand then use table variable else use temp table.After that he asked that what do u mean by less data or thousand rows may be there are multiple columns involved with that less rows and make a huge data set.
View 3 Replies
View Related
Nov 14, 2003
I have recently moved from Access mdb to Access project.
I have found that for the same data, an MSDE database occupies more than double the size of an Acess database!
I had upsized a database with a table, comprising about 200,000 rows.
Where as the Access database occupied 40 mb, the MSDE database occupied 120 mb!.
Tried shrinking the database and reduced it to 113 mb.
Is this to be accepted?
Is there any equivalent of the very effective 'compact database' command of Access in SQL Server?
View 1 Replies
View Related
Jan 4, 2005
Hi all, we currently have an access databse with linked odbc connections to an SQL server database.
Performance wise I don't think this is great.
Anyone have any general information about doing an upgrade to a micrsoft project database, and what are the pros and cons of access projects compared to Access databases with linked tables.
About 30 -40 users currently hammer the access front end during the day.
View 2 Replies
View Related
Oct 11, 2006
I try to create a view in Access Project but in design view I only see "all columns" in a table. The individual columns are not listed. This happens only with a certain SQL Server database. Any suggestions ?
View 1 Replies
View Related
Nov 15, 2007
Not sure if this is the right place to ask but I'll try...
I have to execute an integration service package in an .adp project. In other words, click of the button on the adp window has to start a package or a job.
Can that be done? And if yes, how? I've been searching the Web but without success.
Thanks for your help.
View 7 Replies
View Related
Jan 3, 2008
How do I grant a user access to a particular project? I have set up some reports and want other users to look at them as a template to build their reports and keep getting projectname.rptproj.user is denied.
Thanks, Iris
View 5 Replies
View Related
Jan 12, 2007
Most of our users are using MS Access project to work with our data in SQL Server 2005. The problem we have is that in order for them to access the tables they need to be given db_datareader and db_datawriter permission on the database. Our goal is not to give access to the tables themselves but to views. Therefore, we've created several views and placed them into a particular schema. Now we want to give access to that schema, but when we assign select, delete, insert, and update to that schema user in ms access project aren't able to view these tables. When we give them db_datareader permission they are able to see the views but in parentencies does not show the correct schema; therefore, when you try to open that view it errors out saying it doesn't exist. Also since they now have db_datareader they are also able to access the other view and tables in the database.
What we are looking to do is give our Access Project users the permission to link to SQL Server 2005 views by schema only.
View 9 Replies
View Related
Oct 21, 2006
Sorry if this is the wrong forum for this, but was as close as I could get. I am an amateur stumbling thru this to "learn by doing". I am trying to set up an access front end for a SQLExpress database, currently all local for experimenting. Trying to import Excel data to a table in the database, using Access "get external data" function. I get errors and the data wont import. Error message won't give me a clue to what is wrong. All fields are named the same. If I convert the excel to a csv or tab delineated, it imports correctly. Just not the excel. Any ideas?
View 1 Replies
View Related
Jun 9, 2006
Hallo
I am getting the overflow? message (MS SQL Server Database Wizard) on attempt of creating a project in MS Access using SQL Server 2005 Express Edition. I am actually able to open an existing DB.
I was wandering why is this happening and what can I do to create such a project
Thank you
View 4 Replies
View Related
Apr 1, 2004
hi there,
we canīt open most of the sql server tables from our Access
project any more, which has to be related to collation or
extended property problems.
trying to open any table will result in the information
"The stored procedure has been executed but did not return
any records" after the first try
and later on nothing will happen any more; tables wonīt
open.
basically this started to happen after recreating the sql
database due to resolution 1 in Microsoft Knowledge Base
Article - 318989:
collation of the server is Latin1_General_CI_AS
collation of the old database was
SQL_Latin1_General_CP1_CI_AS, which led to the error
described in the article.
collation of the new database is set to <Database
Standard>, now i have the problems described above.
anybody some good help on that?
ps: we canīt really rebuild the user database all the
time, because we got flight data in about 4 billion
records in there, so we will need anything quick and
easy...
thanks
ron
View 2 Replies
View Related
Jul 20, 2005
How to pass parameters to MS Graph (row source is a stored procedure withparameters) placed in Access Project form ?The problem is that there is no Input Parameters property on the graphobject...
View 1 Replies
View Related
Mar 16, 2006
I continue to receive an error that states "The version of Microsoft Access doesn't support design changes with the version of Microsoft SQL Server your Access project is connected to. See the Microsoft update website for the latest information."
I'm using Access 2003 that I ran a database through the Upzinging Wizard with a copy of SQL Server 2005.
I have searched the Office Update pages and can't locate anything that helps, although I'm sure I'm probably missing something.
Any suggestions?
Thanks in advance,
Mike Duke
View 9 Replies
View Related
Jan 8, 2007
Hello,I have windows small business server 2003 premium installed, I can see the server service manager but can not start any service(nothing is listed).How do I set it up?
I can not find the enterprise manager to create a database.Thanks for your help
View 1 Replies
View Related
May 19, 2005
I am building a small app that will display availability data for properties. I have a calendar that displays the dates for a whole year in month rows with each days colour representing the availability status, i.e. booked, on hold etc.
My question is about how to store these dates in the db. At the moment I have the table below:
TABLE Availability [PropertyID] [int] NOT NULL , [StatusID] [tinyint] NOT NULL , [StartDate] [smalldatetime] NOT NULL , [EndDate] [smalldatetime] NOT NULL
I was planning on having four status's for any given date, unknown, available, on hold or booked.
Displaying the dates has proved pretty simple but updating availability means I would need to query the db to see if any of the dates overlapped, I would then have to add the new date range/status as well as change any date ranges that overlapped, either in the sp or in the code and this is what made me wonder if there was a better way.
Does this sound a reasonable approach? Any advice or pointers would be greatly appreciated, This is the first time I have had to store date ranges and I want to make sure I am doing it right.
View 2 Replies
View Related
May 8, 2007
Hi, I'm having issues trying to get a query working the way I want, it maybe
that i'm overly complicating things though.
What I have done so far is have 2 seperate tables one holding details about
the item to be booked out with an ID the second linking to the Item via the
ID and also having the startdate and the enddate of the booking, thus an item
will have multiple rows in the bookings table for multiple bookings.
What I want to have is a "quick" booking method where a user enters the
startdate they would like and the enddate, a drop down is then filtered (via
a query) returning only the items that are avalible.
The issue i'm having is that because my bookings have multiple rows for each
item, for what maybe true in the rules for an item in 1 row maybe false
alittle later - i which case the returned data i am getting is incorrect!
Hopefully I have made sense, and maybe someone can help?
my querry for the filter so far: -
SELECT DISTINCT DeviceDetails.Device_ID, DeviceDetails.Device_Name
FROM DeviceDetails LEFT OUTER JOIN
BookingDetails ON BookingDetails.Device_ID =
DeviceDetails.Device_ID
WHERE (BookingDetails.Bookout_Date IS NULL) OR
(BookingDetails.Bookout_Date >= GETDATE()) AND
(@Dateout <= BookingDetails.Bookin_Date) AND (BookingDetails.Bookout_Date >=
@Datein) OR
(BookingDetails.Bookout_Date >= GETDATE()) AND
(@Dateout >= BookingDetails.Bookin_Date) AND (BookingDetails.Bookout_Date <=
@Datein)
View 1 Replies
View Related
Nov 9, 2015
We are running with a 2 node windows cluster having three SQL instances on it.Â
OS: Windows server 2008R2 SP1
SQL : SQL server 2008R2 (10.50.6529)
Currently both nodes have 256 GB or memory and we are having multiple auto failover for resources. What will be the best practice for OS memory reservation (OS+tools) so that we can set SQL max memory settings accordingly?
View 5 Replies
View Related
May 16, 2006
Hi,
When using an Access Project 2002 connected with SQL Server Express in OLE DB it's impossible to work in creation mode. A message explains that this Access version is not compatible with this SQL version.
Is there a service pack ?
View 1 Replies
View Related
Jan 31, 2007
Hello,
I have an Access .adp file that's connected to a SQL Server. I can run small queries just fine, but some of my queries take several minutes to run. When I try to run a lengthy query I get an error message that says "Timeout Expired".
I believe that this error is the one that is described here on MSDN online:
http://support.microsoft.com/kb/243464
I tried to implement a solution similar to this in .adp file by creating this subroutine:
----------------------------------------------
Sub BypassTimeout()
CurrentProject.Connection.CommandTimeout = 0
MsgBox "The subroutine ran"
End Sub
-----------------------------------------------
I know that the subroutine is running because I'm seeing the message in the MsgBox statement. (This sub runs everytime the .adp file is opened).
However, doing this still doesn't seem to prevent me from getting the "Timeout Expired" error message when I try to run a lengthy query.
Does anyone know a way around this? I believe the default timeout is 30 seconds ... but SURELY microsoft did not intend for .adp files to not be able to run queries that are longer than 30 seconds.
View 5 Replies
View Related
Jan 1, 2006
Hi
I have conntected an Access 2003 project to a database in SQL Express and when I try to create a new view or stired procedure I get the message
This version of Microsoft Access doesn't support design changes with the version of Microsoft SQL Server your project is connected to. See the Microsoft Office Update Web site for the latest information and downloads (on the Help menu, click Office on the Web). Your design changes will not be saved.
Is it a limitation or have I not got the appropriate permissions set up
And if it is a limitation does it matter
Thanks in advance
Gordon W
View 6 Replies
View Related
Mar 6, 2008
I am trying to filter the records in an Access2003 project form using data from a control in a different form. I define the variable in form1 as RegKeyWord. The record source for form2 ends with WHERE CustomerName Like RegKeyWord. I receive the error Invalid column 'RegKeyWord'
Can anyone help?
View 1 Replies
View Related
May 10, 2006
Looks like the Office 2003 MS Access has no support for creating a linked server and implement design changes. While you could link to the SQL 2005 tables, which show up as queries in MS Access 2003, any further use of the linked queries are not supported unless the Access 2003 version came out after the SQL 2005 release. What kind of an update is needed, or fix is needed so that Access projects can be developed?
View 6 Replies
View Related
Oct 17, 2007
Hello, all
We are trying to work out a memory problem associated with a SQLCLR procedure we have developed.
This procedure will run properly on a SQLExpress box, but fails with an Insufficient Memory error (701) when run on our 32-bit enterprise edition server on W2K3 Enterprise Server. The server has 3.25 GB of RAM, and does *not* have the /3GB switch enabled; AWE is *not* enabled on SQL Server.
I initially suspected the problem was due to the idiosyncracies of how the BPool is allocated on SqlExpress and its 1GB buffer pool limitation, giving a 1GB MemToLeave region for SQLCLR allocations -- substantially larger than the default available on the server with it's default 256MB allocation (+128MB for thread stacks). That seemed to explain why a memory problem might not manifest itself on the client, but would on the server. I then altered the server to include an explicit "-g" parameter at startup, reserving 512MB for MemToLeave, but the query still fails with the same memory errors. I've tried values as high as 1GB (-g1024), but none have worked Our DBA has installed a recent hotfix associated with certain memory errors, to no avail.
It appears that the server will max out the CLR allocations at 102MB, regardless of the presence of the -g parameter. Could it be that the MemToLeave region really is that severely fragmented? There are still log messages indicating failures to reserve virtual memory...
One thing I notice is that the buffer's VM Reserved value never seems to change regardless of the value of the "-g" option. I would expect to see it decrease by the amount specified as reserved, eg -g 768 should leave, for example, something like 1.2GB VM Reserved for buffer pool allocation, but it doesn't. That tells me I'm not really establishing a larger MemToLeave area. Is this expectation incorrect?
Bottom line, we don't know why this procedure is running on the server, but not in SqlExpress. It is a procedure that connects to a remote Oracle database and collects about 14,000 records, but dies after sending about 7,000 or so records when run on the server. Again, the same query running against the same code on a SqlExpress box works perfectly.
Any thoughts or suggestions welcomed and greatly appreciated.
David
View 4 Replies
View Related
Jul 20, 2005
There is a form in an Access Project (.adp, Access front end with SQLServer) for entering data into a table for temporary storing. Then, byclicking a botton, several action stored procedures (update, append) shouldbe activated in order to transfer data to other tables.I tried to avoid any coding in VB, as I am not a professional, but I havefound a statement in an article, that, unlike select queries, form's InputProperty can't be used for action queries. Therefore, parameters can bepassed to action stored procedure only by using ADO through VB.As I'm not very familiar with VB, I had to search in literature.So, this is a solution based on creating Parameter object in ADO and thenappending values to Parameter collection.Please, consider the following procedure I created for passing parametersfrom form's control objects (Text boxes) to a stored procedureDTKB_MB_UPDATE:Private Sub Command73_Click()Dim cmd As ADODB.CommandSet cmd = New ADODB.Commandcmd.ActiveConnection = CurrentProject.Connectioncmd.CommandText = "DTKB_MB_UPDATE"cmd.CommandType = adCmdStoredProcDim par As ADODB.ParameterSet par = cmd.CreateParameter("@DATE", adDBTimeStamp, adParamInput)cmd.Parameters.Append parSet par = cmd.CreateParameter("@BATCH_NUMBER", adVarWChar, adParamInput, 50)cmd.Parameters.Append parSet par = cmd.CreateParameter("@STATUS", adVarWChar, adParamInput, 50)cmd.Parameters.Append parSet par = cmd.CreateParameter("@DEPARTMENT", adVarWChar, adParamInput, 50)cmd.Parameters.Append parSet par = cmd.CreateParameter("@PRODUCTION", adVarWChar, adParamInput, 50)cmd.Parameters.Append parSet par = cmd.CreateParameter("@SAMPLING_TYPE", adVarWChar, adParamInput,50)cmd.Parameters.Append parcmd.Parameters("@DATE") = Me.DATEcmd.Parameters("@BATCH_NUMBER") = Me.BATCH_NUMBERcmd.Parameters("@STATUS") = Me.STATUScmd.Parameters("@DEPARTMENT") = Me.DEPARTMENTcmd.Parameters("@PRODUCTION") = Me.PRODUCTIONcmd.Parameters("@SAMPLING_TYPE") = Me.SAMPLING_TYPEcmd.ExecuteSet cmd = NothingEnd SubUnfortunately, when clicking on the botton, the following error apears:"Run-time error'-2147217913 (80040e07)':Syntax error converting datetimefrom character string."Obviously, there is some problem regarding parameter @DATE. In SQL Server itis datetime, on the form's onbound text box it is short date (dd.mm.yyyy)data type. I have found in literature that in ADO it should beadDBTimeStamp.So, what is the problem ?Greetings,Zlatko
View 2 Replies
View Related
May 20, 2006
I can pass a parameter from an Access Query to an Access Report (MDB) by entering [Select Date] in the Query criteria and by placing an unbound control with a control source =[Select Date] on the report. I can't get this to work from a SQL Function Criteria to an unbound control on the Access Data Project Report. In the Function Criteria, I enter @SelectDate. In the Report control, I enter @SelectDate and it gives me an 'Invalide Column Name' error. Any idea how I can pass a parameter from a SQL Function to an ADP report?
THANKS!
p.s. I tried searching for other postings on this without any luck.
View 1 Replies
View Related
Oct 31, 2006
One single table when openen from a MSAccess project file gives error:
The setting for DecimalPlaces property must be from 0 through 15, 255 for Auto (default).
After which the table is openend normally. I don't recall setting Decimal Places to the table. The only numeric fields are two INTs that are also ID's (PK and FK). This error occurs also when recreating the db project. These fields can not be edited eitther from MSAccess nor Enterprise Manager.
What can be done on the table, resp. MSAccess to change this?
View 3 Replies
View Related
